You can translate the document:

Content

For performance reasons, in VDP Server, the JDBC and ODBC data sources keep a pool of open connections to the database. If the database is restarted, or if a connection expires, a query that uses the connection will receive an error. To avoid this, configure each data source’s pool of connections to validate the connection before using it. To configure the connection pool in Denodo 8, in Design Studio:

  1. Select the data source
  2. Advanced tab
  3. Connection Pool Configuration section

For other versions below Denodo 8, in the VDP Admin Tool:

  1. Select the data source.
  2. Click on "Connection Pool configuration"


Starting from Denodo 6, the connection validation is enabled by default. For previous versions, we recommend enabling it following the steps described below:

To enable it, select the checkbox Test connections checked. A ping query should also be provided.

This ping query is used to validate the connection by executing it before the connection is used in a query. The ping query should consume as little resources in the database as possible. If the validation fails, a new connection will be created. The connections will only be validated if the field “Ping query” contains a query. Otherwise, they will not even if this check box is selected.

By activating Test Connections, neither restarting the database nor an expired connection will cause a query to fail.

The Virtual DataPort Administration Guide provides additional details on how to configure the connection pool for JDBC and ODBC data sources.

References

Virtual DataPort Administration Guide: Importing JDBC Sources and ODBC Sources 

Disclaimer
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.

Questions

Ask a question

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