EasyManuals Logo

IBM DB2 User Manual

IBM DB2
585 pages
To Next Page IconTo Next Page
To Next Page IconTo Next Page
To Previous Page IconTo Previous Page
To Previous Page IconTo Previous Page
Page #226 background imageLoading...
Page #226 background image
With progressive streaming, also known as dynamic data format, the data
source dynamically determines the most efficient mode in which to return LOB
or XML data, based on the size of the LOBs or XML objects. The value of the
streamBufferSize parameter determines whether the data is materialized when
it is returned.
The data type of progressiveStreaming is int. Valid values are
DB2BaseDataSource.YES (1) and DB2BaseDataSource.NO (2). If the
progressiveStreaming property is not specified, the progressiveStreaming value
is DB2BaseDataSource.NOT_SET (0).
If the connection is to a data source that supports progressive streaming, and
the value of progressiveStreaming is DB2BaseDataSource.YES or
DB2BaseDataSource.NOT_SET, the JDBC driver uses progressive streaming to
return LOBs and XML data.
If the value of progressiveStreaming is DB2BaseDataSource.NO, or the data
source does not support progressive streaming, the way in which the JDBC
driver returns LOB or XML data depends on the value of the
fullyMaterializeLobData property.
resultSetHoldability
Specifies whether cursors remain open after a commit operation. The data type
of this property is int. Valid values are:
DB2BaseDataSource.HOLD_CURSORS_OVER_COMMIT (1)
Leave cursors open after a commit operation.
DB2BaseDataSource.CLOSE_CURSORS_AT_COMMIT (2)
Close cursors after a commit operation.
DB2BaseDataSource.NOT_SET (0)
Close cursors after a commit operation. This is the default value.
retryIntervalForClientReroute
For automatic client reroute, specifies the amount of time in seconds between
connection retries.
The data type of this property is int.
The IBM Data Server Driver for JDBC and SQLJ uses the
retryIntervalForClientReroute property only if the maxRetriesForClientReroute
property is also set.
If maxRetriesForClientReroute or retryIntervalForClientReroute is not set, the
IBM Data Server Driver for JDBC and SQLJ performs retries for 10 minutes.
If the enableClientAffinitiesList is set to DB2BaseDataSource.NO (2), an attempt
to connect to the primary server and alternate servers counts as one retry. The
driver waits the number of seconds that is specified by
retryIntervalForClientReroute before retrying the connection. If
enableClientAffinitiesList is set to DB2BaseDataSource.YES (1), each server that
is specified by the clientRerouteAlternateServerName and
clientRerouteAlternatePortNumber values is retried after the number of
seconds that is specified by retryIntervalForClientReroute.
The default value for retryIntervalForClientReroute is 0.
securityMechanism
Specifies the DRDA security mechanism. The data type of this property is int.
Possible values are:
210 Application Programming Guide and Reference for Java
â„¢
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|

Table of Contents

Questions and Answers:

Question and Answer IconNeed help?

Do you have a question about the IBM DB2 and is the answer not in the manual?

IBM DB2 Specifications

General IconGeneral
DeveloperIBM
Initial Release1983
LicenseProprietary
Written inC, C++
CategoryDatabase Management System (RDBMS)
Operating SystemLinux, Windows
Programming LanguagesC, C++
Data ModelsRelational
EditionsCommunity, Standard, Advanced
Key Featureshigh availability, scalability