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