deferPrepares is supported for IBM Data Server Driver for JDBC and SQLJ
type 2 connectivity to DB2 Database for Linux, UNIX, and Windows, and for
IBM Data Server Driver for JDBC and SQLJ type 4 connectivity.
Possible values are:
true Statement preparation on the data source does not occur until the
PreparedStatement.execute method is executed. This is the default.
false Statement preparation on the data source occurs when the
Connection.prepareStatement method is executed.
Deferring prepare operations can reduce network delays. However, if you defer
prepare operations, you need to ensure that input data types match table
column types.
description
A description of the data source. The data type of this property is String.
downgradeHoldCursorsUnderXa
Specifies whether cursors that are defined WITH HOLD can be opened under
XA connections.
downgradeHoldCursorsUnderXa applies to:
v IBM Data Server Driver for JDBC and SQLJ type 4 connectivity to DB2 for
z/OS servers.
v IBM Data Server Driver for JDBC and SQLJ type 4 connectivity or IBM Data
Server Driver for JDBC and SQLJ type 2 connectivity to DB2 Database for
Linux, UNIX, and Windows servers.
The default is false, which means that a cursor that is defined WITH HOLD
cannot be opened under an XA connection. An exception is thrown when an
attempt is made to open that cursor.
If downgradeHoldCursorsUnderXa is set to true, a cursor that is defined
WITH HOLD can be opened under an XA connection. However, the cursor has
the following restrictions:
v When the cursor is opened under an XA connection, the cursor does not
have WITH HOLD behavior. The cursor is closed at XA End.
v A cursor that is open before XA Start on a local transaction is closed at XA
Start.
driverType
For the DataSource interface, determines which driver to use for connections.
The data type of this property is int. Valid values are 2 or 4. 2 is the default.
enableClientAffinitiesList
Specifies whether the IBM Data Server Driver for JDBC and SQLJ enables
client affinities for cascaded failover support. The data type of this property is
int. Possible values are:
DB2BaseDataSource.YES (1)
The IBM Data Server Driver for JDBC and SQLJ enables client affinities
for cascaded failover support. This means that only servers that are
specified in the clientRerouteAlternateServerName and
clientRerouteAlternatePortNumber properties are retried. The driver
does not attempt to reconnect to any other servers.
For example, suppose that clientRerouteAlternateServerName contains
the following string:
host1,host2,host3
206 Application Programming Guide and Reference for Java
™
|
|
|
|
||
|
||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
To Next Page
Loading...
Need help?
General