Configures the Batch persistence store.
Name | Type | Default | Description |
---|---|---|---|
jobStoreRef | A reference to top level databaseStore element (string). | defaultDatabaseStore | Persistent store for batch data. |
Persistent store for batch data.
Name | Type | Default | Description |
---|---|---|---|
createTables | boolean | true | When set to true, database tables are created. |
dataSourceRef | A reference to top level dataSource element (string). | DefaultDataSource | Data source that connects to the persistent store. |
keyGenerationStrategy |
| AUTO | The preferred strategy for generating unique primary keys. If the selected strategy is not supported for the database, a different strategy might be used. IDENTITY Use a database identity column to generate unique primary keys. TABLE Use a database table to generate unique primary keys. AUTO Automatically select the strategy to generate unique primary keys. SEQUENCE Use a database sequence to generate unique primary keys. |
tablePrefix | string | WLP | Name prefix for tables, sequences, and other database artifacts. |
authDataRef | A reference to top level authData element (string). | Authentication data for task scheduling, queries, and execution. | |
schema | string | Schema name with read and write access to the database tables. |
Data source that connects to the persistent store.
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. |
jobStore > dataSource > jdbcDriver
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. |
jobStore > 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. |
jobStore > 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. |
jobStore > 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 |
jobStore > 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 |
jobStore > 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. |
jobStore > 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. |
jobStore > 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. |
jobStore > 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. |
jobStore > dataSource > properties
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. |
jobStore > 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. |
jobStore > 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. |
jobStore > 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. |
jobStore > 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 |
jobStore > 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. |
jobStore > 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 |
jobStore > 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. |
jobStore > 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. |
jobStore > 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. |
jobStore > 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. |
jobStore > dataSource > onConnect
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.
jobStore > dataSource > recoveryAuthData
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. |
Authentication data for task scheduling, queries, and execution.
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. |