Configuring Connection Properties with ODBC

When working with ODBC connections, you can set the URL connection properties that are available in Teiid Spring Boot by running a command such as the following:

SET <property-name> TO <property-value>

For example, to turn on result set caching you can run the following command:

SET resultSetCacheMode TO 'true'

Another option is to use VDB properties in the vdb file to configure the connection, as in the following example:

CREATE DATABASE vdb OPTIONS ("connection.partialResultsMode" true);

results matching ""

    No results matching ""