-
Language:
English
-
Language:
English
Red Hat Training
A Red Hat training course is available for Red Hat JBoss Data Virtualization
1.9. Connection Properties for the Driver and Data Source Classes
The following table shows all the connection properties that can be used with the JBoss Data Virtualization JDBC driver URL connection string and the JBoss Data Virtualization JDBC data source class.
These properties are defined in
org.teiid.net.TeiidURL
and org.teiid.jdbc.ExecutionProperties
(waitForLoad
is defined in org.teiid.jdbc.EmbeddedProfile
), and the corresponding set methods are defined for the data source class in org.teiid.jdbc.TeiidDataSource
and its superclass, org.teiid.jdbc.BaseDataSource
.
Property names that can be used in the driver URL connection string are listed in the Property Name column, and the corresponding set methods for use with the data source class are listed in the Method Name column.
Table 1.2. Connection Properties
Property Name | Method Name | Type | Description |
---|---|---|---|
ansiQuotedIdentifiers | setAnsiQuoted Identifiers | boolean | Sets the parsing behavior for double quoted entries in SQL. If true, then parses doubled quoted entries as identifiers. If false, then double quoted values that are valid string literals are parsed as string literals. Default is true. |
ApplicationName | setApplicationName | String | Name of the client application; allows the administrator to distinguish between connections. |
autoCommitTxn | setAutoCommitTxn | String | This only applies when autoCommit is set to true. This determines how an executed command needs to be wrapped as a transaction inside the JBoss Data Virtualization engine to maintain the data integrity.
|
autoFailover | setAutoFailover | boolean | If true, automatically selects a new server instance after a communication exception. This is typically not needed when connections are managed, as the connection can be purged from the pool. Default is false. |
disableLocalTxn | setDisableLocalTxn | boolean | If true, the autoCommit setting, commit and rollback is ignored for local transactions. Default is false. |
fetchSize | setFetchSize | int | Size of the resultset. Default is 2048. <=0 indicates that the default should be used. |
NOEXEC | setNoExec | String | (Typically not set as a connection property.) Can be ON or OFF. ON prevents query execution, but parsing and planning still occurs. Default is OFF. |
partialResultsMode | setPartialResultsMode | boolean | Enable/disable support partial results mode. Default false. See Section 3.12, “Partial Results Mode” for more details. |
Passthrough Authentication | setPassthrough Authentication | boolean | Only applies to local connections. When this option is set to true, JBoss Data Virtualization looks for an authenticated security context on the calling thread. If one is found, it uses that user's credentials to create a session. JBoss Data Virtualization also verifies that the same user is using this connection during the life of the connection. If it finds a different security context on the calling thread and the new user is eligible to login to JBoss Data Virtualization, it switches the identity on the connection. |
useCallingThread | Not applicable. Must be set using setAdditionalProperties method if connecting via the data source class. | boolean | Only applies to local connections. When this option is set to true, the calling thread is used to process the query. If false, then an engine thread is used. Default is true. |
QUERYTIMEOUT | setQueryTimeout | int | Default query timeout in seconds. Must be >= 0. 0 indicates no timeout. Can be overridden by Statement.setQueryTimeout . Default is 0. |
useJDBC4ColumnName AndLabelSemantics | setUseJDBC4ColumnName AndLabelSemantics | boolean |
A change was made in JDBC4 to return unaliased column names as the ResultSetMetadata column name. Prior to this, if a column alias was used it was returned as the column name. Setting this property to false enables backwards compatibility when JDBC3 and older support is still required. Defaults to true.
|
password | setPassword | String | Credential for user |
resultSetCacheMode | setResultSetCacheMode | boolean | ResultSet caching is turned on/off. Default is false. |
SHOWPLAN | setShowPlan | String | (Typically not set as a connection property.) Can be ON, OFF or DEBUG. ON returns the query plan along with the results and DEBUG additionally prints the query planner debug information in the log and returns it with the results. Both the plan and the log are available through JDBC API extensions. Default is OFF. |
user | setUser | String | User name. |
version | setDatabaseVersion | String | Version number of the VDB. |
jaasName | setJaasName | String |
This is the JAAS configuration name. This only applies when configuring GSS authentication. See the Red Hat JBoss Data Virtualization Administration and Configuration Guide for more information about configuring GSS.
|
kerberosService PrincipleName | setKerberosService PrincipleName | String |
This is the Kerberos-authenticated principle name. It only applies when you are configuring GSS authentication. See the Red Hat JBoss Data Virtualization Administration and Configuration Guide for more information about GSS configuration.
|
encryptRequests | setEncryptRequests | boolean |
Only applies to non-SSL socket connections. When set to true, the request message and any associated payload is encrypted using the connection cryptor. Default is false.
|
waitForLoad | Not applicable. Needs to be specified using setAdditionalProperties if set using the data source class. | String | Only applies to local connections. When this option is set to a non-negative value, the connection will wait that number of milliseconds for the VDB to become active. Setting to a negative number uses the system default setting. |