commons-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From commons-...@jakarta.apache.org
Subject [Jakarta Commons Wiki] Updated: DBCP
Date Sun, 23 Jan 2005 11:06:06 GMT
   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


Mime
View raw message