Goal
This document describes how to configure the number of idle connections in a connection pool.
Content
In order to modify the number of idle connections in the connection pool of a JDBC data source, the following command can be executed from a VQL command line:
ALTER DATASOURCE JDBC <data source name>
VALIDATIONQUERY = 'SELECT COUNT(*) FROM SYS.DUAL'
INITIALSIZE = 15
MAXIDLE = 25
MINIDLE = 5
MAXACTIVE = 20
EXHAUSTEDACTION = 1
TESTONBORROW = false
TESTONRETURN = false
TESTWHILEIDLE = false
TIMEBETWEENEVICTION = 60000
NUMTESTPEREVICTION = 3
MINEVICTABLETIME = 120000;
In addition to the configuration options that are available from the graphical interface, more options can be set to the desired value using VQL. The meaning of the different properties can be seen in the documentation of Apache Commons Pool project.
To configure the number of idle connections the MAXIDLE and MINIDLE properties must be modified.
References
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.
Recommended resources
Questions
