MySQL driver not getting registered

[Danish Shaukat]

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 ]

[jay vas]

could you show the stack trace ?

[jay vas]

All you need to do is specify the DataSource... if youre
using MySql connector,
the class is : com.mysql.jdbc.jdbc2.optional.MysqlDataSource

import com.mysql.jdbc.jdbc2.optional.MysqlDataSource;


MysqlDataSource dataSource = new MysqlDataSource();
Dao()
{
dataSource.setUser(usr);
dataSource.setUrl(url);
dataSource.setPassword(pswd);
dataSource.setServerName(srvr);
}

public Connection getConnection()
{

return dataSource.getConnection();

}