ObjectWeb Consortium
Search ObjectWeb Mail Archive: 

Advanced Search - Powered by Google


Mail Archive Home | c-jdbc List | August 2004 Index

<--  Date Index  --> <--  Thread Index  -->

tomcat 5.27 connection pooling


Hi, 

I consider to use c-jdbc with tomcat 5.27 and mysql(Raidb1 - with 1 tomcat 
server and 2 mysql servers).
I am using jndi resources to configure jdbc data sources .(for connection 
pooling)

In tomcat conf\server.xml i use a resource: 

 <Resource     name="jdbc/databasename" auth="Container"
                   type="javax.sql.DataSource"/>
    
    <ResourceParams name="jdbc/databasename">
    
    <!--  
      <parameter>
        <name>factory</name>
        <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>
    -->
      ...
      
     <parameter>
        <name>driverClassName</name>
        <value>com.mysql.jdbc.Driver</value>
      </parameter>
      
      <parameter>
        <name>url</name>
        <value>jdbc:mysql://localhost:3306/mysqldatabasename</value>
      </parameter>
      
and in the $CATALINA_HOME/webapps/jsp-examples/WEB-INF/web.xml(the specific 
applications xml file)
 
i use the reference:

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


And of course i have the example.jsp code which obtains the context to look 
up the jndi resource.

Is it possible to use c-jdbc with the connection pooling mechanism of tomcat 
5.27 ? 
What changes are needed in the above statements when i use the c-Jdbc driver?


many thanks,bill



<--  Date Index  --> <--  Thread Index  -->

Reply via email to:

Powered by MHonArc.

Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.