Table 10 lists new connection properties available with ESD #3. For a complete list of connection properties, refer to Chapter 2, “Programming Information,” in the jConnect for JDBC 6.05 Programmer’s Reference.
Property |
Description |
Default value |
|---|---|---|
CRC |
When this property is set to true, the update counts that are returned are cumulative counts that include updates directly affected by the statement executed and any triggers invoked as a result of the statement being executed. |
false |
DATABASE |
Use this property to specify the database name for a connection when the connection information is obtained from a Sybase interfaces file. The URL of an interfaces file cannot supply the database name. |
null |
DEFAULT_QUERY_TIMEOUT |
When this connection property is set, it is used as the default query timeout for any statements created on this connection. |
0 (no timeout) |
IMPLICIT_CURSOR_FETCH_SIZE |
Use this property in conjunction with the SELECT_OPENS_CURSOR property to force jConnect to open a read-only cursor on every select query that is sent to the database. The cursor will have a fetch size of the value set in this property, unless overridden by the Statement.setFetchSize method. |
0 |
INTERNAL_QUERY_TIMEOUT |
Use this property to set the query timeout that will be used by statements internally created and executed by jConnect. This may prevent application hangs if internal commands do not complete in a reasonable time. |
0 (no timeout) |
J2EE_TCK_COMPLIANT |
When this property is set to true ,the jConnect driver enables behaviour that is compliant with the J2EE 1.4 TCK test suite—this causes some loss of performance. Therefore, Sybase recommended using the default value of false. |
false |
