Page History
...
You will now use the new parameters:
- maxTotal
- maxWaitMillis
| Notewarning | ||
|---|---|---|
| ||
If you are using Oracle, please change the driverClassName to "oracle.jdbc.driver.OracleDriver". |
As part of the changes, here's a sample context.xml file, with the values that you should have (assuming MySQL used):
| Code Block | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
<?xml version='1.0' encoding='utf-8'?>
<!-- The contents of this file will be loaded for each web application -->
<Context>
<WatchedResource>WEB-INF/web.xml</WatchedResource>
<Resource name="jdbc/problemDB" auth="Container" type="javax.sql.DataSource"
maxTotal="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/shrine_query_history"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/shrineDB" auth="Container" type="javax.sql.DataSource"
maxTotal="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/shrine_query_history"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/adapterAuditDB" auth="Container" type="javax.sql.DataSource"
maxTotal="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/adapterAuditDB"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/qepAuditDB" auth="Container" type="javax.sql.DataSource"
maxTotal="512" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/qepAuditDB"
testOnBorrow="true" validationQuery="SELECT 1" />
<Resource name="jdbc/stewardDB" auth="Container" type="javax.sql.DataSource"
maxTotal="128" maxIdle="32" maxWaitMillis="10000"
username="shrine" password="demouser" driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/stewardDB"
testOnBorrow="true" validationQuery="SELECT 1" />
</Context> |
...
Overview
Content Tools