Deepesh Deepesh - 1 month ago 6
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
openflights/type=javax.sql.DataSource
openflights/driver=org.gjt.mm.mysql.Driver
openflights/user=pentaho_user
openflights/password=password
openflights/url=jdbc:mysql://localhost:3306/openflights


Table openflight

Answer

Where have you defined the JNDI details?

change DRIVER value to com.mysql.jdbc.Driver

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