Configuration properties for the Transaction Manager service
Name | Type | Default | Description |
---|---|---|---|
recoverOnStartup | boolean | false | Specifies whether the server should begin transaction recovery at server startup. |
waitForRecovery | boolean | false | Specifies whether the server should wait for transaction recovery to complete before accepting new transactional work. |
acceptHeuristicHazard | boolean | true | Specifies whether all applications on this server accept the possibility of a heuristic hazard occurring in a two-phase transaction that contains a one-phase resource. |
clientInactivityTimeout | A period of time with second precision | 60s | Maximum duration between transactional requests from a remote client. Any period of client inactivity that exceeds this timeout results in the transaction being rolled back in this application server. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
heuristicRetryInterval | A period of time with second precision | 60s | Amount of time that the application server waits before retrying a completion signal, such as commit or rollback, after a transient exception from a resource manager or remote partner. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
heuristicRetryWait | int | 5 | The number of times that the application server retries a completion signal, such as commit or rollback. Retries occur after a transient exception from a resource manager or remote partner. |
propogatedOrBMTTranLifetimeTimeout | A period of time with second precision | 0 | Upper limit of the transaction timeout for transactions that run in this server. This value should be greater than or equal to the value specified for the total transaction timeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
totalTranLifetimeTimeout | A period of time with second precision | 120s | Default maximum time allowed for transactions started on this server to complete. Any such transactions that do not complete before this timeout occurs are rolled back. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
transactionLogDirectory | string | ${server.output.dir}/tranlog/ | A directory for this server where the transaction service stores log files for recovery. |
transactionLogSize | int | 1024 | Specifies the size of transaction log files in Kilobytes. |
recoveryIdentity | string | Unique identity of this server for transaction peer recovery. | |
recoveryGroup | string | Name of the recovery group that this server belongs too. Members of a recovery group can recover the transaction logs of other servers in the group. | |
enableLoggingForHeuristicReporting | boolean | false | Specifies whether the application server logs about-to-commit-one-phase-resource events from transactions that involve both a one-phase commit resource and two-phase commit resources. |
transactionLogDBTableSuffix | string | When recovery logs are stored in an RDBMS table, this property allows the table name to be post-pended with a string to make it unique for this Server. | |
timeoutGracePeriodEnabled | boolean | false | Specifies whether there is a delay between a transaction timeout and the abnormal ending of the servant region that was running the transaction. |
lpsHeuristicCompletion |
| ROLLBACK | Specifies the direction that is used to complete a transaction that has a heuristic outcome; either the application server commits or rolls back the transaction, or depends on manual completion by the administrator. Allowed values are: COMMIT, ROLLBACK and MANUAL COMMIT Commit MANUAL Manual ROLLBACK Rollback |
defaultMaxShutdownDelay | A period of time with second precision | 2s | Default maximum shutdown delay. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
dataSourceRef | A reference to top level dataSource element (string). | This is an optional property. By default the transaction service stores its recovery logs in a file. As an alternative it is possible to store the logs in an RDBMS. This is achieved by setting this property which defines a non-transactional data source where the transaction logs will be stored. |
This is an optional property. By default the transaction service stores its recovery logs in a file. As an alternative it is possible to store the logs in an RDBMS. This is achieved by setting this property which defines a non-transactional data source where the transaction logs will be stored.
Name | Type | Default | Description |
---|---|---|---|
enableConnectionCasting | boolean | false | Indicates that connections obtained from the data source should be castable to interface classes that the JDBC vendor connection implementation implements. Enabling this option incurs additional overhead on each getConnection operation. If vendor JDBC interfaces are needed less frequently, it might be more efficient to leave this option disabled and use Connection.unwrap(interface) only where it is needed. If updated while the server is running, the update is applied with new connection requests; in-use connections are not impacted. |
jndiName | string | JNDI name for a data source. If updated while the server is running, existing connections are destroyed. | |
jdbcDriverRef | A reference to top level jdbcDriver element (string). | JDBC driver for a data source. If updated while the server is running, existing connections are destroyed. | |
connectionManagerRef | A reference to top level connectionManager element (string). | Connection manager for a data source. If updated while the server is running, existing connections are destroyed. | |
type |
| Type of data source. If updated while the server is running, existing connections are destroyed. javax.sql.DataSource javax.sql.DataSource javax.sql.ConnectionPoolDataSource javax.sql.ConnectionPoolDataSource javax.sql.XADataSource javax.sql.XADataSource | |
connectionSharing |
| MatchOriginalRequest | Specifies how connections are matched for sharing. MatchOriginalRequest When sharing connections, match based on the original connection request. MatchCurrentState When sharing connections, match based on the current state of the connection. If updated while the server is running, the update is applied with each first connection handle in a transaction. |
containerAuthDataRef | A reference to top level authData element (string). | Default authentication data for container managed authentication that applies when bindings do not specify an authentication-alias for a resource reference with res-auth=CONTAINER. If updated while the server is running, the change is applied with new connection requests; in-use connections are not impacted. | |
jaasLoginContextEntryRef | A reference to top level jaasLoginContextEntry element (string). | JAAS login context entry for authentication. If updated while the server is running, the update is applied with new connection requests; in-use connections are not impacted. | |
isolationLevel |
| Default transaction isolation level. If unspecified and the database is identified as DB2, Derby, Informix, Microsoft SQL Server or Sybase, TRANSACTION_REPEATABLE_READ is used. If unspecified for other databases, TRANSACTION_READ_COMMITTED is used. If updated while the server is running, the update is applied with new connection requests; in-use connections are not impacted. TRANSACTION_SNAPSHOT Snapshot isolation for Microsoft SQL Server JDBC Driver and DataDirect Connect for JDBC driver. TRANSACTION_READ_UNCOMMITTED Dirty reads, non-repeatable reads and phantom reads can occur. TRANSACTION_READ_COMMITTED Dirty reads are prevented; non-repeatable reads and phantom reads can occur. TRANSACTION_SERIALIZABLE Dirty reads, non-repeatable reads and phantom reads are prevented. TRANSACTION_REPEATABLE_READ Dirty reads and non-repeatable reads are prevented; phantom reads can occur. | |
statementCacheSize | int Min: 0 | 10 | Maximum number of cached statements per connection. If updated while the server is running, the statement cache is resized upon next use. |
transactional | boolean | true | Enable participation in transactions that are managed by the application server. If updated while the server is running, existing connections are destroyed. |
beginTranForResultSetScrollingAPIs | boolean | true | Attempt transaction enlistment when result set scrolling interfaces are used. |
beginTranForVendorAPIs | boolean | true | Attempt transaction enlistment when vendor interfaces are used. |
commitOrRollbackOnCleanup |
| Determines how to clean up connections that might be in a database unit of work (AutoCommit=false) when the connection is closed or returned to the pool. rollback Clean up the connection by rolling back. commit Clean up the connection by committing. | |
queryTimeout | A period of time with second precision | Default query timeout for SQL statements. In a JTA transaction, syncQueryTimeoutWithTransactionTimeout can override this default. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
recoveryAuthDataRef | A reference to top level authData element (string). | Authentication data for transaction recovery. | |
syncQueryTimeoutWithTransactionTimeout | boolean | false | Use the time remaining (if any) in a JTA transaction as the default query timeout for SQL statements. |
supplementalJDBCTrace | boolean | Supplements the JDBC driver trace that is logged when JDBC driver trace is enabled in bootstrap.properties. JDBC driver trace specifications include: com.ibm.ws.database.logwriter, com.ibm.ws.db2.logwriter, com.ibm.ws.derby.logwriter, com.ibm.ws.informix.logwriter, com.ibm.ws.oracle.logwriter, com.ibm.ws.sqlserver.logwriter, com.ibm.ws.sybase.logwriter. If updated while the server is running, existing connections are destroyed. | |
validationTimeout | A period of time with second precision | Specifies a timeout for validation of pooled connections. When specified, pooled connections are validated before being reused from the connection pool. The validation timeout is also used when the connection manager validates connections in response to a stale connection for PurgePolicy=ValidateAllConnections. A value of 0 means that connections are validated without applying any timeout. Validation timeout requires a JDBC driver that complies with the JDBC 4.0 specification or higher. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
JDBC driver for a data source. If updated while the server is running, existing connections are destroyed.
Name | Type | Default | Description |
---|---|---|---|
libraryRef | A reference to top level library element (string). | Identifies JDBC driver JARs and native files. | |
javax.sql.XADataSource | string | JDBC driver implementation of javax.sql.XADataSource. | |
javax.sql.ConnectionPoolDataSource | string | JDBC driver implementation of javax.sql.ConnectionPoolDataSource. | |
javax.sql.DataSource | string | JDBC driver implementation of javax.sql.DataSource. |
dataSource > jdbcDriver > library
Identifies JDBC driver JARs and native files.
Name | Type | Default | Description |
---|---|---|---|
name | string | Name of shared library for administrators | |
description | string | Description of shared library for administrators | |
filesetRef | List of references to top level fileset elements (comma-separated string). | Id of referenced Fileset | |
apiTypeVisibility | string | spec,ibm-api,api,stable | The types of API packages that this class loader supports. This value is a comma-separated list of any combination of the following API packages: spec, ibm-api, api, stable, third-party. |
dataSource > jdbcDriver > library > fileset
Id of referenced Fileset
Name | Type | Default | Description |
---|---|---|---|
id | string | A unique configuration ID. | |
dir | Path to a directory | ${server.config.dir} | The base directory to search for files. |
caseSensitive | boolean | true | Boolean to indicate whether or not the search should be case sensitive (default: true). |
includes | string | * | The comma or space separated list of file name patterns to include in the search results (default: *). |
excludes | string | The comma or space separated list of file name patterns to exclude from the search results, by default no files are excluded. | |
scanInterval | A period of time with millisecond precision | 0 | Scanning interval to check the fileset for changes as a long with a time unit suffix h-hour, m-minute, s-second, ms-millisecond (e.g. 2ms or 5s). Disabled (scanInterval=0) by default. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), seconds (s), or milliseconds (ms). For example, specify 500 milliseconds as 500ms. You can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds. |
dataSource > jdbcDriver > library > folder
Id of referenced folder
Name | Type | Default | Description |
---|---|---|---|
id | string | A unique configuration ID. | |
dir | Path to a directory | Directory or folder to be included in the library classpath for locating resource files |
dataSource > jdbcDriver > library > file
Id of referenced File
Name | Type | Default | Description |
---|---|---|---|
id | string | A unique configuration ID. | |
name | Path to a file | Fully qualified filename |
dataSource > connectionManager
Connection manager for a data source. If updated while the server is running, existing connections are destroyed.
Name | Type | Default | Description |
---|---|---|---|
agedTimeout | A period of time with second precision | -1 | Amount of time before a connection can be discarded by pool maintenance. A value of -1 disables this timeout. A value of 0 discards every connection, which disables connection pooling. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
connectionTimeout | A period of time with second precision | 30s | Amount of time after which a connection request times out. A value of -1 disables this timeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
maxIdleTime | A period of time with second precision | 30m | Amount of time a connection can be unused or idle until it can be discarded during pool maintenance, if doing so does not reduce the pool below the minimum size. A value of -1 disables this timeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
maxPoolSize | int Min: 0 | 50 | Maximum number of physical connections for a pool. A value of 0 means unlimited. |
minPoolSize | int Min: 0 | Minimum number of physical connections to maintain in the pool. The pool is not pre-populated. Aged timeout can override the minimum. | |
purgePolicy |
| EntirePool | Specifies which connections to destroy when a stale connection is detected in a pool. FailingConnectionOnly When a stale connection is detected, only the connection which was found to be bad is closed. ValidateAllConnections When a stale connection is detected, connections are tested and those found to be bad are closed. EntirePool When a stale connection is detected, all connections in the pool are marked stale, and when no longer in use, are closed. |
reapTime | A period of time with second precision | 3m | Amount of time between runs of the pool maintenance thread. A value of -1 disables pool maintenance. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
maxConnectionsPerThread | int Min: 0 | Limits the number of open connections on each thread. | |
numConnectionsPerThreadLocal | int Min: 0 | Caches the specified number of connections for each thread. | |
enableSharingForDirectLookups | boolean | true | If set to true, connections are shared. If set to false, connections are unshared. |
dataSource > properties.informix
Data source properties for the Informix JDBC driver.
Name | Type | Default | Description |
---|---|---|---|
databaseName | string | JDBC driver property: databaseName. | |
ifxIFXHOST | string | localhost | JDBC driver property: ifxIFXHOST. |
serverName | string | Server where the database is running. | |
portNumber | int | 1526 | Port on which to obtain database connections. |
ifxCLIENT_LOCALE | string | JDBC driver property: ifxCLIENT_LOCALE. | |
ifxCPMAgeLimit | A period of time with second precision | JDBC driver property: ifxCPMAgeLimit. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
ifxCPMInitPoolSize | int | JDBC driver property: ifxCPMInitPoolSize. | |
ifxCPMMaxConnections | int | JDBC driver property: ifxCPMMaxConnections. | |
ifxCPMMaxPoolSize | int | JDBC driver property: ifxCPMMaxPoolSize. | |
ifxCPMMinAgeLimit | A period of time with second precision | JDBC driver property: ifxCPMMinAgeLimit. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
ifxCPMMinPoolSize | int | JDBC driver property: ifxCPMMinPoolSize. | |
ifxCPMServiceInterval | A period of time with millisecond precision | JDBC driver property: ifxCPMServiceInterval. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), seconds (s), or milliseconds (ms). For example, specify 500 milliseconds as 500ms. You can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds. | |
ifxDBANSIWARN | boolean | JDBC driver property: ifxDBANSIWARN. | |
ifxDBCENTURY | string | JDBC driver property: ifxDBCENTURY. | |
ifxDBDATE | string | JDBC driver property: ifxDBDATE. | |
ifxDBSPACETEMP | string | JDBC driver property: ifxDBSPACETEMP. | |
ifxDBTEMP | string | JDBC driver property: ifxDBTEMP. | |
ifxDBTIME | string | JDBC driver property: ifxDBTIME. | |
ifxDBUPSPACE | string | JDBC driver property: ifxDBUPSPACE. | |
ifxDB_LOCALE | string | JDBC driver property: ifxDB_LOCALE. | |
ifxDELIMIDENT | boolean | JDBC driver property: ifxDELIMIDENT. | |
ifxENABLE_TYPE_CACHE | boolean | JDBC driver property: ifxENABLE_TYPE_CACHE. | |
ifxFET_BUF_SIZE | int | JDBC driver property: ifxFET_BUF_SIZE. | |
ifxGL_DATE | string | JDBC driver property: ifxGL_DATE. | |
ifxGL_DATETIME | string | JDBC driver property: ifxGL_DATETIME. | |
ifxIFX_AUTOFREE | boolean | JDBC driver property: ifxIFX_AUTOFREE. | |
ifxIFX_DIRECTIVES | string | JDBC driver property: ifxIFX_DIRECTIVES. | |
ifxIFX_LOCK_MODE_WAIT | A period of time with second precision | 2s | JDBC driver property: ifxIFX_LOCK_MODE_WAIT. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
ifxIFX_SOC_TIMEOUT | A period of time with millisecond precision | JDBC driver property: ifxIFX_SOC_TIMEOUT. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), seconds (s), or milliseconds (ms). For example, specify 500 milliseconds as 500ms. You can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds. | |
ifxIFX_USEPUT | boolean | JDBC driver property: ifxIFX_USEPUT. | |
ifxIFX_USE_STRENC | boolean | JDBC driver property: ifxIFX_USE_STRENC. | |
ifxIFX_XASPEC | string | y | JDBC driver property: ifxIFX_XASPEC. |
ifxINFORMIXCONRETRY | int | JDBC driver property: ifxINFORMIXCONRETRY. | |
ifxINFORMIXCONTIME | A period of time with second precision | JDBC driver property: ifxINFORMIXCONTIME. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
ifxINFORMIXOPCACHE | string | JDBC driver property: ifxINFORMIXOPCACHE. | |
ifxINFORMIXSTACKSIZE | int | JDBC driver property: ifxINFORMIXSTACKSIZE. | |
ifxJDBCTEMP | string | JDBC driver property: ifxJDBCTEMP. | |
ifxLDAP_IFXBASE | string | JDBC driver property: ifxLDAP_IFXBASE. | |
ifxLDAP_PASSWD | string | JDBC driver property: ifxLDAP_PASSWD. | |
ifxLDAP_URL | string | JDBC driver property: ifxLDAP_URL. | |
ifxLDAP_USER | string | JDBC driver property: ifxLDAP_USER. | |
ifxLOBCACHE | int | JDBC driver property: ifxLOBCACHE. | |
ifxNEWCODESET | string | JDBC driver property: ifxNEWCODESET. | |
ifxNEWLOCALE | string | JDBC driver property: ifxNEWLOCALE. | |
ifxNODEFDAC | string | JDBC driver property: ifxNODEFDAC. | |
ifxOPTCOMPIND | string | JDBC driver property: ifxOPTCOMPIND. | |
ifxOPTOFC | string | JDBC driver property: ifxOPTOFC. | |
ifxOPT_GOAL | string | JDBC driver property: ifxOPT_GOAL. | |
ifxPATH | string | JDBC driver property: ifxPATH. | |
ifxPDQPRIORITY | string | JDBC driver property: ifxPDQPRIORITY. | |
ifxPLCONFIG | string | JDBC driver property: ifxPLCONFIG. | |
ifxPLOAD_LO_PATH | string | JDBC driver property: ifxPLOAD_LO_PATH. | |
ifxPROTOCOLTRACE | int | JDBC driver property: ifxPROTOCOLTRACE. | |
ifxPROTOCOLTRACEFILE | string | JDBC driver property: ifxPROTOCOLTRACEFILE. | |
ifxPROXY | string | JDBC driver property: ifxPROXY. | |
ifxPSORT_DBTEMP | string | JDBC driver property: ifxPSORT_DBTEMP. | |
ifxPSORT_NPROCS | boolean | JDBC driver property: ifxPSORT_NPROCS. | |
ifxSECURITY | string | JDBC driver property: ifxSECURITY. | |
ifxSQLH_FILE | string | JDBC driver property: ifxSQLH_FILE. | |
ifxSQLH_LOC | string | JDBC driver property: ifxSQLH_LOC. | |
ifxSQLH_TYPE | string | JDBC driver property: ifxSQLH_TYPE. | |
ifxSSLCONNECTION | string | JDBC driver property: ifxSSLCONNECTION. | |
ifxSTMT_CACHE | string | JDBC driver property: ifxSTMT_CACHE. | |
ifxTRACE | int | JDBC driver property: ifxTRACE. | |
ifxTRACEFILE | string | JDBC driver property: ifxTRACEFILE. | |
ifxTRUSTED_CONTEXT | string | JDBC driver property: ifxTRUSTED_CONTEXT. | |
ifxUSEV5SERVER | boolean | JDBC driver property: ifxUSEV5SERVER. | |
ifxUSE_DTENV | boolean | JDBC driver property: ifxUSE_DTENV. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
roleName | string | JDBC driver property: roleName. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. |
dataSource > properties.db2.i.native
Data source properties for the IBM DB2 for i Native JDBC driver.
Name | Type | Default | Description |
---|---|---|---|
databaseName | string | *LOCAL | JDBC driver property: databaseName. |
access |
| all | JDBC driver property: access. all all read call read call read only read only |
autoCommit | boolean | true | JDBC driver property: autoCommit. |
batchStyle |
| 2.0 | JDBC driver property: batchStyle. 2.0 2.0 2.1 2.1 |
behaviorOverride | int | JDBC driver property: behaviorOverride. | |
blockSize |
| 32 | JDBC driver property: blockSize. 0 0 256 256 16 16 512 512 128 128 8 8 64 64 32 32 |
cursorHold | boolean | false | JDBC driver property: cursorHold. |
cursorSensitivity |
| asensitive | JDBC driver property: cursorSensitivity. Values are: 0 (TYPE_SCROLL_SENSITIVE_STATIC), 1 (TYPE_SCROLL_SENSITIVE_DYNAMIC), 2 (TYPE_SCROLL_ASENSITIVE). asensitive asensitive sensitive sensitive |
dataTruncation | string | true | JDBC driver property: dataTruncation. |
dateFormat |
| JDBC driver property: dateFormat. julian julian dmy dmy ymd ymd usa usa eur eur mdy mdy iso iso jis jis | |
dateSeparator |
| JDBC driver property: dateSeparator. \, The comma character (,). b The character b - The dash character (-). . The period character (.). / The forward slash character (/). | |
decimalSeparator |
| JDBC driver property: decimalSeparator. \, The comma character (,). . The period character (.). | |
directMap | boolean | true | JDBC driver property: directMap. |
doEscapeProcessing | boolean | true | JDBC driver property: doEscapeProcessing. |
fullErrors | boolean | JDBC driver property: fullErrors. | |
libraries | string | JDBC driver property: libraries. | |
lobThreshold | int Max: 500000 | 0 | JDBC driver property: lobThreshold. |
lockTimeout | A period of time with second precision | 0 | JDBC driver property: lockTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
maximumPrecision |
| 31 | JDBC driver property: maximumPrecision. 63 63 31 31 |
maximumScale | int Min: 0 Max: 63 | 31 | JDBC driver property: maximumScale. |
minimumDivideScale | int Min: 0 Max: 9 | 0 | JDBC driver property: minimumDivideScale. |
networkProtocol | int | JDBC driver property: networkProtocol. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
portNumber | int | Port on which to obtain database connections. | |
prefetch | boolean | true | JDBC driver property: prefetch. |
queryOptimizeGoal |
| 2 | JDBC driver property: queryOptimizeGoal. Values are: 1 (*FIRSTIO) or 2 (*ALLIO). 1 *FIRSTIO 2 *ALLIO |
reuseObjects | boolean | true | JDBC driver property: reuseObjects. |
serverName | string | Server where the database is running. | |
serverTraceCategories | int | 0 | JDBC driver property: serverTraceCategories. |
systemNaming | boolean | false | JDBC driver property: systemNaming. |
timeFormat |
| JDBC driver property: timeFormat. usa usa eur eur iso iso jis jis hms hms | |
timeSeparator |
| JDBC driver property: timeSeparator. \, The comma character (,). b The character b : The colon character (:). . The period character (.). | |
trace | boolean | JDBC driver property: trace. | |
transactionTimeout | A period of time with second precision | 0 | JDBC driver property: transactionTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
translateBinary | boolean | false | JDBC driver property: translateBinary. |
translateHex |
| character | JDBC driver property: translateHex. character character binary binary |
useBlockInsert | boolean | false | JDBC driver property: useBlockInsert. |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. |
dataSource > properties.derby.embedded
Data source properties for Derby Embedded JDBC driver.
Name | Type | Default | Description |
---|---|---|---|
createDatabase |
| JDBC driver property: createDatabase. false Do not automatically create the database. create When the first connection is established, automatically create the database if it doesn't exist. | |
databaseName | string | JDBC driver property: databaseName. | |
connectionAttributes | string | JDBC driver property: connectionAttributes. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
shutdownDatabase |
| JDBC driver property: shutdownDatabase. false Do not shut down the database. shutdown Shut down the database when a connection is attempted. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. |
List of JDBC vendor properties for the data source. For example, databaseName="dbname" serverName="localhost" portNumber="50000".
Name | Type | Default | Description |
---|---|---|---|
databaseName | string | JDBC driver property: databaseName. | |
serverName | string | Server where the database is running. | |
portNumber | int | Port on which to obtain database connections. | |
URL | string | URL for connecting to the database. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. |
dataSource > properties.microsoft.sqlserver
Data source properties for Microsoft SQL Server JDBC Driver.
Name | Type | Default | Description |
---|---|---|---|
databaseName | string | JDBC driver property: databaseName. | |
instanceName | string | JDBC driver property: instanceName. | |
serverName | string | localhost | Server where the database is running. |
portNumber | int | Port on which to obtain database connections. | |
accessToken | string | JDBC driver property: accessToken. | |
applicationIntent |
| JDBC driver property: applicationIntent. ReadOnly ReadOnly ReadWrite ReadWrite | |
applicationName | string | JDBC driver property: applicationName. | |
authentication |
| JDBC driver property: authentication. ActiveDirectoryPassword ActiveDirectoryPassword ActiveDirectoryIntegrated ActiveDirectoryIntegrated SqlPassword SqlPassword NotSpecified NotSpecified | |
authenticationScheme |
| JDBC driver property: authenticationScheme. JavaKerberos JavaKerberos NativeAuthentication NativeAuthentication | |
columnEncryptionSetting |
| JDBC driver property: columnEncryptionSetting. Enabled Enabled Disabled Disabled | |
encrypt | boolean | JDBC driver property: encrypt. | |
failoverPartner | string | JDBC driver property: failoverPartner. | |
hostNameInCertificate | string | JDBC driver property: hostNameInCertificate. | |
integratedSecurity | boolean | JDBC driver property: integratedSecurity. | |
keyStoreAuthentication |
| JDBC driver property: keyStoreAuthentication. JavaKeyStorePassword JavaKeyStorePassword | |
keyStoreLocation | Path to a file | JDBC driver property: keyStoreLocation. | |
keyStoreSecret | Reversably encoded password (string) | JDBC driver property: keyStoreSecret. | |
lastUpdateCount | boolean | JDBC driver property: lastUpdateCount. | |
lockTimeout | A period of time with millisecond precision | JDBC driver property: lockTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), seconds (s), or milliseconds (ms). For example, specify 500 milliseconds as 500ms. You can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
multiSubnetFailover | boolean | JDBC driver property: multiSubnetFailover. | |
packetSize | int Min: -1 Max: 32767 | JDBC driver property: packetSize. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
responseBuffering |
| JDBC driver property: responseBuffering. adaptive adaptive full full | |
selectMethod |
| JDBC driver property: selectMethod. cursor cursor direct direct | |
sendStringParametersAsUnicode | boolean | false | JDBC driver property: sendStringParametersAsUnicode. |
sendTimeAsDatetime | boolean | JDBC driver property: sendTimeAsDatetime. | |
serverNameAsACE | boolean | JDBC driver property: serverNameAsACE. | |
serverSpn | string | JDBC driver property: serverSpn. | |
transparentNetworkIPResolution | boolean | JDBC driver property: transparentNetworkIPResolution. | |
trustServerCertificate | boolean | JDBC driver property: trustServerCertificate. | |
trustStore | string | JDBC driver property: trustStore. | |
trustStorePassword | Reversably encoded password (string) | JDBC driver property: trustStorePassword. | |
URL | string | URL for connecting to the database. Example: jdbc:sqlserver://localhost:1433;databaseName=myDB. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. | |
workstationID | string | JDBC driver property: workstationID. | |
xopenStates | boolean | JDBC driver property: xopenStates. |
dataSource > properties.oracle
Data source properties for Oracle JDBC driver.
Name | Type | Default | Description |
---|---|---|---|
driverType |
| thin | JDBC driver property: driverType. oci oci thin thin |
databaseName | string | JDBC driver property: databaseName. | |
serverName | string | localhost | Server where the database is running. |
portNumber | int | 1521 | Port on which to obtain database connections. |
URL | string | URL for connecting to the database. Examples: jdbc:oracle:thin:@//localhost:1521/sample or jdbc:oracle:oci:@//localhost:1521/sample. | |
connectionProperties | string | JDBC driver property: connectionProperties. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
networkProtocol | string | JDBC driver property: networkProtocol. | |
ONSConfiguration | string | JDBC driver property: ONSConfiguration. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
roleName | string | JDBC driver property: roleName. | |
serviceName | string | JDBC driver property: serviceName. | |
TNSEntryName | string | JDBC driver property: TNSEntryName. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. |
dataSource > properties.derby.client
Data source properties for Derby Network Client JDBC driver.
Name | Type | Default | Description |
---|---|---|---|
createDatabase |
| JDBC driver property: createDatabase. false Do not automatically create the database. create When the first connection is established, automatically create the database if it doesn't exist. | |
databaseName | string | JDBC driver property: databaseName. | |
serverName | string | localhost | Server where the database is running. |
portNumber | int | 1527 | Port on which to obtain database connections. |
connectionAttributes | string | JDBC driver property: connectionAttributes. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
retrieveMessageText | boolean | true | JDBC driver property: retrieveMessageText. |
securityMechanism |
| 3 | JDBC driver property: securityMechanism. Values are: 3 (CLEAR_TEXT_PASSWORD_SECURITY), 4 (USER_ONLY_SECURITY), 7 (ENCRYPTED_PASSWORD_SECURITY), 8 (STRONG_PASSWORD_SUBSTITUTE_SECURITY), 9 (ENCRYPTED_USER_AND_PASSWORD_SECURITY). 3 CLEAR_TEXT_PASSWORD_SECURITY 4 USER_ONLY_SECURITY 7 ENCRYPTED_PASSWORD_SECURITY 8 STRONG_PASSWORD_SUBSTITUTE_SECURITY 9 ENCRYPTED_USER_AND_PASSWORD_SECURITY |
shutdownDatabase |
| JDBC driver property: shutdownDatabase. false Do not shut down the database. shutdown Shut down the database when a connection is attempted. | |
ssl |
| JDBC driver property: ssl. peerAuthentication peerAuthentication basic basic off off | |
traceDirectory | string | JDBC driver property: traceDirectory. | |
traceFile | string | JDBC driver property: traceFile. | |
traceFileAppend | boolean | JDBC driver property: traceFileAppend. | |
traceLevel | int | Bitwise combination of the following constant values: TRACE_NONE=0, TRACE_CONNECTION_CALLS=1, TRACE_STATEMENT_CALLS=2, TRACE_RESULT_SET_CALLS=4, TRACE_DRIVER_CONFIGURATION=16, TRACE_CONNECTS=32, TRACE_DRDA_FLOWS=64, TRACE_RESULT_SET_META_DATA=128, TRACE_PARAMETER_META_DATA=256, TRACE_DIAGNOSTICS=512, TRACE_XA_CALLS=2048, TRACE_ALL=-1. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. |
dataSource > properties.datadirect.sqlserver
Data source properties for the DataDirect Connect for JDBC driver for Microsoft SQL Server.
Name | Type | Default | Description |
---|---|---|---|
databaseName | string | JDBC driver property: databaseName. | |
serverName | string | localhost | Server where the database is running. |
portNumber | int | Port on which to obtain database connections. | |
accountingInfo | string | JDBC driver property: accountingInfo. | |
alternateServers | string | JDBC driver property: alternateServers. | |
alwaysReportTriggerResults | boolean | JDBC driver property: alwaysReportTriggerResults. | |
applicationName | string | JDBC driver property: applicationName. | |
authenticationMethod |
| JDBC driver property: authenticationMethod. auto auto ntlm ntlm userIdPassword userIdPassword kerberos kerberos | |
bulkLoadBatchSize | long | JDBC driver property: bulkLoadBatchSize. | |
bulkLoadOptions | long | JDBC driver property: bulkLoadOptions. | |
clientHostName | string | JDBC driver property: clientHostName. | |
clientUser | string | JDBC driver property: clientUser. | |
codePageOverride | string | JDBC driver property: codePageOverride. | |
connectionRetryCount | int | JDBC driver property: connectionRetryCount. | |
connectionRetryDelay | A period of time with second precision | JDBC driver property: connectionRetryDelay. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
convertNull | int | JDBC driver property: convertNull. | |
dateTimeInputParameterType |
| JDBC driver property: dateTimeInputParameterType. dateTime dateTime dateTimeOffset dateTimeOffset auto auto | |
dateTimeOutputParameterType |
| JDBC driver property: dateTimeOutputParameterType. dateTime dateTime dateTimeOffset dateTimeOffset auto auto | |
describeInputParameters |
| JDBC driver property: describeInputParameters. describeIfString describeIfString describeIfDateTime describeIfDateTime noDescribe noDescribe describeAll describeAll | |
describeOutputParameters |
| JDBC driver property: describeOutputParameters. describeIfString describeIfString describeIfDateTime describeIfDateTime noDescribe noDescribe describeAll describeAll | |
enableBulkLoad | boolean | JDBC driver property: enableBulkLoad. | |
enableCancelTimeout | boolean | JDBC driver property: enableCancelTimeout. | |
encryptionMethod |
| JDBC driver property: encryptionMethod. noEncryption noEncryption loginSSL loginSSL requestSSL requestSSL SSL SSL | |
failoverGranularity |
| JDBC driver property: failoverGranularity. nonAtomic nonAtomic disableIntegrityCheck disableIntegrityCheck atomic atomic atomicWithRepositioning atomicWithRepositioning | |
failoverMode |
| JDBC driver property: failoverMode. select select connect connect extended extended | |
failoverPreconnect | boolean | JDBC driver property: failoverPreconnect. | |
hostNameInCertificate | string | JDBC driver property: hostNameInCertificate. | |
initializationString | string | JDBC driver property: initializationString. | |
insensitiveResultSetBufferSize | int | JDBC driver property: insensitiveResultSetBufferSize. | |
javaDoubleToString | boolean | JDBC driver property: javaDoubleToString. | |
JDBCBehavior |
| 0 | JDBC driver property: JDBCBehavior. Values are: 0 (JDBC 4.0) or 1 (JDBC 3.0). 0 JDBC 4.0 1 JDBC 3.0 |
loadBalancing | boolean | JDBC driver property: loadBalancing. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
longDataCacheSize | int Min: -1 | JDBC driver property: longDataCacheSize. | |
netAddress | string | JDBC driver property: netAddress. | |
packetSize | int Min: -1 Max: 128 | JDBC driver property: packetSize. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
queryTimeout | A period of time with second precision | JDBC driver property: queryTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
resultsetMetaDataOptions | int | JDBC driver property: resultsetMetaDataOptions. | |
selectMethod |
| JDBC driver property: selectMethod. cursor cursor direct direct | |
snapshotSerializable | boolean | JDBC driver property: snapshotSerializable. | |
spyAttributes | string | JDBC driver property: spyAttributes. | |
stringInputParameterType |
| varchar | JDBC driver property: stringInputParameterType. nvarchar nvarchar varchar varchar |
stringOutputParameterType |
| varchar | JDBC driver property: stringOutputParameterType. nvarchar nvarchar varchar varchar |
suppressConnectionWarnings | boolean | JDBC driver property: suppressConnectionWarnings. | |
transactionMode |
| JDBC driver property: transactionMode. explicit explicit implicit implicit | |
truncateFractionalSeconds | boolean | JDBC driver property: truncateFractionalSeconds. | |
trustStore | string | JDBC driver property: trustStore. | |
trustStorePassword | Reversably encoded password (string) | JDBC driver property: trustStorePassword. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. | |
useServerSideUpdatableCursors | boolean | JDBC driver property: useServerSideUpdatableCursors. | |
validateServerCertificate | boolean | JDBC driver property: validateServerCertificate. | |
XATransactionGroup | string | JDBC driver property: XATransactionGroup. | |
XMLDescribeType |
| JDBC driver property: XMLDescribeType. longvarbinary longvarbinary longvarchar longvarchar |
dataSource > properties.informix.jcc
Data source properties for the IBM Data Server Driver for JDBC and SQLJ for Informix.
Name | Type | Default | Description |
---|---|---|---|
databaseName | string | JDBC driver property: databaseName. | |
serverName | string | localhost | Server where the database is running. |
portNumber | int | 1526 | Port on which to obtain database connections. |
currentLockTimeout | A period of time with second precision | 2s | JDBC driver property: currentLockTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. |
DBANSIWARN | boolean | JDBC driver property: DBANSIWARN. | |
DBDATE | string | JDBC driver property: DBDATE. | |
DBPATH | string | JDBC driver property: DBPATH. | |
DBSPACETEMP | string | JDBC driver property: DBSPACETEMP. | |
DBTEMP | string | JDBC driver property: DBTEMP. | |
DBUPSPACE | string | JDBC driver property: DBUPSPACE. | |
DELIMIDENT | boolean | JDBC driver property: DELIMIDENT. | |
deferPrepares | boolean | JDBC driver property: deferPrepares. | |
driverType | int | 4 | JDBC driver property: driverType. |
enableNamedParameterMarkers | int | JDBC driver property: enableNamedParameterMarkers. Values are: 1 (YES) or 2 (NO). | |
enableSeamlessFailover | int | JDBC driver property: enableSeamlessFailover. Values are: 1 (YES) or 2 (NO). | |
enableSysplexWLB | boolean | JDBC driver property: enableSysplexWLB. | |
fetchSize | int | JDBC driver property: fetchSize. | |
fullyMaterializeLobData | boolean | JDBC driver property: fullyMaterializeLobData. | |
IFX_DIRECTIVES |
| JDBC driver property: IFX_DIRECTIVES. OFF OFF ON ON | |
IFX_EXTDIRECTIVES |
| JDBC driver property: IFX_EXTDIRECTIVES. OFF OFF ON ON | |
IFX_UPDDESC | string | JDBC driver property: IFX_UPDDESC. | |
IFX_XASTDCOMPLIANCE_XAEND |
| JDBC driver property: IFX_XASTDCOMPLIANCE_XAEND. 0 0 1 1 | |
INFORMIXOPCACHE | string | JDBC driver property: INFORMIXOPCACHE. | |
INFORMIXSTACKSIZE | string | JDBC driver property: INFORMIXSTACKSIZE. | |
keepDynamic | int | JDBC driver property: keepDynamic. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
NODEFDAC |
| JDBC driver property: NODEFDAC. no no yes yes | |
OPTCOMPIND |
| JDBC driver property: OPTCOMPIND. 0 0 1 1 2 2 | |
OPTOFC |
| JDBC driver property: OPTOFC. 0 0 1 1 | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
PDQPRIORITY |
| JDBC driver property: PDQPRIORITY. HIGH HIGH LOW LOW OFF OFF | |
progressiveStreaming |
| JDBC driver property: progressiveStreaming. Values are: 1 (YES) or 2 (NO). 1 YES 2 NO | |
PSORT_DBTEMP | string | JDBC driver property: PSORT_DBTEMP. | |
PSORT_NPROCS | string Max: 10 | JDBC driver property: PSORT_NPROCS. | |
queryDataSize | int Min: 4096 Max: 10485760 | JDBC driver property: queryDataSize. | |
resultSetHoldability |
| JDBC driver property: resultSetHoldability. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT). 1 HOLD_CURSORS_OVER_COMMIT 2 CLOSE_CURSORS_AT_COMMIT | |
resultSetHoldabilityForCatalogQueries |
| JDBC driver property: resultSetHoldabilityForCatalogQueries. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT). 1 HOLD_CURSORS_OVER_COMMIT 2 CLOSE_CURSORS_AT_COMMIT | |
retrieveMessagesFromServerOnGetMessage | boolean | true | JDBC driver property: retrieveMessagesFromServerOnGetMessage. |
securityMechanism |
| JDBC driver property: securityMechanism. Values are: 3 (CLEAR_TEXT_PASSWORD_SECURITY), 4 (USER_ONLY_SECURITY), 7 (ENCRYPTED_PASSWORD_SECURITY), 9 (ENCRYPTED_USER_AND_PASSWORD_SECURITY). 3 CLEAR_TEXT_PASSWORD_SECURITY 4 USER_ONLY_SECURITY 7 ENCRYPTED_PASSWORD_SECURITY 9 ENCRYPTED_USER_AND_PASSWORD_SECURITY | |
STMT_CACHE |
| JDBC driver property: STMT_CACHE. 0 0 1 1 | |
traceDirectory | string | JDBC driver property: traceDirectory. | |
traceFile | string | JDBC driver property: traceFile. | |
traceFileAppend | boolean | JDBC driver property: traceFileAppend. | |
traceLevel | int | Bitwise combination of the following constant values: TRACE_NONE=0, TRACE_CONNECTION_CALLS=1, TRACE_STATEMENT_CALLS=2, TRACE_RESULT_SET_CALLS=4, TRACE_DRIVER_CONFIGURATION=16, TRACE_CONNECTS=32, TRACE_DRDA_FLOWS=64, TRACE_RESULT_SET_META_DATA=128, TRACE_PARAMETER_META_DATA=256, TRACE_DIAGNOSTICS=512, TRACE_SQLJ=1024, TRACE_META_CALLS=8192, TRACE_DATASOURCE_CALLS=16384, TRACE_LARGE_OBJECT_CALLS=32768, TRACE_SYSTEM_MONITOR=131072, TRACE_TRACEPOINTS=262144, TRACE_ALL=-1. | |
useJDBC4ColumnNameAndLabelSemantics | int | JDBC driver property: useJDBC4ColumnNameAndLabelSemantics. Values are: 1 (YES) or 2 (NO). | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. |
dataSource > properties.db2.jcc
Data source properties for the IBM Data Server Driver for JDBC and SQLJ for DB2.
Name | Type | Default | Description |
---|---|---|---|
driverType |
| 4 | JDBC driver property: driverType. 2 Type 2 JDBC driver. 4 Type 4 JDBC driver. |
databaseName | string | JDBC driver property: databaseName. | |
serverName | string | localhost | Server where the database is running. |
portNumber | int | 50000 | Port on which to obtain database connections. |
accountingInterval | string | JDBC driver property: accountingInterval. | |
activateDatabase | int | JDBC driver property: activateDatabase. | |
affinityFailbackInterval | A period of time with second precision | JDBC driver property: affinityFailbackInterval. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
allowNextOnExhaustedResultSet |
| JDBC driver property: allowNextOnExhaustedResultSet. 1 YES 2 NO | |
allowNullResultSetForExecuteQuery |
| JDBC driver property: allowNullResultSetForExecuteQuery. 1 YES 2 NO | |
alternateGroupDatabaseName | string | JDBC driver property: alternateGroupDatabaseName. | |
alternateGroupPortNumber | string | JDBC driver property: alternateGroupPortNumber. | |
alternateGroupServerName | string | JDBC driver property: alternateGroupServerName. | |
atomicMultiRowInsert |
| JDBC driver property: atomicMultiRowInsert. 1 YES 2 NO | |
blockingReadConnectionTimeout | A period of time with second precision | JDBC driver property: blockingReadConnectionTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
charOutputSize | short | JDBC driver property: charOutputSize. | |
clientApplcompat | string | JDBC driver property: clientApplcompat. | |
clientAccountingInformation | string | JDBC driver property: clientAccountingInformation. | |
clientApplicationInformation | string | JDBC driver property: clientApplicationInformation. | |
clientBidiStringType |
| JDBC driver property: clientBidiStringType. 11 BIDI_ST11 4 BIDI_ST4 5 BIDI_ST5 6 BIDI_ST6 7 BIDI_ST7 8 BIDI_ST8 9 BIDI_ST9 10 BIDI_ST10 | |
clientDebugInfo | string Max: 254 | JDBC driver property: clientDebugInfo. | |
clientProgramId | string Max: 80 | JDBC driver property: clientProgramId. | |
clientProgramName | string Max: 12 | JDBC driver property: clientProgramName. | |
clientRerouteAlternatePortNumber | string | JDBC driver property: clientRerouteAlternatePortNumber. | |
clientRerouteAlternateServerName | string | JDBC driver property: clientRerouteAlternateServerName. | |
clientUser | string | JDBC driver property: clientUser. | |
clientWorkstation | string | JDBC driver property: clientWorkstation. | |
commandTimeout | A period of time with second precision | JDBC driver property: commandTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
concurrentAccessResolution |
| JDBC driver property: concurrentAccessResolution. 1 CONCURRENTACCESS_USE_CURRENTLY_COMMITTED 2 CONCURRENTACCESS_WAIT_FOR_OUTCOME | |
connectionCloseWithInFlightTransaction |
| JDBC driver property: connectionCloseWithInFlightTransaction. 1 CONNECTION_CLOSE_WITH_EXCEPTION 2 CONNECTION_CLOSE_WITH_ROLLBACK | |
connectionTimeout | A period of time with second precision | JDBC driver property: connectionTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
connectNode | int Min: 0 Max: 999 | JDBC driver property: connectNode. | |
currentAlternateGroupEntry | int | JDBC driver property: currentAlternateGroupEntry. | |
currentDegree | string | JDBC driver property: currentDegree. | |
currentExplainMode | string Max: 254 | JDBC driver property: currentExplainMode. | |
currentExplainSnapshot | int Max: 8 | JDBC driver property: currentExplainSnapshot. | |
currentFunctionPath | string | JDBC driver property: currentFunctionPath. | |
currentLocaleLcCtype | string | JDBC driver property: currentLocaleLcCtype. | |
currentLockTimeout | A period of time with second precision | JDBC driver property: currentLockTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
currentMaintainedTableTypesForOptimization |
| JDBC driver property: currentMaintainedTableTypesForOptimization. SYSTEM SYSTEM ALL ALL NONE NONE USER USER | |
currentPackagePath | string | JDBC driver property: currentPackagePath. | |
currentPackageSet | string | JDBC driver property: currentPackageSet. | |
currentQueryOptimization |
| JDBC driver property: currentQueryOptimization. 0 0 1 1 2 2 3 3 5 5 7 7 9 9 | |
currentSQLID | string | JDBC driver property: currentSQLID. | |
currentSchema | string | JDBC driver property: currentSchema. | |
cursorSensitivity |
| JDBC driver property: cursorSensitivity. Values are: 0 (TYPE_SCROLL_SENSITIVE_STATIC), 1 (TYPE_SCROLL_SENSITIVE_DYNAMIC), 2 (TYPE_SCROLL_ASENSITIVE). 0 TYPE_SCROLL_SENSITIVE_STATIC 1 TYPE_SCROLL_SENSITIVE_DYNAMIC 2 TYPE_SCROLL_ASENSITIVE | |
dateFormat |
| JDBC driver property: dateFormat. 1 ISO 2 USA 3 EUR 4 JIS | |
decimalRoundingMode |
| JDBC driver property: decimalRoundingMode. 1 ROUND_DOWN 2 ROUND_CEILING 3 ROUND_HALF_EVEN 4 ROUND_HALF_UP 6 ROUND_FLOOR | |
decimalSeparator |
| JDBC driver property: decimalSeparator. 1 DECIMAL_SEPARATOR_PERIOD 2 DECIMAL_SEPARATOR_COMMA | |
decimalStringFormat |
| JDBC driver property: decimalStringFormat. 1 DECIMAL_STRING_FORMAT_TO_STRING 2 DECIMAL_STRING_FORMAT_TO_PLAIN_STRING | |
deferPrepares | boolean | true | JDBC driver property: deferPrepares. |
downgradeHoldCursorsUnderXa | boolean | JDBC driver property: downgradeHoldCursorsUnderXa. | |
enableAlternateGroupSeamlessACR | boolean | JDBC driver property: enableAlternateGroupSeamlessACR. | |
enableBidiLayoutTransformation | boolean | JDBC driver property: enableBidiLayoutTransformation. | |
enableClientAffinitiesList |
| JDBC driver property: enableClientAffinitiesList. Values are: 1 (YES) or 2 (NO). 1 YES 2 NO | |
enableConnectionConcentrator | boolean | JDBC driver property: enableConnectionConcentrator. | |
enableExtendedDescribe |
| JDBC driver property: enableExtendedDescribe. 1 YES 2 NO | |
enableExtendedIndicators |
| JDBC driver property: enableExtendedIndicators. 1 YES 2 NO | |
enableMultiRowInsertSupport | boolean | JDBC driver property: enableMultiRowInsertSupport. | |
enableNamedParameterMarkers |
| JDBC driver property: enableNamedParameterMarkers. Values are: 1 (YES) or 2 (NO). 1 YES 2 NO | |
enableRowsetSupport |
| JDBC driver property: enableRowsetSupport. 1 YES 2 NO | |
enableSeamlessFailover |
| JDBC driver property: enableSeamlessFailover. Values are: 1 (YES) or 2 (NO). 1 YES 2 NO | |
enableSysplexWLB | boolean | JDBC driver property: enableSysplexWLB. | |
enableT2zosLBF |
| JDBC driver property: enableT2zosLBF. 1 YES 2 NO | |
enableT2zosLBFSPResultSets |
| JDBC driver property: enableT2zosLBFSPResultSets. 1 YES 2 NO | |
enableXACleanTransaction | boolean | JDBC driver property: enableXACleanTransaction. | |
encryptionAlgorithm |
| JDBC driver property: encryptionAlgorithm. 1 1 2 2 | |
extendedTableInfo |
| JDBC driver property: extendedTableInfo. 1 YES 2 NO | |
fetchSize | int | JDBC driver property: fetchSize. | |
fullyMaterializeInputStreams | boolean | JDBC driver property: fullyMaterializeInputStreams. | |
fullyMaterializeInputStreamsOnBatchExecution |
| JDBC driver property: fullyMaterializeInputStreamsOnBatchExecution. 1 YES 2 NO | |
fullyMaterializeLobData | boolean | JDBC driver property: fullyMaterializeLobData. | |
implicitRollbackOption |
| JDBC driver property: implicitRollbackOption. 0 IMPLICIT_ROLLBACK_OPTION_NOT_SET 1 IMPLICIT_ROLLBACK_OPTION_NOT_CLOSE_CONNECTION 2 IMPLICIT_ROLLBACK_OPTION_CLOSE_CONNECTION | |
interruptProcessingMode |
| JDBC driver property: interruptProcessingMode. 0 INTERRUPT_PROCESSING_MODE_DISABLED 1 INTERRUPT_PROCESSING_MODE_STATEMENT_CANCEL 2 INTERRUPT_PROCESSING_MODE_CLOSE_SOCKET | |
jdbcCollection | string | JDBC driver property: jdbcCollection. | |
keepAliveTimeOut | A period of time with second precision | JDBC driver property: keepAliveTimeOut. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
keepDynamic | int | JDBC driver property: keepDynamic. | |
kerberosServerPrincipal | string | JDBC driver property: kerberosServerPrincipal. | |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
maxConnCachedParamBufferSize | int | JDBC driver property: maxConnCachedParamBufferSize. | |
maxRetriesForClientReroute | int | JDBC driver property: maxRetriesForClientReroute. | |
maxRowsetSize | int | JDBC driver property: maxRowsetSize. | |
maxTransportObjects | int | JDBC driver property: maxTransportObjects. | |
memberConnectTimeout | A period of time with second precision | JDBC driver property: memberConnectTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
optimizationProfile | string | JDBC driver property: optimizationProfile. | |
optimizationProfileToFlush | string | JDBC driver property: optimizationProfileToFlush. | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
pkList | string | JDBC driver property: pkList. | |
profileName | string | JDBC driver property: profileName. | |
progressiveStreaming |
| JDBC driver property: progressiveStreaming. Values are: 1 (YES) or 2 (NO). 1 YES 2 NO | |
queryCloseImplicit |
| JDBC driver property: queryCloseImplicit. Values are: 1 (QUERY_CLOSE_IMPLICIT_YES) or 2 (QUERY_CLOSE_IMPLICIT_NO). 1 QUERY_CLOSE_IMPLICIT_YES 2 QUERY_CLOSE_IMPLICIT_NO | |
queryDataSize | int Min: 4096 Max: 65535 | JDBC driver property: queryDataSize. | |
queryTimeoutInterruptProcessingMode |
| JDBC driver property: queryTimeoutInterruptProcessingMode. 1 INTERRUPT_PROCESSING_MODE_STATEMENT_CANCEL 2 INTERRUPT_PROCESSING_MODE_CLOSE_SOCKET | |
readOnly | boolean | JDBC driver property: readOnly. | |
recordTemporalHistory |
| JDBC driver property: recordTemporalHistory. 1 YES 2 NO | |
reportLongTypes |
| JDBC driver property: reportLongTypes. 1 YES 2 NO | |
resultSetHoldability |
| JDBC driver property: resultSetHoldability. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT). 1 HOLD_CURSORS_OVER_COMMIT 2 CLOSE_CURSORS_AT_COMMIT | |
resultSetHoldabilityForCatalogQueries |
| JDBC driver property: resultSetHoldabilityForCatalogQueries. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT). 1 HOLD_CURSORS_OVER_COMMIT 2 CLOSE_CURSORS_AT_COMMIT | |
retrieveMessagesFromServerOnGetMessage | boolean | true | JDBC driver property: retrieveMessagesFromServerOnGetMessage. |
retryIntervalForClientReroute | A period of time with second precision | JDBC driver property: retryIntervalForClientReroute. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
retryWithAlternativeSecurityMechanism |
| JDBC driver property: retryWithAlternativeSecurityMechanism. 1 YES 2 NO | |
returnAlias |
| JDBC driver property: returnAlias. 1 1 2 2 | |
securityMechanism |
| JDBC driver property: securityMechanism. Values are: 3 (CLEAR_TEXT_PASSWORD_SECURITY), 4 (USER_ONLY_SECURITY), 7 (ENCRYPTED_PASSWORD_SECURITY), 9 (ENCRYPTED_USER_AND_PASSWORD_SECURITY), 11 (KERBEROS_SECURITY), 12 (ENCRYPTED_USER_AND_DATA_SECURITY), 13 (ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY), 15 (PLUGIN_SECURITY), 16 (ENCRYPTED_USER_ONLY_SECURITY), 18 (TLS_CLIENT_CERTIFICATE_SECURITY). 11 KERBEROS_SECURITY 12 ENCRYPTED_USER_AND_DATA_SECURITY 13 ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY 3 CLEAR_TEXT_PASSWORD_SECURITY 4 USER_ONLY_SECURITY 15 PLUGIN_SECURITY 16 ENCRYPTED_USER_ONLY_SECURITY 7 ENCRYPTED_PASSWORD_SECURITY 18 TLS_CLIENT_CERTIFICATE_SECURITY 9 ENCRYPTED_USER_AND_PASSWORD_SECURITY | |
sendCharInputsUTF8 |
| JDBC driver property: sendCharInputsUTF8. 1 YES 2 NO | |
sendDataAsIs | boolean | JDBC driver property: sendDataAsIs. | |
serverBidiStringType |
| JDBC driver property: serverBidiStringType. 11 BIDI_ST11 4 BIDI_ST4 5 BIDI_ST5 6 BIDI_ST6 7 BIDI_ST7 8 BIDI_ST8 9 BIDI_ST9 10 BIDI_ST10 | |
sessionTimeZone | string | JDBC driver property: sessionTimeZone. | |
sqljCloseStmtsWithOpenResultSet | boolean | JDBC driver property: sqljCloseStmtsWithOpenResultSet. | |
sqljEnableClassLoaderSpecificProfiles | boolean | JDBC driver property: sqljEnableClassLoaderSpecificProfiles. | |
ssid | string | JDBC driver property: ssid. | |
sslCertLocation | string | JDBC driver property: sslCertLocation. | |
SSLCipherSuites | string | JDBC driver property: SSLCipherSuites. | |
sslConnection | boolean | JDBC driver property: sslConnection. | |
sslTrustStoreLocation | string | JDBC driver property: sslTrustStoreLocation. | |
sslTrustStorePassword | Reversably encoded password (string) | JDBC driver property: sslTrustStorePassword. | |
sslTrustStoreType | string | JDBC driver property: sslTrustStoreType. | |
statementConcentrator |
| JDBC driver property: statementConcentrator. 1 STATEMENT_CONCENTRATOR_OFF 2 STATEMENT_CONCENTRATOR_WITH_LITERALS | |
streamBufferSize | int | JDBC driver property: streamBufferSize. | |
stripTrailingZerosForDecimalNumbers |
| JDBC driver property: stripTrailingZerosForDecimalNumbers. 1 YES 2 NO | |
sysSchema | string | JDBC driver property: sysSchema. | |
timeFormat |
| JDBC driver property: timeFormat. 1 ISO 2 USA 3 EUR 4 JIS | |
timerLevelForQueryTimeOut |
| JDBC driver property: timerLevelForQueryTimeOut. 1 QUERYTIMEOUT_STATEMENT_LEVEL 2 QUERYTIMEOUT_CONNECTION_LEVEL -1 QUERYTIMEOUT_DISABLED | |
timestampFormat |
| JDBC driver property: timestampFormat. 1 ISO 5 JDBC | |
timestampOutputType |
| JDBC driver property: timestampOutputType. 1 JDBC_TIMESTAMP 2 JCC_DBTIMESTAMP | |
timestampPrecisionReporting |
| JDBC driver property: timestampPrecisionReporting. 1 TIMESTAMP_JDBC_STANDARD 2 TIMESTAMP_ZERO_PADDING | |
traceDirectory | string | JDBC driver property: traceDirectory. | |
traceFile | string | JDBC driver property: traceFile. | |
traceFileAppend | boolean | JDBC driver property: traceFileAppend. | |
traceFileCount | int | JDBC driver property: traceFileCount. | |
traceFileSize | int | JDBC driver property: traceFileSize. | |
traceLevel | int | 0 | Bitwise combination of the following constant values: TRACE_NONE=0, TRACE_CONNECTION_CALLS=1, TRACE_STATEMENT_CALLS=2, TRACE_RESULT_SET_CALLS=4, TRACE_DRIVER_CONFIGURATION=16, TRACE_CONNECTS=32, TRACE_DRDA_FLOWS=64, TRACE_RESULT_SET_META_DATA=128, TRACE_PARAMETER_META_DATA=256, TRACE_DIAGNOSTICS=512, TRACE_SQLJ=1024, TRACE_META_CALLS=8192, TRACE_DATASOURCE_CALLS=16384, TRACE_LARGE_OBJECT_CALLS=32768, TRACE_SYSTEM_MONITOR=131072, TRACE_TRACEPOINTS=262144, TRACE_ALL=-1. |
traceOption |
| JDBC driver property: traceOption 0 0 1 1 | |
translateForBitData |
| JDBC driver property: translateForBitData. 1 HEX_REPRESENTATION 2 SERVER_ENCODING_REPRESENTATION | |
updateCountForBatch |
| JDBC driver property: updateCountForBatch. 1 NO_UPDATE_COUNT 2 TOTAL_UPDATE_COUNT | |
useCachedCursor | boolean | JDBC driver property: useCachedCursor. | |
useIdentityValLocalForAutoGeneratedKeys | boolean | JDBC driver property: useIdentityValLocalForAutoGeneratedKeys. | |
useJDBC4ColumnNameAndLabelSemantics |
| JDBC driver property: useJDBC4ColumnNameAndLabelSemantics. Values are: 1 (YES) or 2 (NO). 1 YES 2 NO | |
useJDBC41DefinitionForGetColumns |
| JDBC driver property: useJDBC41DefinitionForGetColumns. 1 YES 2 NO | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. | |
useRowsetCursor | boolean | JDBC driver property: useRowsetCursor. | |
useTransactionRedirect | boolean | JDBC driver property: useTransactionRedirect. | |
xaNetworkOptimization | boolean | JDBC driver property: xaNetworkOptimization. | |
xmlFormat |
| JDBC driver property: xmlFormat. 0 XML_FORMAT_TEXTUAL 1 XML_FORMAT_BINARY |
dataSource > properties.db2.i.toolbox
Data source properties for the IBM DB2 for i Toolbox JDBC driver.
Name | Type | Default | Description |
---|---|---|---|
serverName | string | Server where the database is running. | |
databaseName | string | JDBC driver property: databaseName. | |
access |
| all | JDBC driver property: access. all all read call read call read only read only |
behaviorOverride | int | JDBC driver property: behaviorOverride. | |
bidiImplicitReordering | boolean | true | JDBC driver property: bidiImplicitReordering. |
bidiNumericOrdering | boolean | false | JDBC driver property: bidiNumericOrdering. |
bidiStringType | int | JDBC driver property: bidiStringType. | |
bigDecimal | boolean | true | JDBC driver property: bigDecimal. |
blockCriteria |
| 2 | JDBC driver property: blockCriteria. Values are: 0 (no record blocking), 1 (block if FOR FETCH ONLY is specified), 2 (block if FOR UPDATE is specified). 0 0 1 1 2 2 |
blockSize |
| 32 | JDBC driver property: blockSize. 0 0 256 256 16 16 512 512 128 128 8 8 64 64 32 32 |
characterTruncation |
| JDBC driver property: CharacterTruncation. default default warning warning none none | |
concurrentAccessResolution | int Min: 0 Max: 3 | JDBC driver property: concurrentAccessResolution. | |
cursorHold | boolean | false | JDBC driver property: cursorHold. |
cursorSensitivity |
| asensitive | JDBC driver property: cursorSensitivity. Values are: 0 (TYPE_SCROLL_SENSITIVE_STATIC), 1 (TYPE_SCROLL_SENSITIVE_DYNAMIC), 2 (TYPE_SCROLL_ASENSITIVE). asensitive asensitive insensitive insensitive sensitive sensitive |
dataCompression | boolean | true | JDBC driver property: dataCompression. |
dataTruncation | boolean | true | JDBC driver property: dataTruncation. |
dateFormat |
| JDBC driver property: dateFormat. julian julian dmy dmy ymd ymd usa usa eur eur mdy mdy iso iso jis jis | |
dateSeparator |
| JDBC driver property: dateSeparator. \, The comma character (,). ** The space character ( ). - The dash character (-). . The period character (.). /** The forward slash character (/). | |
decfloatRoundingMode |
| JDBC driver property: decfloatRoundingMode. ceiling ceiling half even half even half up half up up up floor floor down down half down half down | |
decimalDataErrors | string | JDBC driver property: decimalDataErrors. | |
decimalSeparator |
| JDBC driver property: decimalSeparator. \, The comma character (,). . The period character (.). | |
describeOption | string | JDBC driver property: describeOption. | |
driver |
| toolbox | JDBC driver property: driver. native native toolbox toolbox |
errors |
| basic | JDBC driver property: errors. basic basic full full |
extendedDynamic | boolean | false | JDBC driver property: extendedDynamic. |
extendedMetaData | boolean | false | JDBC driver property: extendedMetaData. |
fullOpen | boolean | false | JDBC driver property: fullOpen. |
holdInputLocators | boolean | true | JDBC driver property: holdInputLocators. |
holdStatements | boolean | false | JDBC driver property: holdStatements. |
ignoreWarnings | string | JDBC driver property: ignoreWarnings. | |
isolationLevelSwitchingSupport | boolean | false | JDBC driver property: isolationLevelSwitchingSupport. |
keepAlive | boolean | JDBC driver property: keepAlive. | |
lazyClose | boolean | false | JDBC driver property: lazyClose. |
libraries | string | JDBC driver property: libraries. | |
lobThreshold | int Min: 0 Max: 16777216 | 0 | JDBC driver property: lobThreshold. |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
maximumPrecision |
| 31 | JDBC driver property: maximumPrecision. 63 64 31 31 |
maximumBlockedInputRows | int Min: 1 Max: 32000 | JDBC driver property: maximumBlockedInputRows. | |
maximumScale | int Min: 0 Max: 63 | 31 | JDBC driver property: maximumScale. |
metaDataSource | int Min: 0 Max: 1 | 1 | JDBC driver property: metaDataSource. |
minimumDivideScale | int Min: 0 Max: 9 | 0 | JDBC driver property: minimumDivideScale. |
naming |
| sql | JDBC driver property: naming. system system sql sql |
numericRangeError |
| JDBC driver property: numericRangeError. default default warning warning none none | |
package | string | JDBC driver property: package. | |
packageAdd | boolean | true | JDBC driver property: packageAdd. |
packageCCSID |
| 13488 | JDBC driver property: packageCCSID. Values are: 1200 (UCS-2) or 13488 (UTF-16). 1200 1200 (UCS-2) 13488 13488 (UTF-16) |
packageCache | boolean | false | JDBC driver property: packageCache. |
packageCriteria |
| default | JDBC driver property: packageCriteria. default default select select |
packageError |
| warning | JDBC driver property: packageError. exception exception warning warning none none |
packageLibrary | string | QGPL | JDBC driver property: packageLibrary. |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
prefetch | boolean | true | JDBC driver property: prefetch. |
prompt | boolean | false | JDBC driver property: prompt. |
proxyServer | string | JDBC driver property: proxyServer. | |
qaqqiniLibrary | string | JDBC driver property: qaqqiniLibrary. | |
queryOptimizeGoal | int Min: 0 Max: 2 | 0 | JDBC driver property: queryOptimizeGoal. Values are: 1 (*FIRSTIO) or 2 (*ALLIO). |
queryReplaceTruncatedParameter | string | JDBC driver property: queryReplaceTruncatedParameter. | |
queryTimeoutMechanism |
| JDBC driver property: queryTimeoutMechanism. cancel cancel qqrytimlmt qqrytimlmt | |
queryStorageLimit | int Min: -1 | Query storage limit | |
receiveBufferSize | int Min: 1 | JDBC driver property: receiveBufferSize. | |
remarks |
| system | JDBC driver property: remarks. system system sql sql |
rollbackCursorHold | boolean | false | JDBC driver property: rollbackCursorHold. |
savePasswordWhenSerialized | boolean | false | JDBC driver property: savePasswordWhenSerialized. |
secondaryUrl | string | JDBC driver property: secondaryUrl. | |
secure | boolean | false | JDBC driver property: secure. |
secureCurrentUser | boolean | JDBC driver property: secureCurrentUser. | |
sendBufferSize | int Min: 1 | JDBC driver property: sendBufferSize. | |
serverTraceCategories | int | 0 | JDBC driver property: serverTraceCategories. |
serverTrace | int | JDBC driver property: serverTrace. | |
soLinger | A period of time with second precision | JDBC driver property: soLinger. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
soTimeout | A period of time with millisecond precision | JDBC driver property: soTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), seconds (s), or milliseconds (ms). For example, specify 500 milliseconds as 500ms. You can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds. | |
sort |
| hex | JDBC driver property: sort. hex hex language language table table |
sortLanguage | string | JDBC driver property: sortLanguage. | |
sortTable | string | JDBC driver property: sortTable. | |
sortWeight |
| JDBC driver property: sortWeight. shared shared unqiue unique | |
tcpNoDelay | boolean | JDBC driver property: tcpNoDelay. | |
threadUsed | boolean | true | JDBC driver property: threadUsed. |
timeFormat |
| JDBC driver property: timeFormat. usa usa eur eur iso iso jis jis hms hms | |
timeSeparator |
| JDBC driver property: timeSeparator. \, The comma character (,). ** The space character ( ). : The colon character (:). .** The period character (.). | |
timestampFormat |
| JDBC driver property: timestampFormat. iso iso ibmsql ibmsql | |
toolboxTrace |
| JDBC driver property: toolboxTrace. all all proxy proxy datastream datastream pcml pcml warning warning information information jdbc jdbc none none diagnostic diagnostic thread thread error error conversion conversion | |
trace | boolean | JDBC driver property: trace. | |
translateBinary | boolean | false | JDBC driver property: translateBinary. |
translateBoolean | boolean | true | JDBC driver property: translateBoolean. |
translateHex |
| character | JDBC driver property: translateHex. character character binary binary |
trueAutoCommit | boolean | false | JDBC driver property: trueAutoCommit. |
useBlockUpdate | boolean | JDBC driver property: useBlockUpdate. | |
useDrdaMetadataVersion | boolean | JDBC driver property: useDrdaMetadataVersion. | |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. | |
variableFieldCompression |
| JDBC driver property: variableFieldCompression. all all true true false false insert insert | |
xaLooselyCoupledSupport | int Min: 0 Max: 1 | 0 | JDBC driver property: xaLooselyCoupledSupport. |
dataSource > properties.sybase
Data source properties for Sybase JDBC driver.
Name | Type | Default | Description |
---|---|---|---|
databaseName | string | JDBC driver property: databaseName. | |
serverName | string | localhost | Server where the database is running. |
portNumber | int | 5000 | Port on which to obtain database connections. |
connectionProperties | string | SELECT_OPENS_CURSOR=true | JDBC driver property: connectionProperties. |
loginTimeout | A period of time with second precision | JDBC driver property: loginTimeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. You can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. | |
networkProtocol |
| JDBC driver property: networkProtocol. socket socket SSL SSL | |
password | Reversably encoded password (string) | It is recommended to use a container managed authentication alias instead of configuring this property. | |
resourceManagerName | string | JDBC driver property: resourceManagerName. | |
SERVER_INITIATED_TRANSACTIONS |
| false | JDBC driver property: SERVER_INITIATED_TRANSACTIONS. true true false false |
user | string | It is recommended to use a container managed authentication alias instead of configuring this property. | |
version | int | JDBC driver property: version. |
dataSource > containerAuthData
Default authentication data for container managed authentication that applies when bindings do not specify an authentication-alias for a resource reference with res-auth=CONTAINER. If updated while the server is running, the change is applied with new connection requests; in-use connections are not impacted.
Name | Type | Default | Description |
---|---|---|---|
user | string | Name of the user to use when connecting to the EIS. | |
password | Reversably encoded password (string) | Password of the user to use when connecting to the EIS. The value can be stored in clear text or encoded form. It is recommended that you encode the password. To do so, use the securityUtility tool with the encode option. |
dataSource > jaasLoginContextEntry
JAAS login context entry for authentication. If updated while the server is running, the update is applied with new connection requests; in-use connections are not impacted.
Name | Type | Default | Description |
---|---|---|---|
name | string | Name of a JAAS configuration entry. | |
loginModuleRef | List of references to top level jaasLoginModule elements (comma-separated string). | hashtable,userNameAndPassword,certificate,token | A reference to the ID of a JAAS login module. |
SQL command to execute once on each new connection that is established to the database. The SQL statement applies only to newly created connections, not to existing connections that are reused from the connection pool. If updated while the server is running, existing connections are destroyed.
Authentication data for transaction recovery.
Name | Type | Default | Description |
---|---|---|---|
user | string | Name of the user to use when connecting to the EIS. | |
password | Reversably encoded password (string) | Password of the user to use when connecting to the EIS. The value can be stored in clear text or encoded form. It is recommended that you encode the password. To do so, use the securityUtility tool with the encode option. |