No Suitable Driver at dataSource.getConnection();
Hi all ,,
I had my application to connect to the database in a classical way
i.e. not a pooled connection. The method was as fellows
private void connect(){
try
{
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection(URL,"root","root");
stmt = con.createStatement();
isConnected=true;
}
catch(Exception e)
{
System.out.println(e);
}
}
Now I want to change that function into the following :
private void pooledConnection() throws Exception {
Class.forName("com.mysql.jdbc.Driver");
String connectURI = "jdbc:mysql://127.0.0.1:3306/
attendance_test";
DataSource dataSource = setupDataSource(connectURI);
con = dataSource.getConnection();
stmt = con.createStatement();
}
public static DataSource setupDataSource(String connectURI) {
org.apache.commons.pool.ObjectPool connectionPool = new
GenericObjectPool(null);
ConnectionFactory connectionFactory = new
DriverManagerConnectionFactory(connectURI,null);
PoolableConnectionFactory poolableConnectionFactory = new
PoolableConnectionFactory(connectionFactory,connectionPool,null,null,false,true);
PoolingDataSource dataSource = new
PoolingDataSource(connectionPool);
return dataSource;
}
I get an Error of a Suitable driver not found At the line that trues
to connect to the datasource
con = dataSource.getConnection();
The thing is I am 100% sure that the classpath is set properly of the
driver. Thats why the prioir method works .. But how come this doesnt
work.
I appreciate all your help guys.