Hi,
My server application is deployed on Resin 3.0 and the database is MySQL.
I am using MySQL Connector/J 3.1
JDBC driver for connecting to MySQL database.
I have tried setting the system properties and then calling DriverManager.getConnection(�) method for establishing connection.
I have also tried calling Class.forName( dbDriver ).newInstance() and then calling DriverManager.getConnection(�) method for establishing connection.
In both cases I get the exception: �No Suitable Driver Found�.
After trying out various things the following approach finally appears to work.
Class.forName( dbDriver ).newInstance()
//yes, I have to manually register the driver with the DriverManager
DriverManager.registerDriver(driver)
DriverManager.getConnection(�)
It seems as if the driver is not being registered with the DriverManager even when Class.forName(...) is being called. I can�t find an explanation for this.
Danish
[ May 05, 2006: Message edited by: Danish Shaukat ]