You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@commons.apache.org by co...@jakarta.apache.org on 2005/01/23 12:06:06 UTC
[Jakarta Commons Wiki] Updated: DBCP
Date: 2005-01-23T03:06:06
Editor: DirkVerbeeck
Wiki: Jakarta Commons Wiki
Page: DBCP
URL: http://wiki.apache.org/jakarta-commons/DBCP
add tomcat config examples
Change Log:
------------------------------------------------------------------------------
@@ -12,6 +12,48 @@
Diagrams hosted by http://rei1.m-plify.net
+= Tomcat Configuration examples =
+
+Some Tomcat JNDI Datasource examples (in addition to the [http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html Tomcat howto]).
+
+
+'''!BasicDataSource'''
+{{{
+<Resource name="jdbc/abandoned" auth="Container" type="javax.sql.DataSource"/>
+<ResourceParams name="jdbc/abandoned">
+ <parameter><name>factory</name><value>org.apache.commons.dbcp.BasicDataSourceFactory</value></parameter>
+ <parameter><name>username</name><value>sa</value></parameter>
+ <parameter><name>password</name><value></value></parameter>
+ <parameter><name>driverClassName</name><value>org.hsqldb.jdbcDriver</value></parameter>
+ <parameter><name>url</name><value>jdbc:hsqldb:database</value></parameter>
+ <parameter><name>removeAbandoned</name><value>false</value></parameter>
+ <parameter><name>removeAbandonedTimeout</name><value>300</value></parameter>
+ <parameter><name>logAbandoned</name><value>true</value></parameter>
+ <parameter><name>maxActive</name><value>10</value></parameter>
+</ResourceParams>
+}}}
+
+'''!PerUserPoolDataSource'''
+{{{
+<Resource name="jdbc/TestDBCPDS" auth="Container" type="org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS"/>
+<ResourceParams name="jdbc/TestDBCPDS">
+ <parameter><name>factory</name><value>org.apache.commons.dbcp.cpdsadapter.DriverAdapterCPDS</value></parameter>
+ <parameter><name>user</name><value>sa</value></parameter>
+ <parameter><name>password</name><value></value></parameter>
+ <parameter><name>driver</name><value>com.sybase.jdbc2.jdbc.SybDrivers</value></parameter>
+ <parameter><name>url</name><value>jdbc:sybase:Tds:<myServerName>:<myPort>?charset=iso_1</value></parameter>
+</ResourceParams>
+
+<Resource auth="Container" name="jdbc/TestDB" type="org.apache.commons.dbcp.datasources.PerUserPoolDataSource"/>
+<ResourceParams name="jdbc/TestDB">
+ <parameter><name>factory</name><value>org.apache.commons.dbcp.datasources.PerUserPoolDataSourceFactory</value></parameter>
+ <parameter><name>defaultMaxActive</name><value>10</value></parameter>
+ <parameter><name>defaultMaxIdle</name><value>2</value></parameter>
+ <parameter><name>defaultMaxWait</name><value>-1</value></parameter>
+ <parameter><name>dataSourceName</name><value>java:comp/env/jdbc/TestDBCPDS</value></parameter>
+</ResourceParams>
+}}}
+
= FAQ =
Q: Is this project still active or have they just not released anything in an excessive period of time?
---------------------------------------------------------------------
To unsubscribe, e-mail: commons-dev-unsubscribe@jakarta.apache.org
For additional commands, e-mail: commons-dev-help@jakarta.apache.org