Re: 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.