> 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@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)