I had a problem somewhat simular to that. Make sure you have access to the driver in the bean class. Maybe a required library or something. Tim
-----Original Message----- From: Meichun Li [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 17, 2002 12:01 PM To: Tomcat Users List Subject: No suitable driver Hi, I am suing Oreilly books wrapper class for connection pool. It works fine in the servlet class while I created a datasource using ds = new DataSourceWrapper(jdbcDriverClassName, jdbcURL, dbUserName, dbUserPassword); But it doesn't work in the javabean class using the same code: ds = new DataSourceWrapper(jdbcDriverClassName, jdbcURL, dbUserName, dbUserPassword); No problem while compiling. But there is run time error: No suitable driver. I print the stack error in the end of the message. There should be no problem in the classpath setting. I tried to find the driver in the javabean class and the driver can be found. Related codes: try { Class.forName("org.gjt.mm.mysql.Driver"); } catch ( ClassNotFoundException coe) { System.err.println("Class not found " + coe.getMessage()); } Why it is working in servlet but not in javabean ? I've searched the archive but couldn't find helpful information. Any help are greatly appreciated! java.sql.SQLException: No suitable driver at java.sql.DriverManager.getConnection(DriverManager.java:543) at java.sql.DriverManager.getConnection(DriverManager.java:183) at org.ibiblio.sql.ConnectionPool.<init>(ConnectionPool.java:38) at org.ibiblio.sql.DataSourceWrapper.<init>(DataSourceWrapper.java:21) at org.ibiblio.osprey.DataSourceBean.getMaxID(DataSourceBean.java:34) at org.ibiblio.osprey.TestDataSource.main(TestDataSource.java:16) Regards, Meichun -- Meichun Li Ibiblio.org 919-962-5646 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
