Tomcat database connection pool doesn't work. Please help!

From: correro (bchen_at_365rainbow.com)
Date: 12/22/03 

Date: Mon, 22 Dec 2003 00:14:59 -0600

I tried to set up a database connection pool by following exactly the instructions in Tomcat 5 JNDI Datasource HOW-TO. But I got the following exception:

org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null', cause:
java.sql.SQLException: No suitable driver
        at java.sql.DriverManager.getDriver(DriverManager.java:243)
        at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:743)
.. ...

Can someone tell me why? Here's some info about my environment:

OS: Windows 2000 Professional
J2SE: 1.4.2
Tomcat: 5.0.16
Database: MySQL 4.0.13
DB Driver: org.gjt.mm.mysql.Driver; com.mysql.jdbc.Driver

By the way, when I query the database using a conventional Connection created with DriverManager, it works.

Relevant Pages

  • Re: Cannot display ODBC login prompt - want to connect without DSN
    ... database without knowing anything beforehand except the driver name. ... need a connection string and different data sources use different connection ... ODBC, ADO, and VB Script. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: JDBC URL for Oracle Database With Failover (2 db servers)
    ... After you've loaded the driver, you can establish a connection using ... each form requires a database URL. ... For Oracle, the database URL has ...
    (comp.lang.java.databases)
  • RE: New JDBC 1.2 driver runs slower than JDBC 1.1; my db definitio
    ... If the support incident ends up verifying a slowdown in the new driver, ... New JDBC 1.2 driver runs slower than JDBC 1.1; ... I do think this would happen in general, not just for my database; ...
    (microsoft.public.sqlserver.jdbcdriver)
  • RE: Import external data - web query
    ... Your reply for my query is very extensive, this is for importing a file from ... The data source I want isn't listed in the Select Data Source dialog box. ... information used to connect to a database. ... Check your driver First, make sure you have the right ODBC driver (Open ...
    (microsoft.public.excel.misc)
  • Re: Please Help...
    ... After battling with config files, and reading and reading of various ... which mentioned using the Tomcat Admin tool. ... > database that is configured in the server.xml file. ... > connection which says to me server.xml entries are correct. ...
    (comp.lang.java.databases)