Deepesh Deepesh - 1 year ago 134
MySQL Question

Error while connecting to a database: "Invalid Datasource"

I'm working in Pentaho Report Designer 5.2. While trying to connect to a MySQL database using JNDI I'm facing an error saying

Invalid data source:'openflights'

but there exist a table "openflights" in my database.

Help on this would be much appreciated. Thanks!
Error screenshot

Here is the JNDI Configuration

#MySQL - openflights

Table openflight

Answer Source

Where have you defined the JNDI details?

change DRIVER value to com.mysql.jdbc.Driver

add JNDI in "C:\Users{YOURUSER}.pentaho\simple-jndi\" then stop the bi server and lauch again

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download