how to configure connection pool in tomcat

[Abhilash Boinapally]

presently i am using weblogic 8.1 while configuring we first created a connection pool then we created datasource but in tomcat 5.0 i did not see the option for creating connection pool.i now want to use tomcat for debugging purpose then tell me how to configure my database to tomcat

[Uma Mahi]

you can use DBCP from org.apache.tomacat.DBCP...But first, you have to configure the JNDI DataSource in Tomcat by adding a declaration for the resource to server.xml file.

  
<Connector port="80" maxHttpHeaderSize="8192" maxProcessors="150"
   maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
   enableLookups="false" redirectPort="8443" acceptCount="150"
   connectionTimeout="20000" disableUploadTimeout="true" />

and configure your JNDI reference.

you have to insert a <resource-ref> tag into the web.xml deployment descriptor file.

you have to set the <listener> tag for registering a ServletContextListener as shown below:

  <listener>
        <listener-class> com.onjava.dbcp.DBCPoolingListener</listener-class>
</listener>
 
<resource-ref>
      <description> DB Connection Pooling</description>
      <res-ref-name> jdbc/TestDB</res-ref-name>
      <res-type> javax.sql.DataSource</res-type>
      <res-auth> Container</res-auth>
  </resource-ref>
 
<servlet>
        <servlet-name>myservlet</servlet-name>
        <servlet-class>dbcp.myservlet</servlet-class>
        <load-on-startup> 1</load-on-startup>
</servlet>
 
<servlet-mapping>
        <servlet-name>myservlet</servlet-name>
        <url-pattern> /test.do</url-pattern>
</servlet-mapping>