You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Meichun Li <li...@metalab.unc.edu> on 2002/07/17 18:01:03 UTC
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: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: No suitable driver
Posted by The Kelley's <ti...@mindspring.com>.
That's what it sounds like. For some reason your bean class can't see the
driver.
Tim
-----Original Message-----
From: Meichun Li [mailto:lim@metalab.unc.edu]
Sent: Wednesday, July 17, 2002 12:20 PM
To: Tomcat Users List; timdona@mindspring.com
Subject: RE: No suitable driver
On Wed, 17 Jul 2002, The Kelley's wrote:
> 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
Thanks for the reply. Could you explain more detail about the access to
the driver?
In my bean class, if using the standard JDBC connection instead of using
the datasource, there is no probelm. Is this mean that my bean class could
access to the driver?
Thanks,
Meichun
>
> -----Original Message-----
> From: Meichun Li [mailto:lim@metalab.unc.edu]
> 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
>
--
Meichun Li
Ibiblio.org
919-962-5646
--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: No suitable driver
Posted by Meichun Li <li...@metalab.unc.edu>.
On Wed, 17 Jul 2002, The Kelley's wrote:
> 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
Thanks for the reply. Could you explain more detail about the access to
the driver?
In my bean class, if using the standard JDBC connection instead of using
the datasource, there is no probelm. Is this mean that my bean class could
access to the driver?
Thanks,
Meichun
>
> -----Original Message-----
> From: Meichun Li [mailto:lim@metalab.unc.edu]
> 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:
> <ma...@jakarta.apache.org>
> For additional commands, e-mail:
> <ma...@jakarta.apache.org>
>
>
> --
> To unsubscribe, e-mail: <ma...@jakarta.apache.org>
> For additional commands, e-mail: <ma...@jakarta.apache.org>
>
--
Meichun Li
Ibiblio.org
919-962-5646
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>
RE: No suitable driver
Posted by The Kelley's <ti...@mindspring.com>.
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:lim@metalab.unc.edu]
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:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>
--
To unsubscribe, e-mail: <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>