Batch Persistence (batchPersistence)

jobStoreRef

A reference to top level databaseStore element (string).

defaultDatabaseStore

Persistent store for batch data.

authDataRef

A reference to top level authData element (string).

Authentication data for task scheduling, queries, and execution.

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.
AUTO
Automatically select the strategy to generate unique primary keys.
IDENTITY
Use a database identity column to generate unique primary keys.
SEQUENCE
Use a database sequence to generate unique primary keys.
TABLE
Use a database table to generate unique primary keys.

schema

string

Schema name with read and write access to the database tables.

tablePrefix

string

WLP

Name prefix for tables, sequences, and other database artifacts.

krb5Principal

string

The name of the Kerberos principal name or Kerberos service name to be used.

krb5TicketCache

Path to a file

The file location where Kerberos credentials for the Kerberos principal name or service name will be stored. Also known as the Kerberos credential cache (ccache)

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.

user

string

Name of the user to use when connecting to the EIS.

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.

connectionSharing

MatchOriginalRequest

Specifies how connections are matched for sharing.
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.
MatchOriginalRequest
When sharing connections, match based on the original connection request.

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.

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_NONE
Indicates that the JDBC driver does not support transactions.
TRANSACTION_READ_COMMITTED
Dirty reads are prevented; non-repeatable reads and phantom reads can occur.
TRANSACTION_READ_UNCOMMITTED
Dirty reads, non-repeatable reads and phantom reads can occur.
TRANSACTION_REPEATABLE_READ
Dirty reads and non-repeatable reads are prevented; phantom reads can occur.
TRANSACTION_SERIALIZABLE
Dirty reads, non-repeatable reads and phantom reads are prevented.
TRANSACTION_SNAPSHOT
Snapshot isolation for Microsoft SQL Server JDBC Driver and DataDirect Connect for JDBC driver.

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.

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.

jndiName

string

JNDI name for a data source. If updated while the server is running, existing connections are destroyed.

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. To set this option, complete the following prerequisites: Review either the application code or an SQL trace that you gather from the database or database driver for all unique prepared statements. Ensure that the cache size is larger than the number of statements.

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.

type

Type of data source. If updated while the server is running, existing connections are destroyed.

Advanced Properties

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.
commit
Clean up the connection by committing.
rollback
Clean up the connection by rolling back.

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.

onConnect

string

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.

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.

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.

syncQueryTimeoutWithTransactionTimeout

boolean

false

Use the time remaining (if any) in a JTA transaction as the default query timeout for SQL statements.

validationTimeout

A period of time with second precision

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. The full amount of the validation timeout applies to each connection that is validated, which is done via the Connection.isValid(timeout) JDBC API operation. 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.

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, meaning infinite wait. A value of 0 is immediate, meaning no 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.

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. The optimal setting depends on the application characteristics. For an application in which every thread obtains a connection to the database, you might start with a 1:1 mapping to the `coreThreads` attribute.

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.
EntirePool
When a stale connection is detected, all connections in the pool are marked stale, and when no longer in use, are closed.
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.

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.

Advanced Properties

autoCloseConnections

boolean

true

Attempts to clean up after applications that leave connections open after the end of a servlet request, enterprise bean instance, managed executor task, contextual task, or managed completion stage. When an unsharable connection is obtained within one of these application artifacts and remains open when it ends, the container attempts to close the connection handle. The container may also close sharable connections that do not support DissociatableManagedConnection. Applications should always follow the programming model defined by the specification and close connections at the appropriate times rather than relying on the container, even when this option is enabled.

enableContainerAuthForDirectLookups

boolean

false

If set to true, connections use container authentication. If set to false, connections use application authentication.

enableSharingForDirectLookups

boolean

true

If set to true, connections are shared. If set to false, connections are unshared.

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. This setting can provide a performance improvement on large multi-core (8+) machines by reserving the specified number of database connections for each thread. For best performance, if you have n applications threads, set the maximum pool connections to at least n times the value of the numConnectionsPerThreadLocal attribute. Use the same credentials for all connection requests. For example, if you use 20 application threads, set the maximum pool connections to 20 or more. If you set the value of numConnectionPerThreadLocal attribute as 2 and you have 20 application threads, set the maximum pool connection to 40 or more. If setting numConnectionsPerThreadLocal does not improve performance due to application connection usage patterns that do not benefit from using numConnectionsPerThreadLocal, remove the attribute from configuration or set the value to 0.

krb5Principal

string

The name of the Kerberos principal name or Kerberos service name to be used.

krb5TicketCache

Path to a file

The file location where Kerberos credentials for the Kerberos principal name or service name will be stored. Also known as the Kerberos credential cache (ccache)

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.

user

string

Name of the user to use when connecting to the EIS.

as

string
Required

Identifies the error condition that the SQL error code or SQL state represents. Allowed values are: None, StaleConnection, StaleStatement, Unsupported. None removes the identification of the exception. StaleConnection causes connections to be evicted from the connection pool per the purge policy. StaleStatement causes statements to be evicted from the statement cache. Unsupported indicates an operation that is not supported by the JDBC driver.

errorCode

int

An error code specific to the backend database. Normally, this is the actual error code that is returned by the underlying database.

id

string

A unique configuration ID.

sqlState

string

A string that follows either the XOPEN SQL state conventions or the SQL:2003 conventions.

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.

name

string
Required

Name of a JAAS configuration entry.

libraryRef

A reference to top level library element (string).

Identifies JDBC driver JARs and native files.

Advanced Properties

javax.sql.ConnectionPoolDataSource

string

JDBC driver implementation of javax.sql.ConnectionPoolDataSource.

javax.sql.DataSource

string

JDBC driver implementation of javax.sql.DataSource.

javax.sql.XADataSource

string

JDBC driver implementation of javax.sql.XADataSource.

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.

description

string

Description of shared library for administrators

filesetRef

List of references to top level fileset elements (comma-separated string).

Id of referenced Fileset

name

string

Name of shared library for administrators

id

string

A unique configuration ID.

name

Path to a file
Required

Fully qualified filename

caseSensitive

boolean

true

Boolean to indicate whether or not the search should be case sensitive (default: true).

dir

Path to a directory

${server.config.dir}

The base directory to search for files.

excludes

string

The comma or space separated list of file name patterns to exclude from the search results, by default no files are excluded.

id

string

A unique configuration ID.

includes

string

*

The comma or space separated list of file name patterns to include in the search results (default: *).

scanInterval

A period of time with millisecond precision

0

The scanning interval to determine whether files are added or removed from the fileset. The individual files are not scanned. The suffix for the interval of time is h-hour, m-minute, s-second, and ms-millisecond, for example, 2ms or 5s. The scanning interval is disabled by default and is disabled manually by setting the scan interval, scanInterval, to 0. 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.

dir

Path to a directory
Required

Directory or folder to be included in the library classpath for locating resource files

id

string

A unique configuration ID.

URL

string

URL for connecting to the database.

databaseName

string

JDBC driver property: databaseName.

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.

serverName

string

Server where the database is running.

user

string

It is recommended to use a container managed authentication alias instead of configuring this property.

databaseName

string

JDBC driver property: databaseName.

portNumber

int

Port on which to obtain database connections.

serverName

string

localhost

Server where the database is running.

Advanced Properties

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

XATransactionGroup

string

JDBC driver property: XATransactionGroup.

XMLDescribeType

JDBC driver property: XMLDescribeType.

accountingInfo

string

JDBC driver property: accountingInfo.

alwaysReportTriggerResults

boolean

JDBC driver property: alwaysReportTriggerResults.

applicationName

string

JDBC driver property: applicationName.

authenticationMethod

JDBC driver property: authenticationMethod.

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.

convertNull

int

JDBC driver property: convertNull.

dateTimeInputParameterType

JDBC driver property: dateTimeInputParameterType.

dateTimeOutputParameterType

JDBC driver property: dateTimeOutputParameterType.

describeInputParameters

JDBC driver property: describeInputParameters.

describeOutputParameters

JDBC driver property: describeOutputParameters.

enableBulkLoad

boolean

JDBC driver property: enableBulkLoad.

enableCancelTimeout

boolean

JDBC driver property: enableCancelTimeout.

encryptionMethod

JDBC driver property: encryptionMethod.

hostNameInCertificate

string

JDBC driver property: hostNameInCertificate.

initializationString

string

JDBC driver property: initializationString.

insensitiveResultSetBufferSize

int

JDBC driver property: insensitiveResultSetBufferSize.

javaDoubleToString

boolean

JDBC driver property: javaDoubleToString.

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.

snapshotSerializable

boolean

JDBC driver property: snapshotSerializable.

spyAttributes

string

JDBC driver property: spyAttributes.

stringInputParameterType

varchar

JDBC driver property: stringInputParameterType.

stringOutputParameterType

varchar

JDBC driver property: stringOutputParameterType.

suppressConnectionWarnings

boolean

JDBC driver property: suppressConnectionWarnings.

transactionMode

JDBC driver property: transactionMode.

truncateFractionalSeconds

boolean

JDBC driver property: truncateFractionalSeconds.

trustStore

string

JDBC driver property: trustStore.

trustStorePassword

Reversably encoded password (string)

JDBC driver property: trustStorePassword.

useServerSideUpdatableCursors

boolean

JDBC driver property: useServerSideUpdatableCursors.

user

string

It is recommended to use a container managed authentication alias instead of configuring this property.

validateServerCertificate

boolean

JDBC driver property: validateServerCertificate.

Failover Properties

alternateServers

string

JDBC driver property: alternateServers.

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.

failoverGranularity

JDBC driver property: failoverGranularity.

failoverMode

JDBC driver property: failoverMode.

failoverPreconnect

boolean

JDBC driver property: failoverPreconnect.

loadBalancing

boolean

JDBC driver property: loadBalancing.

databaseName

string

*LOCAL

JDBC driver property: databaseName.

Advanced Properties

access

all

JDBC driver property: access.

autoCommit

boolean

true

JDBC driver property: autoCommit.

batchStyle

2.0

JDBC driver property: batchStyle.

behaviorOverride

int

JDBC driver property: behaviorOverride.

blockSize

32

JDBC driver property: blockSize.

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).

dataTruncation

string

true

JDBC driver property: dataTruncation.

dateFormat

JDBC driver property: dateFormat.

dateSeparator

JDBC driver property: dateSeparator.
-
The dash character (-).
.
The period character (.).
/
The forward slash character (/).
\,
The comma character (,).
b
The character b

decimalSeparator

JDBC driver property: decimalSeparator.
.
The period character (.).
\,
The comma 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.

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.

timeSeparator

JDBC driver property: timeSeparator.
.
The period character (.).
:
The colon character (:).
\,
The comma character (,).
b
The character b

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.

useBlockInsert

boolean

false

JDBC driver property: useBlockInsert.

user

string

It is recommended to use a container managed authentication alias instead of configuring this property.

databaseName

string

JDBC driver property: databaseName.

serverName

string
Required

Server where the database is running.

Advanced Properties

access

all

JDBC driver property: access.

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).

blockSize

32

JDBC driver property: blockSize.

characterTruncation

JDBC driver property: CharacterTruncation.

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).

dataCompression

boolean

true

JDBC driver property: dataCompression.

dataTruncation

boolean

true

JDBC driver property: dataTruncation.

dateFormat

JDBC driver property: dateFormat.

dateSeparator

* * - * . * / * \,

JDBC driver property: dateSeparator.
* *
The space character ( ).
-
The dash character (-).
.
The period character (.).
/
The forward slash character (/).
\,
The comma character (,).

decfloatRoundingMode

JDBC driver property: decfloatRoundingMode.

decimalDataErrors

string

JDBC driver property: decimalDataErrors.

decimalSeparator

JDBC driver property: decimalSeparator.
.
The period character (.).
\,
The comma character (,).

describeOption

string

JDBC driver property: describeOption.

driver

toolbox

JDBC driver property: driver.

errors

basic

JDBC driver property: errors.

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.

maximumBlockedInputRows

int
Min: 1
Max: 32000

JDBC driver property: maximumBlockedInputRows.

maximumPrecision

31

JDBC driver property: maximumPrecision.
63
64

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.

numericRangeError

JDBC driver property: numericRangeError.

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.

packageError

warning

JDBC driver property: packageError.

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.

queryStorageLimit

int
Min: -1

Query storage limit

queryTimeoutMechanism

JDBC driver property: queryTimeoutMechanism.

receiveBufferSize

int
Min: 1

JDBC driver property: receiveBufferSize.

remarks

system

JDBC driver property: remarks.

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.

serverTrace

int

JDBC driver property: serverTrace.

serverTraceCategories

int

0

JDBC driver property: serverTraceCategories.

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.

sortLanguage

string

JDBC driver property: sortLanguage.

sortTable

string

JDBC driver property: sortTable.

sortWeight

JDBC driver property: sortWeight.
unqiue
unique

tcpNoDelay

boolean

JDBC driver property: tcpNoDelay.

threadUsed

boolean

true

JDBC driver property: threadUsed.

timeFormat

JDBC driver property: timeFormat.

timeSeparator

* * . * : * \,

JDBC driver property: timeSeparator.
* *
The space character ( ).
.
The period character (.).
:
The colon character (:).
\,
The comma character (,).

timestampFormat

JDBC driver property: timestampFormat.

toolboxTrace

JDBC driver property: toolboxTrace.

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.

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.

xaLooselyCoupledSupport

int
Min: 0
Max: 1

0

JDBC driver property: xaLooselyCoupledSupport.

databaseName

string

JDBC driver property: databaseName. This property overrides the databaseName specified in the URL if one was configured.

driverType

4

JDBC driver property: driverType.
2
Type 2 JDBC driver.
4
Type 4 JDBC driver.

portNumber

int

50000

JDBC driver property: portNumber. This property overrides the portNumber specified in the URL if one was configured.

serverName

string

JDBC driver property: serverName. This property overrides the serverName specified in the URL if one was configured.

Advanced Properties

SSLCipherSuites

string

JDBC driver property: SSLCipherSuites.

accessToken

Reversably encoded password (string)

JDBC driver property: accessToken.

accountingInterval

string

JDBC driver property: accountingInterval.

activateDatabase

int

JDBC driver property: activateDatabase.

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.

apiKey

Reversably encoded password (string)

JDBC driver property: apiKey.

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.

clientAccountingInformation

string

JDBC driver property: clientAccountingInformation.

clientApplcompat

string

JDBC driver property: clientApplcompat.

clientApplicationInformation

string

JDBC driver property: clientApplicationInformation.

clientBidiStringType

JDBC driver property: clientBidiStringType.
4
BIDI_ST4
5
BIDI_ST5
6
BIDI_ST6
7
BIDI_ST7
8
BIDI_ST8
9
BIDI_ST9
10
BIDI_ST10
11
BIDI_ST11

clientDebugInfo

string
Max: 254

JDBC driver property: clientDebugInfo.

clientProgramId

string
Max: 80

JDBC driver property: clientProgramId.

clientProgramName

string
Max: 12

JDBC driver property: clientProgramName.

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

connectNode

int
Min: 0
Max: 999

JDBC driver property: connectNode.

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.

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.

currentPackagePath

string

JDBC driver property: currentPackagePath.

currentPackageSet

string

JDBC driver property: currentPackageSet.

currentQueryOptimization

JDBC driver property: currentQueryOptimization.

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.

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.

maxRowsetSize

int

JDBC driver property: maxRowsetSize.

maxTransportObjects

int

JDBC driver property: maxTransportObjects.

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: 10485760

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.

retryWithAlternativeSecurityMechanism

JDBC driver property: retryWithAlternativeSecurityMechanism.
1
YES
2
NO

returnAlias

JDBC driver property: returnAlias.

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).
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

sendCharInputsUTF8

JDBC driver property: sendCharInputsUTF8.
1
YES
2
NO

sendDataAsIs

boolean

JDBC driver property: sendDataAsIs.

serverBidiStringType

JDBC driver property: serverBidiStringType.
4
BIDI_ST4
5
BIDI_ST5
6
BIDI_ST6
7
BIDI_ST7
8
BIDI_ST8
9
BIDI_ST9
10
BIDI_ST10
11
BIDI_ST11

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.

sslConnection

boolean

JDBC driver property: sslConnection.

sslKeyStoreLocation

string

JDBC driver property: sslKeyStoreLocation.

sslKeyStorePassword

Reversably encoded password (string)

JDBC driver property: sslKeyStorePassword.

sslKeyStoreType

string

JDBC driver property: sslKeyStoreType.

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_DISABLED
1
QUERYTIMEOUT_STATEMENT_LEVEL
2
QUERYTIMEOUT_CONNECTION_LEVEL

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

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.

useJDBC41DefinitionForGetColumns

JDBC driver property: useJDBC41DefinitionForGetColumns.
1
YES
2
NO

useJDBC4ColumnNameAndLabelSemantics

JDBC driver property: useJDBC4ColumnNameAndLabelSemantics. Values are: 1 (YES) or 2 (NO).
1
YES
2
NO

useRowsetCursor

boolean

JDBC driver property: useRowsetCursor.

useTransactionRedirect

boolean

JDBC driver property: useTransactionRedirect.

user

string

It is recommended to use a container managed authentication alias instead of configuring this property.

xaNetworkOptimization

boolean

JDBC driver property: xaNetworkOptimization.

xmlFormat

JDBC driver property: xmlFormat.
0
XML_FORMAT_TEXTUAL
1
XML_FORMAT_BINARY

Automatic Client Reroute Properties

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.

clientRerouteAlternatePortNumber

string

JDBC driver property: clientRerouteAlternatePortNumber.

clientRerouteAlternateServerName

string

JDBC driver property: clientRerouteAlternateServerName.

maxRetriesForClientReroute

int

JDBC driver property: maxRetriesForClientReroute.

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.

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.

createDatabase

JDBC driver property: createDatabase.
create
When the first connection is established, automatically create the database if it doesn't exist.
false
Do not automatically create the database.

databaseName

string