Table of Contents
Advertisement
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
IBM Data Server Driver for JDBC and SQLJ properties for IDS
ssid
Specifies the name of the local DB2 for z/OS subsystem to which a connection
is established using IBM Data Server Driver for JDBC and SQLJ type 2
connectivity on DB2 for z/OS. The data type of this property is String.
The ssid property overrides the db2.jcc.ssid configuration property.
ssid can be the subsystem name for a local subsystem or a group attachment
name.
Specification of a single local subsystem name allows more than one subsystem
on a single LPAR to be accessed as a local subsystem for connections that use
IBM Data Server Driver for JDBC and SQLJ type 2 connectivity.
Specification of a group attachment name allows failover processing to occur if
a data sharing group member fails. If the DB2 subsystem to which an
application is connected fails, the connection terminates. However, when new
connections use that group attachment name, DB2 for z/OS uses group
attachment processing to find an active DB2 subsystem to which to connect.
ssid applies only to IBM Data Server Driver for JDBC and SQLJ type 2
connectivity to DB2 for z/OS.
useRowsetCursor
Specifies whether the IBM Data Server Driver for JDBC and SQLJ always uses
multiple-row FETCH for scrollable cursors if the data source supports
multiple-row fetch. The data type of this property is boolean.
This property applies only to IBM Data Server Driver for JDBC and SQLJ type
4 connectivity, or to IBM Data Server Driver for JDBC and SQLJ type 2
connectivity to DB2 for z/OS. If the enableRowsetSupport property is not set,
the default for useRowsetCursor is true. If the enableRowsetSupport property
is set, the useRowsetCursor property is not used.
Applications that use the JDBC 1 technique for performing positioned update
or delete operations should set useRowSetCursor to false. Those applications
do not operate properly if the IBM Data Server Driver for JDBC and SQLJ uses
multiple-row FETCH.
Related concepts
"Failover support with IBM Data Server Driver for JDBC and SQLJ type 2
connectivity on DB2 for z/OS" on page 97
Some of the IBM Data Server Driver for JDBC and SQLJ properties apply only to
IBM Informix Dynamic Server (IDS) databases. Those properties correspond to IDS
environment variables.
Properties that are shown in uppercase characters in the following information
must be specified in uppercase. For those properties, getXXX and setXXX methods
are formed by prepending the uppercase property name with get or set. For
example:
boolean dbDate = DB2BaseDateSource.getDBDATE();
The IDS-specific properties are:
DBANSIWARN
Specifies whether the IBM Data Server Driver for JDBC and SQLJ instructs the
Chapter 7. JDBC and SQLJ reference information
233
- Quick Links:
- Table of Contents
Hide quick links:
Advertisement
Table of Contents
