Search code examples
mysqljndipentaho-report-designer

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

Solution

  • 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