SET <property-name> TO <property-value>
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:
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);