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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
