Hi

I am having database connection problems. I'd be grateful for some help.

I am testing a connection in Metadata Editor and and get Invalid JNDI connection BlueDW : No suitable driver found for jdbc:mysql://dw1.uat.paypoint.net:3306

My JNDI name is BlueDW, the extract from jdbc.properties is
BlueDW/type=javax.sql.DataSourceBlueDW/driver=com.mysql.jdbc.Driver
BlueDW/url=jdbc:mysql://dw1.uat.paypoint.net:3306
BlueDW/user=****
BlueDW/password=****

I have copied mysql-connector-java-5.1.17.jar into meta-data-editor/ metadata-editor/jdbc/ and meta-data-editor/lib/

Here is more error detail:

org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database


Invalid JNDI connection BlueDW : No suitable driver found for jdbc:mysql://dw1.uat.paypoint.net:3306




at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)

...
at java.lang.reflect.Method.invoke(Method.java:606)
at org.pentaho.commons.launcher.Launcher.main(Launcher.java:110)
Caused by: org.pentaho.di.core.exception.KettleDatabaseException:
Invalid JNDI connection BlueDW : No suitable driver found for jdbc:mysql://dw1.uat.paypoint.net:3306


at org.pentaho.di.core.database.Database.initWithNamedDataSource(Database.java:435)
at org.pentaho.di.core.database.Database.connectUsingClass(Database.java:457)
at org.pentaho.di.core.database.Database.normalConnect(Database.java:399)
... 39 more


JNDI Name : BlueDW