You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by jacky <ja...@hotmail.com> on 2006/02/13 11:07:10 UTC
jdbc context
hi,
I have deploy a workflow webapp in Tomcat4.1.31. First time, i add the following code in server.xml:
<Context path="/myworkflow" docBase="myworkflow" reloadable="true" >
<Resource name="jdbc/DefaultDS" type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/DefaultDS">
<parameter>
<name>maxActive</name>
<!-- Maximum number of DB connections in pool.Set to 0 for no limit. -->
<value>100</value>
</parameter>
<parameter>
<name>maxIdle</name>
<!-- Maximum number of idle DB connections to retain in pool.Set to 0 for no limit. -->
<value>30</value>
</parameter>
<parameter>
<name>maxWait</name>
<!-- Maximum time to wait for a DB connection to become available in ms.An exception is thrown if this timeout is exceeded.Set to -1 to wait indefinitely. -->
<value>15000</value>
</parameter>
<parameter>
<name>removeAbandoned</name>
<!-- Abandoned DB connections are removed and recycled -->
<value>true</value>
</parameter>
<parameter>
<name>removeAbandonedTimeout</name>
<!-- Use the removeAbandonedTimeout parameter to set the number of seconds a DB connection has been idle before it is considered abandoned. -->
<value>60</value>
</parameter>
<parameter>
<name>logAbandoned</name>
<!-- Log a stack trace of the code which abandoned -->
<value>false</value>
</parameter>
<parameter>
<name>factory</name>
<!--DBCP Basic Datasource Factory -->
<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>com.microsoft.jdbc.sqlserver.SQLServerDriver</value></parameter>
<parameter><name>url</name>
<value>jdbc:microsoft:sqlserver://localhost:1433;databaseName=myworkflow</value></parameter>
</ResourceParams>
</Context>
It works well. But now, we need to migrate myworkflow into another tomcat4.1.31, in which the server.xml can't be modified.
So what shall i do to deploy the jdbc context? Thanks for your help!
Best Regards.
jacky