javax.servlet.ServletException: DbcpDataSourceFactory: on jwsdp1.0 / tomcat 4.x

[Jim Mangione <jm...@carescience.com>]

Has anyone come across this error before when trying to access a database
connection pool resource?
I'm using Tomcat 4.1 shipped with Java's Web Services Development Pack
v1.0 and trying to connect to a mySQL database. Currently, I'm not
employing any web services features. Just trying to get this working!

javax.servlet.ServletException: DbcpDataSourceFactory: driverClassName is
required

When my application hit's the last line of this code (it's a simple JSP
app):
      Context initCtx = new InitialContext();
      Context envCtx = (Context) initCtx.lookup("java:comp/env");
      DataSource ds = (DataSource) envCtx.lookup("jdbc/cdePool");

The driverClassName is indeed defined in the config.xml, and it appears
from catalina.log that it loads without a problem (meaning it's finding the
jdbc driver).

Here's the config.xml snippet:
    <Resource auth="Container" name="jdbc/cdePool" scope="Shareable" type
="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/cdePool">
      <parameter>
        <name>driverClassName</name>
        <value>org.gjt.mm.mysql.Driver</value>
      </parameter>
      <parameter>
        <name>validationQuery</name>
        <value>select count(*) from testtable</value>
      </parameter>
      <parameter>
        <name>user</name>
        <value>monty</value>
      </parameter>
      <parameter>
        <name>password</name>
        <value>some_pass</value>
      </parameter>
      <parameter>
        <name>maxActive</name>
        <value>5</value>
      </parameter>
      <parameter>
        <name>maxWait</name>
        <value>1000</value>
      </parameter>
      <parameter>
        <name>url</name>
        <value>jdbc:mysql://localhost/TestDB</value>
      </parameter>
      <parameter>
        <name>maxIdle</name>
        <value>3</value>
      </parameter>
    </ResourceParams>

And the web.xml snippet from the application directory:
      <resource-env-ref>
            <resource-env-ref-name>jdbc/cdePool</resource-env-ref-name>

<resource-env-ref-type>javax.sql.DataSource</resource-env-ref-type>
      </resource-env-ref>

Has anyone seen this, or could offer advice?

Thanks!
-Jim
jmangione@carescience.com



--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>