I am trying to create a connection in Rational Application Developer. I am tryig to connect to MySQL.
My Connection Details are:
Database: myschema
Host: localhost
Port no: 3306
JDBC driver class: com.mysql.jdbc.Driver (also tried: com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource)
Class Location: ...workspace1\MyProjectWeb\WebContent\WEB-INF\lib\mysql-connector-java-3.1.10-bin.jar
Connection URL: jdbc:localhost:3306:myschema
Then I click
Test Connection and get the folowing message: "No suitable driver" (or "MysqlConnectionPoolDataSource incompatibe with java/sql/Driver")
Has anyone managed to connect to MySQL Successfully in RAD6?
If so, what are your connection settings?
I am trying to do 'Bottom-up' creation of Entity EJBs. But can't connec to the database.
Any advise welcome.
Thanks