org.olap4j.OlapException: No catalog named YYY could be found. BUT IT EXISTS.
Open Java API for OLAP
Brought to you by:
jhyde,
lucboudreau
Hi, I connect to OLAP SAAS with jdbc using standart way.
URL like that "jdbc:xmla:Server=http://XXX/OLAP/msmdpump.dll;Catalog=YYY"
When i test my connection and data get, everything works ok, catalog exists.
When I use it in normal application, with Spring, it gives "org.olap4j.OlapException: No catalog named YYY could be found."
I suggest, DriverManager work is wrong, possibly some config issue with Spring, maybe. I use BasicDataSource in spring.
Did someone meet issue like this? Or have any suggests ?
I'll post my code later. Any help appreciated, thanks.
It was really strange behavior in my controller logic, probably some wrong package. This tutorial explains well http://www.matthewgodding.com/articles/2010/2/27/getting-data-from-sql-analysis-services-using-java-and-olap4.html