How to configure the number of idle connections in a connection pool

Applies to: Denodo 7.0 , Denodo 6.0 , Denodo 5.5 , Denodo 5.0
Last modified on: 02 Jun 2020
Tags: VQL JDBC data sources

Download document

You can translate the document:

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

Apache Commons Pool

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training