Parameter | hibernate.cache.use_second_level_cache |
Description | Enable or Disable the second level cache, which is enabled by default for classes which specifies a cache mapping. This is disabled by default as Oracle Utilities Application Framework includes its own cache. |
Ordinality | Mandatory |
Valid Values | [true|false] |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.cache.use_second_level_cache = false |
Parameter | hibernate.connection.datasource |
Description | Enables Data Source support and indicates JNDI data source. This is an alternative to UCP. See JDBC Support for more information. JNDI data sources cannot be used for batch processing. |
Ordinality | Mandatory |
Valid Values | JNDI path to data source. |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services. |
Example: | hibernate.connection.datasource=jdbc/ouafdb |
Parameter | hibernate.connection.driver_class |
Description | Driver class used by Hibernate. |
Ordinality | Mandatory |
Valid Values | Valid Driver Class. Default: oracle.jdbc.driver.OracleDriver |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.connection.driver_class = oracle.jdbc.driver.OracleDriver |
Parameter | hibernate.connection.password |
Description | Encrypted password for Database User. |
Ordinality | Mandatory |
Valid Values | Generated Database Password. Value depends on channel: Online uses DBPASS IWS uses XAI_DBPASS Batch uses BATCH_DBPASS |
Source | Maintained by product templates. Set appropriate value for user required in required parameter. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.connection.password = ENCKS(….) |
Parameter | hibernate.connection.provider_class |
Description | Connection Provider Class for Hibernate. Use the default UCP provider as supplied unless using JBDC Data Sources where com.hibernate.connection.DatasourceConnectionProvider is used instead. |
Ordinality | Mandatory |
Valid Values | Generated Provider Class. Default: com.splwg.shared.common.UCPConnectionProvider |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.connection.provider_class= com.splwg.shared.common.UCPConnectionProvider |
Parameter | hibernate.connection.release_mode |
Description | This parameter controls when a connection is released to the pool. By default the value is set to after_transaction. Whilst other values can be used, for consistency of the connection it is recommended to use the default. |
Ordinality | Mandatory |
Valid Values | Generated Release Mode. Default: after_transaction |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.connection.release_mode=after_transaction |
Parameter | hibernate.connection.url |
Description | JDBC URL for connection to database. |
Ordinality | Mandatory |
Valid Values | Generated URL or using override database connection. |
Source | Maintained by product templates. Use DB_OVERRIDE_CONNECTION for specific values. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.connection.url = jdbc:oracle:thin:@ouafdemo.us.oracle.com:1522:/MYPDB |
Parameter | hibernate.connection.username |
Description | JDBC User for connection. |
Ordinality | Mandatory |
Valid Values | The value depends on the channel accessed: Online uses DBUSER IWS uses XAI_DBUSER Batch uses BATCH_DBUSER |
Source | Maintained by product templates. Set appropriate value for user required in required parameter. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.connection.username=CISUSER |
Parameter | hibernate.dialect |
Description | This is the SQL dialect (database type) for the database being used. Any valid Hibernate dialect may be used. Refer to http://www.hibernate.org/hib_docs/v3/api/org/hibernate/dialect/package-summary.html for a full list. |
Ordinality | Mandatory |
Valid Values | Generated Dialect. Default: org.hibernate.dialect.Oracle10gDialect. |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.dialect=org.hibernate.dialect.Oracle10gDialect |
Parameter | hibernate.jdbc.batch_size |
Description | A non-zero value enables use of JDBC2 batch updates by Hibernate. |
Ordinality | Mandatory |
Valid Values | Generated Value. Default: 30. |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.jdbc.batch_size=30 |
Parameter | hibernate.jdbc.fetch_size |
Description | Determines a hint to the JDBC driver on the the number of rows to return in any SQL statement. This is overridden at runtime on zone parameters and commit interval. |
Ordinality | Mandatory |
Valid Values | Generated Value. Default: 100. |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.jdbc.fetch_size=100 |
Parameter | hibernate.max_fetch_depth |
Description | Sets a maximum depth for the outer join fetch tree for single-ended associations (one-to-one, many-to-one). A 0 disables default outer join fetching |
Ordinality | Mandatory |
Valid Values | Generated Value. Default: 2. |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.max_fetch_depth=2 |
Parameter | hibernate.query.factory_class |
Description | The classname of a Querey Factory to use for HQL parsing. |
Ordinality | Mandatory |
Valid Values | Generated Value. Default: org.hibernate.hql.internal.classic.ClassicQueryTranslatorFactory |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.query.factory_class= org.hibernate.hql.internal.classic.ClassicQueryTranslatorFactory |
Parameter | hibernate.query.substitutions |
Description | Mapping from tokens in Hibernate queries to SQL tokens (tokens might be function or literal names, for example). |
Ordinality | Mandatory |
Valid Values | [true 'Y'|false 'N'] |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.query.substitutions = true 'Y', false 'N' |
Parameter | hibernate.show_sql |
Description | Use of Debug Mode for all SQL Statements. It is highly recommended not to enable debug at this level. |
Ordinality | Mandatory |
Valid Values | [true|false] |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.show_sql = false |
Parameter | hibernate.transaction.factory_class |
Description | The classname of a Transaction Factory to use with Hibernate Transaction API. |
Ordinality | Mandatory |
Valid Values | Generated Value. Default: org.hibernate.transaction.JDBCTransactionFactory |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.transaction.factory_class = org.hibernate.transaction.JDBCTransactionFactory |
Parameter | hibernate.ucp.connection_wait_timeout |
Description | Specifies how long, in seconds, an application request waits to obtain a connection if there are no longer any connections in the pool |
Ordinality | Mandatory |
Valid Values | Generated Value. Default: 5. |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.ucp.connection_wait_timeout=5 |
Parameter | hibernate.ucp.inactive_connection_timeout |
Description | Specifies how long, in seconds, an available connection can remain idle before it is closed and removed from the pool. |
Ordinality | Mandatory |
Valid Values | Generated Value. Default: 300. |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.ucp.inactive_connection_timeout=300 |
Parameter | hibernate.ucp.jmx_enabled |
Description | Enable or Disable JMX Mbeans for UCP. The Mbeans will appear as additional classes on the existing JMX capabilities for that tier. |
Ordinality | Mandatory |
Valid Values | [true|false] |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.ucp.jmx_enabled=false |
Parameter | hibernate.ucp.max_size |
Description | Maximum Pool size for this teir. Maximum number of active connections to the database. |
Ordinality | Mandatory |
Valid Values | Generated. Default: 30 |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.ucp.max_size=30 |
Parameter | hibernate.ucp.max_statements |
Description | Number of statements cached for performance on this teir. |
Ordinality | Mandatory |
Valid Values | Generated. Default: 50 |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.ucp.max_statements=50 |
Parameter | hibernate.ucp.min_size |
Description | Initial Connection Pool size for this tier. |
Ordinality | Mandatory |
Valid Values | Generated. Default: 1 |
Source | Maintained by product templates. Use Implementing Custom Templates to implement a different value. |
Applicability | Business Application Server, Inbound Web Services, Background Processing. |
Example: | hibernate.ucp.min_size=1 |