Configuration of ODBC timeout in a DSN

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 10 Jun 2020
Tags: DSN ODBC driver Timeout configuration

Download document

You can translate the document:

Content

When connecting to Denodo Virtual DataPort (VDP) through ODBC, the connections will have a default query timeout. The query timeout is the maximum time (in milliseconds) the ODBC driver will wait for a query to finish. After this time, the driver will throw an exception that can be seen from the ODBC client or in the VDP server logs:

ERROR com.denodo.vdb.vdbinterface.server.odbc.ODBCBackend  - Error: Error executing query. Total time 900.0 seconds.

QUERY [PROJECTION] [QUERY_TIMEOUT]

VIEW [PROJECTION] [PROCESSING]

VIEW [JOIN] [QUERY_TIMEOUT]

The complete error message will depend on the view being queried.

The default query timeout value is 15 minutes (900000 milliseconds). It is possible to explicitly specify the query timeout configuration in an ODBC DSN data source. You may specify any connection parameters at the end of the Database field of the ODBC DSN. For example, if you are connecting to the xyz database and you want a query timeout of 100 seconds, you would specify the following value for the Database field of the DSN:


xyz?queryTimeout=100000

If 0 is specified as query timeout, the driver will wait indefinitely until the query finishes. It is also possible to modify the field Connect settings of the DSN  Datasource configuration dialog, Page 2,  adding the following value:

set queryTimeout to 100000

Note that only one of the options can be used. Also, take into account that if the DSN configuration is modified the new values will be applied to the new connections and not to those already opened. All the clients should be restarted to make sure that the change is applied correctly.

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