tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <fachhochschule.burkh...@daimlerchrysler.com>
Subject Re: No Suitable Driver Error -- Still No Success
Date Wed, 04 Feb 2004 06:10:15 GMT




> Hi ,
>
> I am getting the following error in JDBC connection pooling. Error log
> and other details are as follows:
>
> Please help !!
>
> Regards
> Abhay
>
> Caught while creating a connection in EPP
> dB:=org.apache.commons.dbcp.SQLNestedException: Cannot create JDBC
> driver of class '' for connect URL 'null', cause: No suitable driver


Hi Abhay,
here I had the same problem some time ago. I can't reproduce exactly
how we solved the problem, but we solved it ;-)

Here's a Context from my server.xml:

<Context
    path="/idp"
    className="org.apache.catalina.core.StandardContext"
    cachingAllowed="true"
    charsetMapperClass="org.apache.catalina.util.CharsetMapper"
    cookies="true"
    crossContext="false"
    debug="9"
    displayName="displayName"
    docBase="C:/java/tomcat4.1.29/webapps/idp"
    mapperClass="org.apache.catalina.core.StandardContextMapper"
    privileged="false"
    reloadable="false"
    swallowOutput="false"
    useNaming="true"
    wrapperClass="org.apache.catalina.core.StandardWrapper">
  <Resource
      auth="Container"
      name="jdbc/idp"
      scope="Shareable"
      type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/idp">
    <parameter> <name>maxWait</name> <value>5000</value> </parameter>
    <parameter> <name>maxActive</name> <value>40</value> </parameter>
    <parameter> <name>password</name> <value></value> </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:postgresql://127.0.0.1/idp</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>org.postgresql.Driver</value>
    </parameter>
    <parameter> <name>maxIdle</name> <value>2</value> </parameter>
    <parameter> <name>username</name> <value>stnt1</value> </parameter>
  </ResourceParams>
</Context>

and here's the according resource-ref from the web.xml:

<resource-ref>
  <res-ref-name>jdbc/idp</res-ref-name>
  <res-type>javax.sql.DataSource</res-type>
  <res-auth>Container</res-auth>
</resource-ref>

The postgresql.jar with the driver class resides in
$CATALINA_HOME/common/lib .

Good luck,
B. Burkhart


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: tomcat-user-help@jakarta.apache.org


Mime
View raw message