I have problem in using connection pool. I use Apache 2.0.49, Tomcat
5.0.19, windows 2000 server, MS SQL server 2000 + sp4
On the browser I see the
error: Cannot create JDBC driver of class '' for connect URL 'null'
on Tomcat monitor, I see the message:
Apr 29, 2004 3:36:25 PM org.apache.jk.common.HandlerRequest decodeRequest
WARNING: Error registering request

The url and driver class is not find. bellow is my configuration. Please
forward instruction. Thanks a
lot.

1) I copy the three jar files to \common\lib in %catalina_home% from
C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC

2) MY webapps/ROOT/web-inf/web.xml is:
 ...
 <resource-ref>
 <description> JDBC Driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver</description>
 <res-ref-name>jdbc/DBName</res-ref-name>
 <res-type>javax.sql.DataSource</res-type>
 <res-auth>Container</res-auth>
 </resource-ref>
</web-app>

3) my JSP file is in /ROOT, it contains code:
   <%@(protected).*" %>
 <%@(protected).*" %>
 <%@(protected).*" %>
 <%@(protected).*" %>
   ......
 <%.....
 Connection con = null;
 PreparedStatement pStateSearch=null;
 Context              initCtx;
 Context              envCtx;
 javax.sql.DataSource     ds;
 initCtx = new InitialContext();
 envCtx = (Context) initCtx.lookup("java:comp/env");
 ds = (DataSource)envCtx.lookup("jdbc/DBName");
 con     = ds.getConnection();
 ....%>

4) my apache2/conf/server.xml is
   <Resource name="jdbc/DBName" auth="container"
type="javax.sql.DataSource"/>
   <ResourceParams name="jdbc/DBName">
   <!-- Maximum number of dB connections in pool. Set to 0 for no limit.-->
   <parameter>
     <name>maxActive</name>
     <value>8</value>
   </parameter>

   <!-- Maximum number of idle dB connections to retain in pool.Set to 0 for
no limit.-->
   <parameter>
     <name>maxIdle</name>
     <value>4</value>
   </parameter>

   <!-- Maximum time to wait for a dB connection to become available
   in ms, in this example 10 seconds. An Exception is thrown if
   this timeout is exceeded. Set to -1 to wait indefinitely.
   -->
   <parameter>
   <name>maxWait</name>
   <value>10000</value>
   </parameter>

   <!--parameter>
   <name>removeAbandoned</name>
   <value>true</value>
   </parameter>

   <parameter>
     <name>removeAbandonedTimeout</name>
     <value>60</value>
   </parameter-->


   <!-- MS Sql Server dB username and password for dB connections-->
   <parameter>
     <name>user</name>
     <value>dzuo</value>
   </parameter>

   <parameter>
     <name>password</name>
     <value>dzuo</value>
   </parameter>

   <!-- Class name for MS Sql Server JDBC driver
   -->
   <parameter>
     <name>driverClassName</name>
     <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
   </parameter>

   <!-- The JDBC connection url for connecting to MS Sql Server dB.-->
   <parameter>
     <name>url</name>
     <value>jdbc:microsoft:sqlserver://DBServerName:1433</value>
   </parameter>

   <!-- This Databae Connection Pool Description.-->
   <parameter>
     <name>description</name>
     <value> JDBC Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
   </parameter>

   </ResourceParams>
   </Host>
  </Engine>
</Service>
</Server>

Thanks a lot


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)