Must contain either 'Jdbc' or 'DataSource'

posted on February 26th, 2016

Answered

Madarasz Istvan asked on February 26, 2016

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 by email?

Must contain either 'Jdbc' or 'DataSource'

6 answers

Please login or Register to Submit Answer