DataSource and Driver Class loaded at runtime

[dav mrazek]

Hello i m loading the class for my jdbc driver at runtime. Once it is loaded how can i use it with the datasource or what is the way to go once it is loaded. I m having a ClassNotFoundException even after my class is loaded.
I m using commons DBCP BasicDataSource for the implementation of the datasource.
Thanks for helping.

[dav mrazek]

Here is my code :

public Connection connection() throws SQLException, MalformedURLException, ClassNotFoundException {
        Class driverClass = null;
        BasicDataSource ds = new BasicDataSource();
       
        URL[] urls = {};
        JarFileLoader cl = new JarFileLoader(urls);
        cl.addFile("/opt/netbeans-6.0/ide8/modules/ext/mysql-connector-java-5.0.7-bin.jar");
        driverClass = cl.loadClass(driverClassName);
        //ds.setDriverClassName("com.mysql.jdbc.Driver");
        //ds.setUsername(username);
        //ds.setPassword(password);
        ds.setUrl(url);//jdbc:mysql://[host][,failoverhost...][:port]/[database]
        
        return ds.getConnection();
    }

when i do cl.loadClass the class it s like if it was in the classpath no ?
Why Class.forName(driverClassName) wouldn't work after this ?
Thank you for helping.

[dav mrazek]

Here is my code :

public Connection connection() throws SQLException, MalformedURLException, ClassNotFoundException {
        Class driverClass = null;
        BasicDataSource ds = new BasicDataSource();
       
        URL[] urls = {};
        JarFileLoader cl = new JarFileLoader(urls);
        cl.addFile("/opt/netbeans-6.0/ide8/modules/ext/mysql-connector-java-5.0.7-bin.jar");
        driverClass = cl.loadClass(driverClassName);
        //ds.setDriverClassName("com.mysql.jdbc.Driver");
        //ds.setUsername(username);
        //ds.setPassword(password);
        ds.setUrl(url);//jdbc:mysql://[host][,failoverhost...][:port]/[database]
        
        return ds.getConnection();
    }

when i do cl.loadClass the class it s like if it was in the classpath no ?
Why Class.forName(driverClassName) wouldn't work after this ?
Thank you for helping.