Java Persistence API 2.0
This feature enables support for applications that use application-managed and container-managed JPA written to the Java Persistence API 2.0 specification. The support is built on top of Apache OpenJPA with extensions to support the container-managed programming model.
Enable this feature
To enable the Java Persistence API 2.0 feature, add the following element declaration inside the featureManager element in the server.xml file:
<feature>jpa-2.0</feature>
Developing a feature that depends on this feature
If we are developing a feature that depends on the Java Persistence API 2.0 feature, include the following item in the Subsystem-Content header in the feature manifest file for the new feature:
com.ibm.websphere.appserver.jpa-2.0; type="osgi.subsystem.feature"
Features that this feature enables
- Bean Validation 1.0
- Java Database Connectivity 4.0
- Java Naming and Directory Interface
- Java Servlets 3.0
Features that enable this feature
API packages provided by this feature
- javax.persistence
- javax.persistence.criteria
- javax.persistence.metamodel
- javax.persistence.spi
- org.apache.openjpa.abstractstore
- org.apache.openjpa.ant
- org.apache.openjpa.audit
- org.apache.openjpa.conf
- org.apache.openjpa.datacache
- org.apache.openjpa.ee
- org.apache.openjpa.enhance
- org.apache.openjpa.event
- org.apache.openjpa.instrumentation
- org.apache.openjpa.instrumentation.jmx
- org.apache.openjpa.jdbc.ant
- org.apache.openjpa.jdbc.conf
- org.apache.openjpa.jdbc.identifier
- org.apache.openjpa.jdbc.kernel
- org.apache.openjpa.jdbc.kernel.exps
- org.apache.openjpa.jdbc.meta
- org.apache.openjpa.jdbc.meta.strats
- org.apache.openjpa.jdbc.schema
- org.apache.openjpa.jdbc.sql
- org.apache.openjpa.kernel
- org.apache.openjpa.kernel.exps
- org.apache.openjpa.kernel.jpql
- org.apache.openjpa.lib.ant
- org.apache.openjpa.lib.conf
- org.apache.openjpa.lib.encryption
- org.apache.openjpa.lib.graph
- org.apache.openjpa.lib.identifier
- org.apache.openjpa.lib.instrumentation
- org.apache.openjpa.lib.jdbc
- org.apache.openjpa.lib.log
- org.apache.openjpa.lib.meta
- org.apache.openjpa.lib.rop
- org.apache.openjpa.lib.util
- org.apache.openjpa.lib.util.concurrent
- org.apache.openjpa.lib.util.svn
- org.apache.openjpa.lib.xml
- org.apache.openjpa.meta
- org.apache.openjpa.persistence
- org.apache.openjpa.persistence.criteria
- org.apache.openjpa.persistence.jdbc
- org.apache.openjpa.persistence.meta
- org.apache.openjpa.persistence.osgi
- org.apache.openjpa.persistence.query
- org.apache.openjpa.persistence.util
- org.apache.openjpa.persistence.validation
- org.apache.openjpa.slice
- org.apache.openjpa.slice.jdbc
- org.apache.openjpa.util
- org.apache.openjpa.validation
- org.apache.openjpa.xmlstore
Feature configuration elements
We can use the following elements in the server.xml file to configure the Java Persistence API 2.0 feature:
- classloading
- jpa
- library
- transaction
- dataSource
- connectionManager
- containerAuthData
- jdbcDriver
- properties
- properties.datadirect.sqlserver
- properties.db2.i.native
- properties.db2.i.toolbox
- properties.db2.jcc
- properties.derby.client
- properties.derby.embedded
- properties.informix
- properties.informix.jcc
- properties.microsoft.sqlserver
- properties.oracle
- properties.sybase
- recoveryAuthData
- classloading
- Global classloading
Attribute name Data type Default value Description useJarUrls boolean false Whether to use jar: or wsjar: URLs for referencing files in archives
- jpa
- Configuration properties for the Java Persistence API container.
Attribute name Data type Default value Description defaultJtaDataSourceJndiName string Default Java? Transaction API (JTA) data source JNDI name to be used by applications running in this server. By default, data sources are JTA. Only data sources that are transactional are allowed in this field. defaultNonJtaDataSourceJndiName string Default non-transactional data source JNDI name to be used by applications running in this server. Only data sources that have been marked as non-transactional are allowed in this field. defaultPersistenceProvider string Default persistence provider class name. If this property is not specified, the default provider is dependent on which JPA feature is enabled. entityManagerPoolCapacity int -1 EntityManager pool capacity per PersistenceContext reference. The minimum is 0 and the maximum is 500. ignoreDataSourceErrors boolean If true, errors that occur while attempting to lookup a data source specified by the <jta-data-source> or <non-jta-data-source> elements in the persistence.xml file are reported and ignored, which allows the persistence provider to determine a default data source. If false, the errors are propagated to the persistence provider so the errors can be diagnosed more are, but misconfigured applications might not work. By default, this property is true if JPA 2.0 is enabled and false otherwise.
- jpa > excludedApplication
Description: An application to be excluded from JPA processing.
Required: false
Data type: string
- library
- Shared Library
Attribute name Data type Default value Description apiTypeVisibility string spec,ibm-api,api The types of API package this library's class loader will be able to see, as a comma-separated list of any combination of the following: spec, ibm-api, api, 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 id string A unique configuration ID. name string Name of shared library for administrators
- library > file
Description: Id of referenced File
Required: false
Data type:
Attribute name Data type Default value Description name Path to a file Fully qualified filename
- library > fileset
Description: Id of referenced Fileset
Required: false
Data type:
Attribute name Data type Default value Description 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. 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 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. We can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds.
- library > folder
Description: Id of referenced folder
Required: false
Data type:
Attribute name Data type Default value Description dir Path to a directory Directory or folder to be included in the library classpath for locating resource files
- transaction
- Configuration properties for the Transaction Manager service
Attribute name Data type Default value Description acceptHeuristicHazard boolean true Whether all applications on this server accept the possibility of a heuristic hazard occurring in a two-phase transaction containing a one-phase resource. clientInactivityTimeout A period of time with second precision 60s Maximum duration between transactional requests from a remote client. Any period of client inactivity that exceeds this timeout results in the transaction being rolled back in this application server. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. dataSourceRef A reference to top level dataSource element (string). This is an optional property. By default the transaction service stores its recovery logs in a file. As an alternative it is possible to store the logs in an RDBMS. This is achieved by setting this property which defines a non-transactional data source where the transaction logs will be stored. defaultMaxShutdownDelay A period of time with second precision 2s Default maximum shutdown delay. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. enableLoggingForHeuristicReporting boolean false Whether the application server logs about-to-commit-one-phase-resource events from transactions that involve both a one-phase commit resource and two-phase commit resources. heuristicRetryInterval A period of time with second precision 60s Amount of time that the application server waits before retrying a completion signal, such as commit or rollback, after a transient exception from a resource manager or remote partner. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. heuristicRetryWait int 5 The number of times that the application server retries a completion signal, such as commit or rollback. Retries occur after a transient exception from a resource manager or remote partner. lpsHeuristicCompletion
- COMMIT
- MANUAL
- ROLLBACK
ROLLBACK Direction used to complete a transaction that has a heuristic outcome; either the application server commits or rolls back the transaction, or depends on manual completion by the administrator. Allowed values are: COMMIT, ROLLBACK and MANUAL
- COMMIT
- Commit
- MANUAL
- Manual
- ROLLBACK
- Rollback
propogatedOrBMTTranLifetimeTimeout A period of time with second precision 0 Upper limit of the transaction timeout for transactions that run in this server. Should be greater than or equal to the value specified for the total transaction timeout. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. recoverOnStartup boolean false Whether the server should begin transaction recovery at server startup. timeoutGracePeriodEnabled boolean false Whether there is a delay between a transaction timeout and the abnormal ending of the servant region that was running the transaction. totalTranLifetimeTimeout A period of time with second precision 120s Default maximum time allowed for transactions started on this server to complete. Any such transactions that do not complete before this timeout occurs are rolled back. Specify a positive integer followed by a unit of time, which can be hours (h), minutes (m), or seconds (s). For example, specify 30 seconds as 30s. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. transactionLogDBTableSuffix string When recovery logs are stored in an RDBMS table, this property allows the table name to be post-pended with a string to make it unique for this Server. transactionLogDirectory string ${server.output.dir}/tranlog/ A directory for this server where the transaction service stores log files for recovery. transactionLogSize int 1024 Size of transaction log files in Kilobytes. waitForRecovery boolean false Whether the server should wait for transaction recovery to complete before accepting new transactional work.
- transaction > dataSource
Description: This is an optional property. By default the transaction service stores its recovery logs in a file. As an alternative it is possible to store the logs in an RDBMS. This is achieved by setting this property which defines a non-transactional data source where the transaction logs will be stored.
Required: false
Data type:
Attribute name Data type Default value Description 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
- commit
- rollback
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.
connectionManagerRef A reference to top level connectionManager element (string). Connection manager for a data source. 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.
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. isolationLevel
- TRANSACTION_REPEATABLE_READ
- TRANSACTION_READ_COMMITTED
- TRANSACTION_SERIALIZABLE
- TRANSACTION_READ_UNCOMMITTED
- TRANSACTION_SNAPSHOT
Default transaction isolation level.
- TRANSACTION_REPEATABLE_READ
- Dirty reads and non-repeatable reads are prevented; 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_READ_UNCOMMITTED
- Dirty reads, non-repeatable reads and phantom reads can occur.
- TRANSACTION_SNAPSHOT
- Snapshot isolation for Microsoft SQL Server JDBC Driver and DataDirect Connect for JDBC driver.
jdbcDriverRef A reference to top level jdbcDriver element (string). JDBC driver for a data source. jndiName string JNDI name for a data source. 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. We 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. statementCacheSize int Minimum: 0
10 Maximum number of cached statements per connection. 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. syncQueryTimeoutWithTransactionTimeout boolean false Use the time remaining (if any) in a JTA transaction as the default query timeout for SQL statements. transactional boolean true Enable participation in transactions managed by the application server. type
- javax.sql.DataSource
- javax.sql.XADataSource
- javax.sql.ConnectionPoolDataSource
Type of data source.
- javax.sql.DataSource
- javax.sql.DataSource
- javax.sql.XADataSource
- javax.sql.XADataSource
- javax.sql.ConnectionPoolDataSource
- javax.sql.ConnectionPoolDataSource
- transaction > dataSource > connectionManager
Description: Connection manager for a data source.
Required: false
Data type:
Attribute name Data type Default value Description agedTimeout A period of time with second precision -1 Amount of time before a physical connection can be discarded by pool maintenance. 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. We 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. maxConnectionsPerThread int Minimum: 0
Limits the number of open connections on each thread. maxIdleTime A period of time with second precision 30m Amount of time after which an unused or idle connection 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. maxPoolSize int Minimum: 0
50 Maximum number of physical connections for a pool. A value of 0 means unlimited. minPoolSize int Minimum: 0
Minimum number of physical connections to maintain in the pool. The pool is not pre-populated. Aged timeout can override the minimum. numConnectionsPerThreadLocal int Minimum: 0
Caches the specified number of connections for each thread. purgePolicy
- ValidateAllConnections
- FailingConnectionOnly
- EntirePool
EntirePool Specifies which connections to destroy when a stale connection is detected in a pool.
- ValidateAllConnections
- When a stale connection is detected, connections are tested and those found to be bad are closed.
- FailingConnectionOnly
- When a stale connection is detected, only the connection which was found to be bad is 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds.
- transaction > dataSource > containerAuthData
Description: 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.
Required: false
Data type:
Attribute name Data type Default value Description password Reversably encoded password (string) Password of the user to use when connecting to the EIS. 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.
- transaction > dataSource > jdbcDriver
Description: JDBC driver for a data source.
Required: false
Data type:
Attribute name Data type Default value Description 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. libraryRef A reference to top level library element (string). Identifies JDBC driver JARs and native files.
- transaction > dataSource > jdbcDriver > library
Description: Identifies JDBC driver JARs and native files.
Required: false
Data type:
Attribute name Data type Default value Description apiTypeVisibility string spec,ibm-api,api The types of API package this library's class loader will be able to see, as a comma-separated list of any combination of the following: spec, ibm-api, api, 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
- transaction > dataSource > jdbcDriver > library > file
Description: Id of referenced File
Required: false
Data type:
Attribute name Data type Default value Description name Path to a file Fully qualified filename
- transaction > dataSource > jdbcDriver > library > fileset
Description: Id of referenced Fileset
Required: false
Data type:
Attribute name Data type Default value Description 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. 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 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. We can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds.
- transaction > dataSource > jdbcDriver > library > folder
Description: Id of referenced folder
Required: false
Data type:
Attribute name Data type Default value Description dir Path to a directory Directory or folder to be included in the library classpath for locating resource files
- transaction > dataSource > properties
Description: List of JDBC vendor properties for the data source. For example, databaseName="dbname" serverName="localhost" portNumber="50000".
Required: false
Data type:
Attribute name Data type Default value Description 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.
- transaction > dataSource > properties.datadirect.sqlserver
Description: Data source properties for the DataDirect Connect for JDBC driver for Microsoft SQL Server.
Required: false
Data type:
Attribute name Data type Default value Description JDBCBehavior
- 1
- 0
0 JDBC driver property: JDBCBehavior. Values are: 0 (JDBC 4.0) or 1 (JDBC 3.0).
- 1
- JDBC 3.0
- 0
- JDBC 4.0
XATransactionGroup string JDBC driver property: XATransactionGroup. XMLDescribeType
- longvarbinary
- longvarchar
JDBC driver property: XMLDescribeType.
- longvarbinary
- longvarbinary
- longvarchar
- longvarchar
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
- ntlm
- userIdPassword
- kerberos
- auto
JDBC driver property: authenticationMethod.
- ntlm
- ntlm
- userIdPassword
- userIdPassword
- kerberos
- kerberos
- auto
- auto
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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. convertNull int JDBC driver property: convertNull. databaseName string JDBC driver property: databaseName. dateTimeInputParameterType
- dateTime
- dateTimeOffset
- auto
JDBC driver property: dateTimeInputParameterType.
- dateTime
- dateTime
- dateTimeOffset
- dateTimeOffset
- auto
- auto
dateTimeOutputParameterType
- dateTime
- dateTimeOffset
- auto
JDBC driver property: dateTimeOutputParameterType.
- dateTime
- dateTime
- dateTimeOffset
- dateTimeOffset
- auto
- auto
describeInputParameters
- describeIfString
- noDescribe
- describeIfDateTime
- describeAll
JDBC driver property: describeInputParameters.
- describeIfString
- describeIfString
- noDescribe
- noDescribe
- describeIfDateTime
- describeIfDateTime
- describeAll
- describeAll
describeOutputParameters
- describeIfString
- noDescribe
- describeIfDateTime
- describeAll
JDBC driver property: describeOutputParameters.
- describeIfString
- describeIfString
- noDescribe
- noDescribe
- describeIfDateTime
- describeIfDateTime
- describeAll
- describeAll
enableBulkLoad boolean JDBC driver property: enableBulkLoad. enableCancelTimeout boolean JDBC driver property: enableCancelTimeout. encryptionMethod
- loginSSL
- requestSSL
- SSL
- noEncryption
JDBC driver property: encryptionMethod.
- loginSSL
- loginSSL
- requestSSL
- requestSSL
- SSL
- SSL
- noEncryption
- noEncryption
failoverGranularity
- disableIntegrityCheck
- atomicWithRepositioning
- nonAtomic
- atomic
JDBC driver property: failoverGranularity.
- disableIntegrityCheck
- disableIntegrityCheck
- atomicWithRepositioning
- atomicWithRepositioning
- nonAtomic
- nonAtomic
- atomic
- atomic
failoverMode
- connect
- select
- extended
JDBC driver property: failoverMode.
- connect
- connect
- select
- select
- 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. 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. longDataCacheSize int Minimum: -1
JDBC driver property: longDataCacheSize. netAddress string JDBC driver property: netAddress. packetSize int Minimum: -1
Maximum: 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. portNumber int 1433 Port on which to obtain database connections. 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. resultsetMetaDataOptions int JDBC driver property: resultsetMetaDataOptions. selectMethod
- direct
- cursor
JDBC driver property: selectMethod.
- direct
- direct
- cursor
- cursor
serverName string localhost Server where the database is running. snapshotSerializable boolean JDBC driver property: snapshotSerializable. spyAttributes string JDBC driver property: spyAttributes. stringInputParameterType
- varchar
- nvarchar
varchar JDBC driver property: stringInputParameterType.
- varchar
- varchar
- nvarchar
- nvarchar
stringOutputParameterType
- varchar
- nvarchar
varchar JDBC driver property: stringOutputParameterType.
- varchar
- varchar
- nvarchar
- nvarchar
suppressConnectionWarnings boolean JDBC driver property: suppressConnectionWarnings. transactionMode
- explicit
- implicit
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. 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.
- transaction > dataSource > properties.db2.i.native
Description: Data source properties for the IBM DB2 for i Native JDBC driver.
Required: false
Data type:
Attribute name Data type Default value Description access
- read only
- all
- read call
all JDBC driver property: access.
- read only
- read only
- all
- all
- read call
- read call
autoCommit boolean true JDBC driver property: autoCommit. batchStyle
- 2.1
- 2.0
2.0 JDBC driver property: batchStyle.
- 2.1
- 2.1
- 2.0
- 2.0
behaviorOverride int JDBC driver property: behaviorOverride. blockSize
- 512
- 128
- 0
- 32
- 64
- 16
- 8
- 256
32 JDBC driver property: blockSize.
- 512
- 512
- 128
- 128
- 0
- 0
- 32
- 32
- 64
- 64
- 16
- 16
- 8
- 8
- 256
- 256
cursorHold boolean false JDBC driver property: cursorHold. cursorSensitivity
- asensitive
- sensitive
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. databaseName string *LOCAL JDBC driver property: databaseName. dateFormat
- dmy
- iso
- eur
- ymd
- julian
- jis
- usa
- mdy
JDBC driver property: dateFormat.
- dmy
- dmy
- iso
- iso
- eur
- eur
- ymd
- ymd
- julian
- julian
- jis
- jis
- usa
- usa
- mdy
- mdy
dateSeparator
- \,
- b
- .
- /
- -
JDBC driver property: dateSeparator.
- \,
- The comma character (,).
- b
- The character b
- .
- The period character (.).
- /
- The forward slash character (/).
- -
- The dash 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 Maximum: 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. We 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. maximumPrecision
- 31
- 63
31 JDBC driver property: maximumPrecision.
- 31
- 31
- 63
- 63
maximumScale int Minimum: 0
Maximum: 63
31 JDBC driver property: maximumScale. minimumDivideScale int Minimum: 0
Maximum: 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
- 1
2 JDBC driver property: queryOptimizeGoal. Values are: 1 (*FIRSTIO) or 2 (*ALLIO).
- 2
- *ALLIO
- 1
- *FIRSTIO
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
- iso
- eur
- jis
- usa
- hms
JDBC driver property: timeFormat.
- iso
- iso
- eur
- eur
- jis
- jis
- usa
- usa
- hms
- hms
timeSeparator
- \,
- b
- :
- .
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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. translateBinary boolean false JDBC driver property: translateBinary. translateHex
- binary
- character
character JDBC driver property: translateHex.
- binary
- binary
- character
- character
useBlockInsert boolean false JDBC driver property: useBlockInsert. user string It is recommended to use a container managed authentication alias instead of configuring this property.
- transaction > dataSource > properties.db2.i.toolbox
Description: Data source properties for the IBM DB2 for i Toolbox JDBC driver.
Required: false
Data type:
Attribute name Data type Default value Description access
- read only
- all
- read call
all JDBC driver property: access.
- read only
- read only
- all
- all
- read call
- read call
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
- 1
- 0
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).
- 2
- 2
- 1
- 1
- 0
- 0
blockSize
- 512
- 128
- 0
- 32
- 64
- 16
- 8
- 256
32 JDBC driver property: blockSize.
- 512
- 512
- 128
- 128
- 0
- 0
- 32
- 32
- 64
- 64
- 16
- 16
- 8
- 8
- 256
- 256
cursorHold boolean false JDBC driver property: cursorHold. cursorSensitivity
- asensitive
- sensitive
- insensitive
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
- insensitive
- insensitive
dataCompression boolean true JDBC driver property: dataCompression. dataTruncation boolean true JDBC driver property: dataTruncation. databaseName string JDBC driver property: databaseName. dateFormat
- dmy
- iso
- eur
- ymd
- julian
- jis
- usa
- mdy
JDBC driver property: dateFormat.
- dmy
- dmy
- iso
- iso
- eur
- eur
- ymd
- ymd
- julian
- julian
- jis
- jis
- usa
- usa
- mdy
- mdy
dateSeparator
- \,
- .
- /
- -
JDBC driver property: dateSeparator.
- The space character ( ).
- \,
- The comma character (,).
- .
- The period character (.).
- /
- The forward slash character (/).
- -
- The dash character (-).
decimalSeparator
- \,
- .
JDBC driver property: decimalSeparator.
- \,
- The comma character (,).
- .
- The period character (.).
driver
- toolbox
- native
toolbox JDBC driver property: driver.
- toolbox
- toolbox
- native
- native
errors
- full
- basic
basic JDBC driver property: errors.
- full
- full
- basic
- basic
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. 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 Minimum: 0
Maximum: 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. maximumPrecision
- 31
- 63
31 JDBC driver property: maximumPrecision.
- 31
- 31
- 63
- 64
maximumScale int Minimum: 0
Maximum: 63
31 JDBC driver property: maximumScale. metaDataSource int Minimum: 0
Maximum: 1
1 JDBC driver property: metaDataSource. minimumDivideScale int Minimum: 0
Maximum: 9
0 JDBC driver property: minimumDivideScale. naming
- system
- sql
sql JDBC driver property: naming.
- system
- system
- sql
- sql
package string JDBC driver property: package. packageAdd boolean true JDBC driver property: packageAdd. packageCCSID
- 13488
- 1200
13488 JDBC driver property: packageCCSID. Values are: 1200 (UCS-2) or 13488 (UTF-16).
- 13488
- 13488 (UTF-16)
- 1200
- 1200 (UCS-2)
packageCache boolean false JDBC driver property: packageCache. packageCriteria
- default
- select
default JDBC driver property: packageCriteria.
- default
- default
- select
- select
packageError
- exception
- none
- warning
warning JDBC driver property: packageError.
- exception
- exception
- none
- none
- warning
- warning
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 Minimum: 0
Maximum: 2
0 JDBC driver property: queryOptimizeGoal. Values are: 1 (*FIRSTIO) or 2 (*ALLIO). receiveBufferSize int Minimum: 1
JDBC driver property: receiveBufferSize. remarks
- system
- sql
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. sendBufferSize int Minimum: 1
JDBC driver property: sendBufferSize. serverName string Server where the database is running. 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. We 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. We can include multiple values in a single entry. For example, 1s500ms is equivalent to 1.5 seconds. sort
- hex
- table
- language
hex JDBC driver property: sort.
- hex
- hex
- table
- table
- language
- language
sortLanguage string JDBC driver property: sortLanguage. sortTable string JDBC driver property: sortTable. sortWeight
- unqiue
- shared
JDBC driver property: sortWeight.
- unqiue
- unique
- shared
- shared
tcpNoDelay boolean JDBC driver property: tcpNoDelay. threadUsed boolean true JDBC driver property: threadUsed. timeFormat
- iso
- eur
- jis
- usa
- hms
JDBC driver property: timeFormat.
- iso
- iso
- eur
- eur
- jis
- jis
- usa
- usa
- hms
- hms
timeSeparator
- \,
- :
- .
JDBC driver property: timeSeparator.
- The space character ( ).
- \,
- The comma character (,).
- :
- The colon character (:).
- .
- The period character (.).
toolboxTrace
- diagnostic
- information
- conversion
- error
- thread
- proxy
- none
- datastream
- pcml
- all
- jdbc
- warning
JDBC driver property: toolboxTrace.
- diagnostic
- diagnostic
- information
- information
- conversion
- conversion
- error
- error
- thread
- thread
- proxy
- proxy
- none
- none
- datastream
- datastream
- pcml
- pcml
- all
- all
- jdbc
- jdbc
- warning
- warning
trace boolean JDBC driver property: trace. translateBinary boolean false JDBC driver property: translateBinary. translateBoolean boolean true JDBC driver property: translateBoolean. translateHex
- binary
- character
character JDBC driver property: translateHex.
- binary
- binary
- character
- character
trueAutoCommit boolean false JDBC driver property: trueAutoCommit. user string It is recommended to use a container managed authentication alias instead of configuring this property. xaLooselyCoupledSupport int Minimum: 0
Maximum: 1
0 JDBC driver property: xaLooselyCoupledSupport.
- transaction > dataSource > properties.db2.jcc
Description: Data source properties for the IBM Data Server Driver for JDBC and SQLJ for DB2.
Required: false
Data type:
Attribute name Data type Default value Description activateDatabase int JDBC driver property: activateDatabase. alternateGroupDatabaseName string JDBC driver property: alternateGroupDatabaseName. alternateGroupPortNumber string JDBC driver property: alternateGroupPortNumber. alternateGroupServerName string JDBC driver property: alternateGroupServerName. 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. clientAccountingInformation string JDBC driver property: clientAccountingInformation. clientApplicationInformation string JDBC driver property: clientApplicationInformation. clientRerouteServerListJNDIName string JDBC driver property: clientRerouteServerListJNDIName. clientUser string JDBC driver property: clientUser. clientWorkstation string JDBC driver property: clientWorkstation. connectionCloseWithInFlightTransaction
- 2
- 1
JDBC driver property: connectionCloseWithInFlightTransaction.
- 2
- CONNECTION_CLOSE_WITH_ROLLBACK
- 1
- CONNECTION_CLOSE_WITH_EXCEPTION
currentAlternateGroupEntry int JDBC driver property: currentAlternateGroupEntry. 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. currentPackagePath string JDBC driver property: currentPackagePath. currentPackageSet string JDBC driver property: currentPackageSet. currentSQLID string JDBC driver property: currentSQLID. currentSchema string JDBC driver property: currentSchema. cursorSensitivity
- 2
- 1
- 0
JDBC driver property: cursorSensitivity. Values are: 0 (TYPE_SCROLL_SENSITIVE_STATIC), 1 (TYPE_SCROLL_SENSITIVE_DYNAMIC), 2 (TYPE_SCROLL_ASENSITIVE).
- 2
- TYPE_SCROLL_ASENSITIVE
- 1
- TYPE_SCROLL_SENSITIVE_DYNAMIC
- 0
- TYPE_SCROLL_SENSITIVE_STATIC
databaseName string JDBC driver property: databaseName. deferPrepares boolean true JDBC driver property: deferPrepares. driverType
- 2
- 4
4 JDBC driver property: driverType.
- 2
- Type 2 JDBC driver.
- 4
- Type 4 JDBC driver.
enableAlternateGroupSeamlessACR boolean JDBC driver property: enableAlternateGroupSeamlessACR. enableClientAffinitiesList
- 2
- 1
JDBC driver property: enableClientAffinitiesList. Values are: 1 (YES) or 2 (NO).
- 2
- NO
- 1
- YES
enableExtendedDescribe
- 2
- 1
JDBC driver property: enableExtendedDescribe.
- 2
- NO
- 1
- YES
enableExtendedIndicators
- 2
- 1
JDBC driver property: enableExtendedIndicators.
- 2
- NO
- 1
- YES
enableNamedParameterMarkers
- 2
- 1
JDBC driver property: enableNamedParameterMarkers. Values are: 1 (YES) or 2 (NO).
- 2
- NO
- 1
- YES
enableSeamlessFailover
- 2
- 1
JDBC driver property: enableSeamlessFailover. Values are: 1 (YES) or 2 (NO).
- 2
- NO
- 1
- YES
enableSysplexWLB boolean JDBC driver property: enableSysplexWLB. fetchSize int JDBC driver property: fetchSize. fullyMaterializeInputStreams boolean JDBC driver property: fullyMaterializeInputStreams. fullyMaterializeInputStreamsOnBatchExecution
- 2
- 1
JDBC driver property: fullyMaterializeInputStreamsOnBatchExecution.
- 2
- NO
- 1
- YES
fullyMaterializeLobData boolean JDBC driver property: fullyMaterializeLobData. implicitRollbackOption
- 2
- 1
- 0
JDBC driver property: implicitRollbackOption.
- 2
- IMPLICIT_ROLLBACK_OPTION_CLOSE_CONNECTION
- 1
- IMPLICIT_ROLLBACK_OPTION_NOT_CLOSE_CONNECTION
- 0
- IMPLICIT_ROLLBACK_OPTION_NOT_SET
interruptProcessingMode
- 2
- 1
- 0
JDBC driver property: interruptProcessingMode.
- 2
- INTERRUPT_PROCESSING_MODE_CLOSE_SOCKET
- 1
- INTERRUPT_PROCESSING_MODE_STATEMENT_CANCEL
- 0
- INTERRUPT_PROCESSING_MODE_DISABLED
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. We 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. We 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. password Reversably encoded password (string) It is recommended to use a container managed authentication alias instead of configuring this property. portNumber int 50000 Port on which to obtain database connections. profileName string JDBC driver property: profileName. queryCloseImplicit
- 2
- 1
JDBC driver property: queryCloseImplicit. Values are: 1 (QUERY_CLOSE_IMPLICIT_YES) or 2 (QUERY_CLOSE_IMPLICIT_NO).
- 2
- QUERY_CLOSE_IMPLICIT_NO
- 1
- QUERY_CLOSE_IMPLICIT_YES
queryDataSize int Minimum: 4096
Maximum: 65535
JDBC driver property: queryDataSize. queryTimeoutInterruptProcessingMode
- 2
- 1
JDBC driver property: queryTimeoutInterruptProcessingMode.
- 2
- INTERRUPT_PROCESSING_MODE_CLOSE_SOCKET
- 1
- INTERRUPT_PROCESSING_MODE_STATEMENT_CANCEL
readOnly boolean JDBC driver property: readOnly. recordTemporalHistory
- 2
- 1
JDBC driver property: recordTemporalHistory.
- 2
- NO
- 1
- YES
resultSetHoldability
- 2
- 1
JDBC driver property: resultSetHoldability. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT).
- 2
- CLOSE_CURSORS_AT_COMMIT
- 1
- HOLD_CURSORS_OVER_COMMIT
resultSetHoldabilityForCatalogQueries
- 2
- 1
JDBC driver property: resultSetHoldabilityForCatalogQueries. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT).
- 2
- CLOSE_CURSORS_AT_COMMIT
- 1
- HOLD_CURSORS_OVER_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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. securityMechanism
- 3
- 7
- 4
- 15
- 9
- 16
- 13
- 11
- 12
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"), (ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY"), 15 (PLUGIN_SECURITY), 16 (ENCRYPTED_USER_ONLY_SECURITY).
- 3
- CLEAR_TEXT_PASSWORD_SECURITY
- 7
- ENCRYPTED_PASSWORD_SECURITY
- 4
- USER_ONLY_SECURITY
- 15
- PLUGIN_SECURITY
- 9
- ENCRYPTED_USER_AND_PASSWORD_SECURITY
- 16
- ENCRYPTED_USER_ONLY_SECURITY
- 13
- ENCRYPTED_USER_PASSWORD_AND_DATA_SECURITY
- 11
- KERBEROS_SECURITY
- 12
- ENCRYPTED_USER_AND_DATA_SECURITY
sendDataAsIs boolean JDBC driver property: sendDataAsIs. serverName string localhost Server where the database is running. sessionTimeZone string JDBC driver property: sessionTimeZone. sqljCloseStmtsWithOpenResultSet boolean JDBC driver property: sqljCloseStmtsWithOpenResultSet. sqljEnableClassLoaderSpecificProfiles boolean JDBC driver property: sqljEnableClassLoaderSpecificProfiles. sslConnection boolean JDBC driver property: sslConnection. streamBufferSize int JDBC driver property: streamBufferSize. stripTrailingZerosForDecimalNumbers
- 2
- 1
JDBC driver property: stripTrailingZerosForDecimalNumbers.
- 2
- NO
- 1
- YES
sysSchema string JDBC driver property: sysSchema. timerLevelForQueryTimeOut
- 2
- 1
- -1
JDBC driver property: timerLevelForQueryTimeOut.
- 2
- QUERYTIMEOUT_CONNECTION_LEVEL
- 1
- QUERYTIMEOUT_STATEMENT_LEVEL
- -1
- QUERYTIMEOUT_DISABLED
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
- 1
- 0
JDBC driver property: traceOption
- 1
- 1
- 0
- 0
translateForBitData
- 2
- 1
JDBC driver property: translateForBitData.
- 2
- SERVER_ENCODING_REPRESENTATION
- 1
- HEX_REPRESENTATION
updateCountForBatch
- 2
- 1
JDBC driver property: updateCountForBatch.
- 2
- TOTAL_UPDATE_COUNT
- 1
- NO_UPDATE_COUNT
useCachedCursor boolean JDBC driver property: useCachedCursor. useIdentityValLocalForAutoGeneratedKeys boolean JDBC driver property: useIdentityValLocalForAutoGeneratedKeys. useJDBC41DefinitionForGetColumns
- 2
- 1
JDBC driver property: useJDBC41DefinitionForGetColumns.
- 2
- NO
- 1
- YES
useJDBC4ColumnNameAndLabelSemantics
- 2
- 1
JDBC driver property: useJDBC4ColumnNameAndLabelSemantics. Values are: 1 (YES) or 2 (NO).
- 2
- NO
- 1
- YES
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.
- transaction > dataSource > properties.derby.client
Description: Data source properties for Derby Network Client JDBC driver.
Required: false
Data type:
Attribute name Data type Default value Description connectionAttributes string JDBC driver property: connectionAttributes. createDatabase
- false
- create
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. 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. We 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. portNumber int 1527 Port on which to obtain database connections. retrieveMessageText boolean true JDBC driver property: retrieveMessageText. securityMechanism
- 3
- 7
- 4
- 9
- 8
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
- 7
- ENCRYPTED_PASSWORD_SECURITY
- 4
- USER_ONLY_SECURITY
- 9
- ENCRYPTED_USER_AND_PASSWORD_SECURITY
- 8
- STRONG_PASSWORD_SUBSTITUTE_SECURITY
serverName string localhost Server where the database is running. shutdownDatabase
- false
- shutdown
JDBC driver property: shutdownDatabase.
- false
- Do not shut down the database.
- shutdown
- Shut down the database when a connection is attempted.
ssl
- basic
- off
- peerAuthentication
JDBC driver property: ssl.
- basic
- basic
- off
- off
- peerAuthentication
- peerAuthentication
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.
- transaction > dataSource > properties.derby.embedded
Description: Data source properties for Derby Embedded JDBC driver.
Required: false
Data type:
Attribute name Data type Default value Description connectionAttributes string JDBC driver property: connectionAttributes. createDatabase
- false
- create
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. 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. We 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
- false
- shutdown
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.
- transaction > dataSource > properties.informix
Description: Data source properties for the Informix JDBC driver.
Required: false
Data type:
Attribute name Data type Default value Description databaseName string JDBC driver property: databaseName. 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. We 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. We 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. We 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. ifxIFXHOST string localhost JDBC driver property: ifxIFXHOST. 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. We 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. We 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. We 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. We 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. portNumber int 1526 Port on which to obtain database connections. roleName string JDBC driver property: roleName. 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.
- transaction > dataSource > properties.informix.jcc
Description: Data source properties for the IBM Data Server Driver for JDBC and SQLJ for Informix.
Required: false
Data type:
Attribute name Data type Default value Description 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. IFX_DIRECTIVES
- ON
- OFF
JDBC driver property: IFX_DIRECTIVES.
- ON
- ON
- OFF
- OFF
IFX_EXTDIRECTIVES
- ON
- OFF
JDBC driver property: IFX_EXTDIRECTIVES.
- ON
- ON
- OFF
- OFF
IFX_UPDDESC string JDBC driver property: IFX_UPDDESC. IFX_XASTDCOMPLIANCE_XAEND
- 1
- 0
JDBC driver property: IFX_XASTDCOMPLIANCE_XAEND.
- 1
- 1
- 0
- 0
INFORMIXOPCACHE string JDBC driver property: INFORMIXOPCACHE. INFORMIXSTACKSIZE string JDBC driver property: INFORMIXSTACKSIZE. NODEFDAC
- yes
- no
JDBC driver property: NODEFDAC.
- yes
- yes
- no
- no
OPTCOMPIND
- 2
- 1
- 0
JDBC driver property: OPTCOMPIND.
- 2
- 2
- 1
- 1
- 0
- 0
OPTOFC
- 1
- 0
JDBC driver property: OPTOFC.
- 1
- 1
- 0
- 0
PDQPRIORITY
- HIGH
- LOW
- OFF
JDBC driver property: PDQPRIORITY.
- HIGH
- HIGH
- LOW
- LOW
- OFF
- OFF
PSORT_DBTEMP string JDBC driver property: PSORT_DBTEMP. PSORT_NPROCS string Maximum: 10
JDBC driver property: PSORT_NPROCS. STMT_CACHE
- 1
- 0
JDBC driver property: STMT_CACHE.
- 1
- 1
- 0
- 0
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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. databaseName string JDBC driver property: databaseName. 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. 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. We 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. portNumber int 1526 Port on which to obtain database connections. progressiveStreaming
- 2
- 1
JDBC driver property: progressiveStreaming. Values are: 1 (YES) or 2 (NO).
- 2
- NO
- 1
- YES
queryDataSize int Minimum: 4096
Maximum: 10485760
JDBC driver property: queryDataSize. resultSetHoldability
- 2
- 1
JDBC driver property: resultSetHoldability. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT).
- 2
- CLOSE_CURSORS_AT_COMMIT
- 1
- HOLD_CURSORS_OVER_COMMIT
resultSetHoldabilityForCatalogQueries
- 2
- 1
JDBC driver property: resultSetHoldabilityForCatalogQueries. Values are: 1 (HOLD_CURSORS_OVER_COMMIT) or 2 (CLOSE_CURSORS_AT_COMMIT).
- 2
- CLOSE_CURSORS_AT_COMMIT
- 1
- HOLD_CURSORS_OVER_COMMIT
retrieveMessagesFromServerOnGetMessage boolean true JDBC driver property: retrieveMessagesFromServerOnGetMessage. securityMechanism
- 3
- 7
- 4
- 9
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
- 7
- ENCRYPTED_PASSWORD_SECURITY
- 4
- USER_ONLY_SECURITY
- 9
- ENCRYPTED_USER_AND_PASSWORD_SECURITY
serverName string localhost Server where the database is running. 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.
- transaction > dataSource > properties.microsoft.sqlserver
Description: Data source properties for Microsoft SQL Server JDBC Driver.
Required: false
Data type:
Attribute name Data type Default value Description URL string URL for connecting to the database. Example: jdbc:sqlserver://localhost:1433;databaseName=myDB. applicationIntent
- ReadOnly
- ReadWrite
JDBC driver property: applicationIntent.
- ReadOnly
- ReadOnly
- ReadWrite
- ReadWrite
applicationName string JDBC driver property: applicationName. authenticationScheme
- NativeAuthentication
- JavaKerberos
JDBC driver property: authenticationScheme.
- NativeAuthentication
- NativeAuthentication
- JavaKerberos
- JavaKerberos
databaseName string JDBC driver property: databaseName. encrypt boolean JDBC driver property: encrypt. failoverPartner string JDBC driver property: failoverPartner. hostNameInCertificate string JDBC driver property: hostNameInCertificate. instanceName string JDBC driver property: instanceName. integratedSecurity boolean JDBC driver property: integratedSecurity. 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. We 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. multiSubnetFailover boolean JDBC driver property: multiSubnetFailover. packetSize int Minimum: 512
Maximum: 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. portNumber int 1433 Port on which to obtain database connections. responseBuffering
- full
- adaptive
JDBC driver property: responseBuffering.
- full
- full
- adaptive
- adaptive
selectMethod
- direct
- cursor
JDBC driver property: selectMethod.
- direct
- direct
- cursor
- cursor
sendStringParametersAsUnicode boolean false JDBC driver property: sendStringParametersAsUnicode. sendTimeAsDatetime boolean JDBC driver property: sendTimeAsDatetime. serverName string localhost Server where the database is running. trustServerCertificate boolean JDBC driver property: trustServerCertificate. 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. workstationID string JDBC driver property: workstationID. xopenStates boolean JDBC driver property: xopenStates.
- transaction > dataSource > properties.oracle
Description: Data source properties for Oracle JDBC driver.
Required: false
Data type:
Attribute name Data type Default value Description ONSConfiguration string JDBC driver property: ONSConfiguration. TNSEntryName string JDBC driver property: TNSEntryName. 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. databaseName string JDBC driver property: databaseName. driverType
- oci
- thin
thin JDBC driver property: driverType.
- oci
- oci
- thin
- thin
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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. networkProtocol string 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 1521 Port on which to obtain database connections. serverName string localhost Server where the database is running. serviceName string JDBC driver property: serviceName. user string It is recommended to use a container managed authentication alias instead of configuring this property.
- transaction > dataSource > properties.sybase
Description: Data source properties for Sybase JDBC driver.
Required: false
Data type:
Attribute name Data type Default value Description SERVER_INITIATED_TRANSACTIONS
- false
- true
false JDBC driver property: SERVER_INITIATED_TRANSACTIONS.
- false
- false
- true
- true
connectionProperties string SELECT_OPENS_CURSOR=true JDBC driver property: connectionProperties. databaseName string JDBC driver property: databaseName. 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. We can include multiple values in a single entry. For example, 1m30s is equivalent to 90 seconds. networkProtocol
- SSL
- socket
JDBC driver property: networkProtocol.
- SSL
- SSL
- socket
- socket
password Reversably encoded password (string) It is recommended to use a container managed authentication alias instead of configuring this property. portNumber int 5000 Port on which to obtain database connections. resourceManagerName string JDBC driver property: resourceManagerName. serverName string localhost Server where the database is running. user string It is recommended to use a container managed authentication alias instead of configuring this property. version int JDBC driver property: version.
- transaction > dataSource > recoveryAuthData
Description: Authentication data for transaction recovery.
Required: false
Data type:
Attribute name Data type Default value Description password Reversably encoded password (string) Password of the user to use when connecting to the EIS. 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.