Database Store (databaseStore)
Specifies a relational database as a persistent store for server features.
Name | Type | Default | Description |
---|---|---|---|
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. |
id | string | A unique configuration ID. | |
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. |
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. |
Authentication data for task scheduling, queries, and execution.
Name | Type | Default | Description |
---|---|---|---|
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. |
Data source that connects to the persistent store.
Name | Type | Default | Description |
---|---|---|---|
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. |
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. | |
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 | 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. | |
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. |
Connection manager for a data source. If updated while the server is running, existing connections are destroyed.
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.
Identify a specific SQL error code or SQL state on a SQLException. This enables the server to take appropriate action based on the error condition. For example, closing a stale connection instead of returning it to the connection pool.
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.
JDBC driver for a data source. If updated while the server is running, existing connections are destroyed.
List of JDBC vendor properties for the data source. For example, databaseName="dbname" serverName="localhost" portNumber="50000". Use this generic properties list when no vendor-specific properties list type is available for your JDBC driver. Do not specify multiple properties elements under a data source. Instead, place all property name-value pairs on a single properties or properties.{JDBC_VENDOR_TYPE} element.
Data source properties for the DataDirect Connect for JDBC driver for Microsoft SQL Server.
Data source properties for the IBM DB2 for i Native JDBC driver.
Data source properties for the IBM DB2 for i Toolbox JDBC driver.
Data source properties for the IBM Data Server Driver for JDBC and SQLJ for DB2.
Data source properties for Derby Network Client JDBC driver.
Data source properties for Derby Embedded JDBC driver.
Data source properties for the Informix JDBC driver.
Data source properties for the IBM Data Server Driver for JDBC and SQLJ for Informix.
Data source properties for Microsoft SQL Server JDBC Driver.
Data source properties for Oracle JDBC driver.
Data source properties for Oracle Universal Connection Pooling.
Data source properties for PostgreSQL JDBC driver.
Data source properties for Sybase JDBC driver.
Authentication data for transaction recovery.