DB2BaseDataSource class

The com.ibm.db2.jcc.DB2BaseDataSource class is the abstract data source parent class for all IBM® Data Server Driver for JDBC and SQLJ-specific implementations of javax.sql.DataSource, javax.sql.ConnectionPoolDataSource, and javax.sql.XADataSource.

The DB2BaseDataSource properties implement the java.sql.Wrapper interface.

DB2BaseDataSource properties

The following properties are defined only for the IBM Data Server Driver for JDBC and SQLJ.

You can set all properties on a DataSource or in the url parameter in a DriverManager.getConnection call.

All properties except the following properties have a setXXX method to set the value of the property and a getXXX method to retrieve the value:
  • dumpPool
  • dumpPoolStatisticsOnSchedule
  • dumpPoolStatisticsOnScheduleFile
  • maxTransportObjectIdleTime
  • maxTransportObjectWaitTime
  • minTransportObjects
A setXXX method has this form:
void setProperty-name(data-type property-value)
A getXXX method has this form:
data-type getProperty-name()
The Property-name property is the unqualified property name. For properties that are not specific to IBM Informix®, the first character of the property name is capitalized. For properties that are used only by IBM Informix, all characters of the property name are capitalized.

The following table lists the IBM Data Server Driver for JDBC and SQLJ properties and their data types.

Table 1. DB2BaseDataSource properties and their data types
Property name Applicable data sources Data type Introduced in driver version
com.ibm.db2.jcc.DB2BaseDataSource.accessToken (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 3 String 4.24
com.ibm.db2.jcc.DB2BaseDataSource.accountingInterval 2 String 3.6
com.ibm.db2.jcc.DB2BaseDataSource.alternateGroupDatabaseName 3 String 3.66, 4.16
com.ibm.db2.jcc.DB2BaseDataSource.alternateGroupPortNumber 3 String 3.66, 4.16
com.ibm.db2.jcc.DB2BaseDataSource.alternateGroupServerName 3 String 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.affinityFailbackInterval 1 int 3.58, 4.8
com.ibm.db2.jcc.DB2BaseDataSource.allowNextOnExhaustedResultSet 1 int 3.51, 4.1
com.ibm.db2.jcc.DB2BaseDataSource.allowNullResultSetForExecuteQuery 1 int 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.apiKey IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 3 String 4.24
com.ibm.db2.jcc.DB2BaseDataSource.atomicMultiRowInsert 1 int 3.57, 4.7
com.ibm.db2.jcc.DB2BaseDataSource.blockingReadConnectionTimeout 1 int 2.8
com.ibm.db2.jcc.DB2BaseDataSource.charOutputSize 2 short 2.10
com.ibm.db2.jcc.DB2BaseDataSource.clientAccountingInformation 2, 3 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.clientApplcompat (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2 String 3.72, 4.22
com.ibm.db2.jcc.DB2BaseDataSource.clientApplicationInformation 2, 3 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.clientDebugInfo (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2, 3 String 3.0
com.ibm.db2.jcc.DB2BaseDataSource.clientProgramId 2, 3 String 2.3
com.ibm.db2.jcc.DB2BaseDataSource.clientProgramName (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2, 3 String 2.2
com.ibm.db2.jcc.DB2BaseDataSource.clientRerouteAlternateServerName 1 String 3.4
com.ibm.db2.jcc.DB2BaseDataSource.clientRerouteAlternatePortNumber 1 String 3.4
com.ibm.db2.jcc.DB2BaseDataSource.clientRerouteServerListJNDIContext 1 javax.naming.Context 3.3
com.ibm.db2.jcc.DB2BaseDataSource.clientRerouteServerListJNDIName 1 String 2.1
com.ibm.db2.jcc.DB2BaseDataSource.clientUser (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2® for z/OS® only) 2 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.clientWorkstation (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only) 2 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.commandTimeout (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 int 3.64, 4.14
com.ibm.db2.jcc.DB2BaseDataSource.connectionCloseWithInFlightTransaction 1 String 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.concurrentAccessResolution 2, 3 int 3.53, 4.3
com.ibm.db2.jcc.DB2BaseDataSource.connectNode 3 int 3.4
com.ibm.db2.jcc.DB2BaseDataSource.connectionTimeout (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 int 3.64, 4.14
com.ibm.db2.jcc.DB2BaseDataSource.currentDegree 2, 3 String 3.0
com.ibm.db2.jcc.DB2BaseDataSource.currentExplainMode 2, 3 String 2.6
com.ibm.db2.jcc.DB2BaseDataSource.currentExplainSnapshot 3 String 2.6
com.ibm.db2.jcc.DB2BaseDataSource.currentFunctionPath 2, 3 String 1.3
com.ibm.db2.jcc.DB2BaseDataSource.currentLocaleLcCtype 2 String 3.64, 4.14
com.ibm.db2.jcc.DB2BaseDataSource.currentLockTimeout 3, 4 int 2.2
com.ibm.db2.jcc.DB2BaseDataSource.currentMaintainedTableTypesForOptimization 2, 3 String 2.2
com.ibm.db2.jcc.DB2BaseDataSource.currentPackagePath 2, 3 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.currentPackageSet 2, 3 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.currentQueryOptimization 3 int 2.2
com.ibm.db2.jcc.DB2BaseDataSource.currentRefreshAge 2, 3 long 2.2
com.ibm.db2.jcc.DB2BaseDataSource.currentSchema 2, 3 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.cursorSensitivity 2, 3 int 1.5
com.ibm.db2.jcc.DB2BaseDataSource.currentSQLID 2 String 1.3
com.ibm.db2.jcc.DB2BaseDataSource.databaseName 1 String 1.0
com.ibm.db2.jcc.DB2BaseDataSource.dateFormat 2, 3 int 3.3
com.ibm.db2.jcc.DB2BaseDataSource.decimalRoundingMode 2, 3 int 3.4
com.ibm.db2.jcc.DB2BaseDataSource.decimalSeparator 1 int 3.53, 4.3
com.ibm.db2.jcc.DB2BaseDataSource.decimalStringFormat 1 int 3.8
com.ibm.db2.jcc.DB2BaseDataSource.defaultIsolationLevel 1 int 3.4
com.ibm.db2.jcc.DB2BaseDataSource.deferPrepares 1 Boolean 1.0
com.ibm.db2.jcc.DB2BaseDataSource.description 1 String 1.0
com.ibm.db2.jcc.DB2BaseDataSource.downgradeHoldCursorsUnderXa 1 Boolean 3.3
com.ibm.db2.jcc.DB2BaseDataSource.driverType 1 int 1.0
com.ibm.db2.jcc.DB2BaseDataSource.dumpPool 4 int 3.52, 4.2
com.ibm.db2.jcc.DB2BaseDataSource.dumpPoolStatisticsOnSchedule 4 int 3.52, 4.2
com.ibm.db2.jcc.DB2BaseDataSource.dumpPoolStatisticsOnScheduleFile 4 String 3.52, 4.2
com.ibm.db2.jcc.DB2BaseDataSource.enableAlternateGroupSeamlessACR 3 Boolean 3.66, 4.16
com.ibm.db2.jcc.DB2BaseDataSource.enableClientAffinitiesList 1 int 3.51, 4.1
com.ibm.db2.jcc.DB2BaseDataSource.enableExtendedIndicators 2, 3 int 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.enableNamedParameterMarkers 1 int 3.57, 4.7
com.ibm.db2.jcc.DB2BaseDataSource.enableConnectionConcentrator (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2, 4 Boolean 2.6
com.ibm.db2.jcc.DB2BaseDataSource.enableMultiRowInsertSupport 2 Boolean 3.58, 4.8
com.ibm.db2.jcc.DB2BaseDataSource.enableRowsetSupport 2, 3 int 3.7
com.ibm.db2.jcc.DB2BaseDataSource.enableSeamlessFailover 1 int 3.51, 4.1
com.ibm.db2.jcc.DB2BaseDataSource.enableSysplexWLB (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 Boolean 2.6
com.ibm.db2.jcc.DB2BaseDataSource.encryptionAlgorithm 2, 3 int 2.11
com.ibm.db2.jcc.DB2BaseDataSource.enableExtendedDescribe 2, 3 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.enableT2zosLBF (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only) 2 int 3.61, 4.11
com.ibm.db2.jcc.DB2BaseDataSource.enableT2zosLBFSPResultSets (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only) 2 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.enableTimeoutOnCursor 2, 3 int 3.67, 4.17
com.ibm.db2.jcc.DB2BaseDataSource.extendedTableInfo 2 int 3.68, 4.18
com.ibm.db2.jcc.DB2BaseDataSource.fetchSize 1 int 3.53, 4.3
com.ibm.db2.jcc.DB2BaseDataSource.floatingPointStringFormat 1 int 3.58, 4.8
com.ibm.db2.jcc.DB2BaseDataSource.fullyMaterializeInputStreams 2, 3 Boolean 2.7
com.ibm.db2.jcc.DB2BaseDataSource.fullyMaterializeLobData 1 Boolean 1.0
com.ibm.db2.jcc.DB2BaseDataSource.gssCredential 2, 3 Object 1.0
com.ibm.db2.jcc.DB2BaseDataSource.implicitRollbackOption 1 int 3.64, 4.14
com.ibm.db2.jcc.DB2BaseDataSource.interruptProcessingMode (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 int 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.jdbcCollection 2 String 1.2
com.ibm.db2.jcc.DB2BaseDataSource.keepAliveTimeOut (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.keepDynamic 2, 4 int 1.5
com.ibm.db2.jcc.DB2BaseDataSource.kerberosServerPrincipal 2, 3 String 1.1
com.ibm.db2.jcc.DB2BaseDataSource.keyUsage (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2 int 4.23
com.ibm.db2.jcc.DB2BaseDataSource.loginTimeout (not supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only) 1 int 1.4
com.ibm.db2.jcc.DB2BaseDataSource.logWriter 1 PrintWriter 1.0
com.ibm.db2.jcc.DB2BaseDataSource.maxConnCachedParamBufferSize (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only) 2 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.maxRetriesForClientReroute 3, 4 int 2.7
com.ibm.db2.jcc.DB2BaseDataSource.maxStatements 1 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.maxRowsetSize (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only) 2 int 3.7
com.ibm.db2.jcc.DB2BaseDataSource.maxTransportObjectIdleTime 4 int 3.52, 4.2
com.ibm.db2.jcc.DB2BaseDataSource.maxTransportObjectWaitTime 4 int 3.52, 4.2
com.ibm.db2.jcc.DB2BaseDataSource.maxTransportObjects 2, 4 int 2.6
com.ibm.db2.jcc.DB2BaseDataSource.memberConnectTimeout (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 3, 4 int 3.65, 4.15
com.ibm.db2.jcc.DB2BaseDataSource.minTransportObjects 4 int 3.52, 4.2
com.ibm.db2.jcc.DB2BaseDataSource.optimizationProfile 3 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.optimizationProfileToFlush 3 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.password 1 String 1.0
com.ibm.db2.jcc.DB2BaseDataSource.pdqProperties 2, 3 String 3.52, 4.2
com.ibm.db2.jcc.DB2BaseDataSource.pkList (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity only) 2 String 1.4
com.ibm.db2.jcc.DB2BaseDataSource.planName (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity only) 2 String 1.4
com.ibm.db2.jcc.DB2BaseDataSource.plugin 3 Object 2.8
com.ibm.db2.jcc.DB2BaseDataSource.pluginName 3 String 2.8
com.ibm.db2.jcc.DB2BaseDataSource.portNumber 1 int 1.0
com.ibm.db2.jcc.DB2BaseDataSource.progressiveStreaming 1 int 3.0
com.ibm.db2.jcc.DB2BaseDataSource.queryCloseImplicit 1 int 3.0
com.ibm.db2.jcc.DB2BaseDataSource.queryDataSize 1 int 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.queryTimeoutInterruptProcessingMode (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 on Linux®, UNIX, and Windows systems or IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 int 3.62, 4.12
com.ibm.db2.jcc.DB2BaseDataSource.readOnly 2, 3 Boolean 1.0
com.ibm.db2.jcc.DB2BaseDataSource.reportLongTypes 2 short 3.6
com.ibm.db2.jcc.DB2BaseDataSource.resultSetHoldability 1 int 1.0
com.ibm.db2.jcc.DB2BaseDataSource.resultSetHoldabilityForCatalogQueries 2, 3 int 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.retrieveMessagesFromServerOnGetMessage 1 Boolean 1.1
com.ibm.db2.jcc.DB2BaseDataSource.retryIntervalForClientReroute 3, 4 int 2.7
com.ibm.db2.jcc.DB2BaseDataSource.retryWithAlternativeSecurityMechanism (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 3 int 3.6
com.ibm.db2.jcc.DB2BaseDataSource.returnAlias 2, 3 short 2.5
com.ibm.db2.jcc.DB2BaseDataSource.securityMechanism 1 int 1.0
com.ibm.db2.jcc.DB2BaseDataSource.sendCharInputsUTF8 2 int 3.2
com.ibm.db2.jcc.DB2BaseDataSource.sendDataAsIs 1 Boolean 3.0
com.ibm.db2.jcc.DB2BaseDataSource.serverName 1 String 1.0
com.ibm.db2.jcc.DB2BaseDataSource.sessionTimeZone 2 String 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.sqljAvoidTimeStampConversion 2 Boolean 3.69, 4.19
com.ibm.db2.jcc.DB2BaseDataSource.sqljEnableClassLoaderSpecificProfiles 2 Boolean 2.10
com.ibm.db2.jcc.DB2BaseDataSource.ssid (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS only) 2 String 3.6
com.ibm.db2.jcc.DB2BaseDataSource.sslCertLocation (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 String 3.69, 4.19
com.ibm.db2.jcc.DB2BaseDataSource.sslCipherSuites (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2 String 3.71, 4.21
com.ibm.db2.jcc.DB2BaseDataSource.sslConnection (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 Boolean 3.0
com.ibm.db2.jcc.DB2BaseDataSource.sslKeyStoreLocation (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2 String 4.23
com.ibm.db2.jcc.DB2BaseDataSource.sslKeyStorePassword (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2 String 4.23
com.ibm.db2.jcc.DB2BaseDataSource.sslKeyStoreType (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 2 String 4.23
com.ibm.db2.jcc.DB2BaseDataSource.sslTrustStoreLocation (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 String 3.53, 4.3
com.ibm.db2.jcc.DB2BaseDataSource.sslTrustStorePassword (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 String 3.53, 4.3
com.ibm.db2.jcc.DB2BaseDataSource.sslTrustStoreType (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 String 3.71, 4.21
com.ibm.db2.jcc.DB2BaseDataSource.sslVersion (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) 1 int 4.23
com.ibm.db2.jcc.DB2BaseDataSource.statementConcentrator 2, 3 int 3.57, 4.7
com.ibm.db2.jcc.DB2BaseDataSource.streamBufferSize 2, 3 int 3.0
com.ibm.db2.jcc.DB2BaseDataSource.stripTrailingZerosForDecimalNumbers 1 int 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.supportsAsynchronousXARollback 2, 3 int 2.7
com.ibm.db2.jcc.DB2BaseDataSource.sysSchema 2, 3 String 2.5
com.ibm.db2.jcc.DB2BaseDataSource.timerLevelForQueryTimeOut 1 int 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.timeFormat 2, 3 int 3.3
com.ibm.db2.jcc.DB2BaseDataSource.timestampFormat 1 int 3.6
com.ibm.db2.jcc.DB2BaseDataSource.timestampOutputType 2 int 3.59, 4.9
com.ibm.db2.jcc.DB2BaseDataSource.timestampPrecisionReporting 1 int 3.8
com.ibm.db2.jcc.DB2BaseDataSource.traceDirectory 1 String 1.5
com.ibm.db2.jcc.DB2BaseDataSource.traceFile 1 String 1.1
com.ibm.db2.jcc.DB2BaseDataSource.traceFileAppend 1 Boolean 1.2
com.ibm.db2.jcc.DB2BaseDataSource.traceFileCount 1 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.traceFileSize 1 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.traceLevel 1 int 1.0
com.ibm.db2.jcc.DB2BaseDataSource.traceOption 1 int 3.63, 4.13
com.ibm.db2.jcc.DB2BaseDataSource.useCachedCursor 2, 3 Boolean 2.2
com.ibm.db2.jcc.DB2BaseDataSource.useJDBC4ColumnNameAndLabelSemantics 2, 3 int 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.useJDBC41DefinitionForGetColumns 1 int 4.13
com.ibm.db2.jcc.DB2BaseDataSource.user 1 String 1.0
com.ibm.db2.jcc.DB2BaseDataSource.useIdentityValLocalForAutoGeneratedKeys 2, 3 Boolean 3.62, 4.12
com.ibm.db2.jcc.DB2BaseDataSource.useRowsetCursor 2 Boolean 3.1
com.ibm.db2.jcc.DB2BaseDataSource.useTransactionRedirect 3 Boolean 2.6
com.ibm.db2.jcc.DB2BaseDataSource.xaNetworkOptimization 1 Boolean 3.3
com.ibm.db2.jcc.DB2BaseDataSource.xmlFormat 2, 3 int 3.53, 4.3
com.ibm.db2.jcc.DB2BaseDataSource.DBANSIWARN 4 Boolean 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.DBDATE 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.DBPATH 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.DBSPACETEMP 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.DBTEMP 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.DBUPSPACE 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.DELIMIDENT 4 Boolean 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.IFX_DIRECTIVES 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.IFX_EXTDIRECTIVES 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.IFX_UPDDESC 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.IFX_XASTDCOMPLIANCE_XAEND 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.INFORMIXOPCACHE 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.INFORMIXSTACKSIZE 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.NODEFDAC 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.OPTCOMPIND 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.OPTOFC 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.PDQPRIORITY 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.PSORT_DBTEMP 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.PSORT_NPROCS 4 String 3.50, 4.0
com.ibm.db2.jcc.DB2BaseDataSource.STMT_CACHE 4 String 3.50, 4.0
Note: The property applies to connections to the following data sources:
  1. All data servers
  2. Db2 for z/OS
  3. Db2 on Linux, UNIX, and Windows systems
  4. IBM Informix
  5. Db2 for IBM i
  6. Db2 on Cloud
 

DB2BaseDataSource fields

The following constants are defined only for the IBM Data Server Driver for JDBC and SQLJ.

public final static int IMPLICIT_ROLLBACK_OPTION_NOT_SET = 0
A constant for the implicitRollbackOption property. This value indicates that a connection is not closed when a deadlock or timeout occurs. This value causes the same behavior as IMPLICIT_ROLLBACK_OPTION_NOT_CLOSE_CONNECTION.
public final static int IMPLICIT_ROLLBACK_OPTION_NOT_CLOSE_CONNECTION = 1
A constant for the implicitRollbackOption property. This value indicates that a connection is not closed when a deadlock or timeout occurs. The IBM Data Server Driver for JDBC and SQLJ returns the error code that the data server generates for a deadlock or timeout.
public final static int IMPLICIT_ROLLBACK_OPTION_CLOSE_CONNECTION = 2
A constant for the implicitRollbackOption property. This value indicates that a connection is closed when a deadlock or timeout occurs.
public final static int INTERRUPT_PROCESSING_MODE_DISABLED = 0
A constant for the interruptProcessingMode property. This value indicates that interrupt processing is disabled.
public final static int INTERRUPT_PROCESSING_MODE_STATEMENT_CANCEL = 1
A constant for the interruptProcessingMode property. This value indicates that the IBM Data Server Driver for JDBC and SQLJ cancels the currently executing statement when an application runs Statement.cancel, if the data server supports interrupt processing. This value is supported on Db2 on Linux, UNIX, and Windows systems only.
public final static int INTERRUPT_PROCESSING_MODE_CLOSE_SOCKET = 2
A constant for the interruptProcessingMode property. This value indicates that the IBM Data Server Driver for JDBC and SQLJ drops the underlying socket and closes the connection when an application executes Statement.cancel. This value is supported for IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 on Linux, UNIX, and Windows systems or IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only.
public final static int NOT_SET = 0
The default value for properties.
public final static int YES = 1
The YES value for properties.
public final static int NO = 2
The NO value for properties.
public final static int QUERYTIMEOUT_DISABLED = -1
A constant for the timerLevelForQueryTimeOut property. This value indicates that Timer objects for waiting for queries to time out are not created.
public final static int QUERYTIMEOUT_STATEMENT_LEVEL = 1
A constant for the timerLevelForQueryTimeOut property. This value indicates that Timer objects for waiting for queries to time out are created at the Statement level.
public final static int QUERYTIMEOUT_CONNECTION_LEVEL = 2
A constant for the timerLevelForQueryTimeOut property. This value indicates that Timer objects for waiting for queries to time out are created at the Connection level.
public final static int TRACE_OPTION_CIRCULAR = 1
A constant for the traceOption property. This value indicates that the IBM Data Server Driver for JDBC and SQLJ uses circular tracing.

DB2BaseDataSource methods

In addition to the getXXX and setXXX methods for the DB2BaseDataSource properties, the following methods are defined only for the IBM Data Server Driver for JDBC and SQLJ.

getReference
Format:
public javax.naming.Reference getReference()
  throws javax.naming.NamingException

Retrieves the Reference of a DataSource object. For an explanation of a Reference, see the description of javax.naming.Referenceable in the Java™ Platform Standard Edition documentation.

getSSLCipherSuites
Format:
public java.lang.String getSSLCipherSuites()

Returns the contents of the sslCipherSuites property.

For more information on SSL cipher suites, see:
  • z/OS Communications Server: IP Configuration Guide in the IBM Knowledge Center
  • The information on Java Cryptography Architecture in the Java Platform Standard Edition documentation
setSSLCipherSuites
Format:
synchronized public void setSSLCipherSuites(String cipherSuites)

Specifies a set of cipher suites that the IBM Data Server Driver for JDBC and SQLJ uses when it negotiates SSL connections.

For more information on SSL cipher suites, see:
  • z/OS Communications Server: IP Configuration Guide in the IBM Knowledge Center
  • The information on Java Cryptography Architecture in the Java Platform Standard Edition documentation
Parameters:
cipherSuites
A string that contains the names of cipher suites that are to be enabled. If there is more than one cipher suite name, the names are separated by commas (,).