Menu
Download Free Trial

Must contain either ‘Jdbc’ or ‘DataSource’

Hi, I am trying to configure Flexmonster with Mondrian, I got the FlexMonsterProxy running, but I got this error:

Mondrian Error:Internal error: Connect string 'Catalog=/WEB-INF/XX.xml' must contain either 'Jdbc' or 'DataSource'

I think the flexmonster.config is not ok, what am I missing?

CONNECTION_STRING=http://localhost:8080/pentaho
JDBC_DRIVER_JAR=./mysql-connector-java-5.1.37.jar
JDBC_DRIVER_CLASS=com.mysql.jdbc.Driver
CATALOGS_PATH=/WEB-INF/
PORT=50006

6 answers

Public
Roman Petrusha Flexmonster February 26, 2016

Hi!
CONNECTION_STRING means connection string to the database. If you work with mySQL the correct configuration is:

CONNECTION_STRING=Jdbc=jdbc:mysql://localhost:3306/foodmart?user=root&password=password;JdbcDrivers=com.mysql.jdbc.Driver;
JDBC_DRIVER_JAR=drivers/mysql-connector-java-5.1.37.jar
JDBC_DRIVER_CLASS=com.mysql.jdbc.Driver
More samples how to connect to mySQL you can find here: http://www.connectionstrings.com/mysql/

Does it help?

Public
Madarasz Istvan February 26, 2016

I work with Oracle

Public
Roman Petrusha Flexmonster February 26, 2016

Here are the samples for Oracle http://www.connectionstrings.com/oracle/

Please note if you prefer to work via XMLA protocol you don’t need any server-side tools

Public
Roman Petrusha Flexmonster February 26, 2016

István,

In the download package please choose “Configured for XMLA” and download the appropriate sample.

Regards,
Roman

Public
Madarasz Istvan February 26, 2016

Do you have an example configured with Mondrian/Oracle? 

Public
Roman Petrusha Flexmonster February 26, 2016

Can we arrange the brief phone call or skype?
Could you send me your contacts on help@flexmonster.com?

Please login or Register to Submit Answer