This task describes how to override the connection pool.
-
Open the
<extension>\custom-connection-pool-context.xml.sample
file.
You can also set the basic pool information in the SkyVault-global.properties file.
-
Set the connection pool properties. For example:
db.pool.initial=10 db.pool.max=100
- Remove the .sample extension from this file.
-
Modify the properties where appropriate, paying particular
attention to the validationQuery property. This
property is an SQL query that validates connections from this pool
before returning them to the caller. This query must returns at least
one row.
For explanations of each property shown in the file, refer to: http://jakarta.apache.org/commons/dbcp/configuration.html