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.
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.
- dumpPool
- dumpPoolStatisticsOnSchedule
- dumpPoolStatisticsOnScheduleFile
- maxTransportObjectIdleTime
- maxTransportObjectWaitTime
- minTransportObjects
- xmlFormat
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.
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) | 2 (starting with version 4.34 of the driver), 3 | String | 4.24 |
com.ibm.db2.jcc.DB2BaseDataSource.accessTokenType (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) | 2 (starting with version 4.34 of the driver), 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) | 2 (starting with version 4.34 of the driver), 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 (IBM Data Server Driver for JDBC and SQLJ type 2 connectivity on Db2 for z/OS® only) | 2 | String | 2.3 |
com.ibm.db2.jcc.DB2BaseDataSource.clientProgramName (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) | 2 | 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 | 2 (starting with version 4.34 of the IBM Data Server Driver for JDBC and SQLJ), 3 | 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.enableDualTransportUsingDifferentProcess | 3 | int | 4.31 |
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.enableSeamlessFailoverErrorCodes (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) | 2 | Boolean | 4.32 |
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 | 1 | int | 3.52, 4.2 |
com.ibm.db2.jcc.DB2BaseDataSource.maxTransportObjects | 2, 4 | int | 2.6 |
com.ibm.db2.jcc.DB2BaseDataSource.MAXBLKEXT (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) | 2, 3 | int | 4.32 |
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.queryPrefetch (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) | 2, 3 | Boolean | 4.29 |
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.sslClientHostnameValidation (IBM Data Server Driver for JDBC and SQLJ type 4 connectivity only) | 2, 3 | String | 4.29 |
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.useClientSideLicenseFirst | 2, 3, 5, 6 | int | 4.29 |
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:
|
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:- Cipher suite specification
- 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:- Cipher suite specification
- 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 (,).