Server hostname where the Teiid runtime installed. However, use of Database name in this format and use ofĭatabaseVersion property at the same time is not allowed. "DatabaseVersion" property set to value of 2. For example: "myvdb.2", this is equivalent to supplying the Name can also contain "DatabaseVersion" information inside it. The name of a virtual database (VDB) deployed to Teiid. See the Admin Guide for configuration required for GSS Only applies when configuring a GSS authentication. See the Admin Guide for configuration required for GSS. Setting this property to false will enableīackwards compatibility when JDBC3 and older support is still required. Prior to this, if a column alias were used it was returned as the column name. Default 0.Ī change was made in JDBC4 to return unaliased column names as the ResultSetMetadata column name. If false, then an engine thread will be used.ĭefault query timeout in seconds. When this option is set to "true" (the default), then the calling thread will be used to process the query. If the new user is also eligible to log in to Teiid otherwise connection fails to execute. If it finds a different security context on the calling thread, it switches the identity on the connection, Teiid also verifies that the same user is using this connection during the life of the connection. If one found it uses that users credentials When this option is set to "true", then Teiid looks forĪlready authenticated security context on the calling thread.
(typically not set as a connection property) Can be ON|OFF ON prevents query execution, but parsing and planning will still occur. Both the plan and the log are available through JDBC API extensions. (typically not set as a connection property) Can be ON|OFF|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. This is typically not needed when connections are managed, as the connection can be purged from the pool. If true, will automatically select a new server instance after a communication exception. If set to false, then double quoted values thatĪre valid string literals will be parsed as string literals. Sets the parsing behavior for double quoted entries in SQL. If "true", the autoCommit setting, commit and rollback will be ignored for local transactions. Transactions with JDBC for more information. OFF - Never wrap command in distributed transactionĭETECT (default)- If the executed command is spanning more than one source it automatically uses distributed transaction. ON - Always wrap command in distributed transaction
0 kommentar(er)
