Denodo Data Virutalization how to configure idle connections in a pool?

In order to modify the number of idle connections in the connection pool of a JDBC data source, you can run the following command 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
MINEVIDECTABLETIME = 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. You can check the meaning of the different properties in the documentation of Apache Commons Pool.

To configure the number of idle connections you can modify the MAXIDLE and MINIDLE properties.

Leave a Reply

Your email address will not be published. Required fields are marked *