hibernate.properties
The hibernate.properties file defines the connection to the database and the Object to Relational database mapping.
hibernate.cache.use_second_level_cache - Use Cache
| 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 |
hibernate.connection.datasource - JNDI Data Source
| 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 |
hibernate.connection.driver_class - Connection Driver Class
| 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 |
hibernate.connection.password - Database User Password
| Parameter | hibernate.connection.password |
| Description | Encrypted password for Database User |
| Ordinality | Mandatory |
| Valid Values | Generated Database Password. Value depends on channel:
Online uses Batch uses |
| 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(….) |
hibernate.connection.provider_class - Connection Provider
| 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 |
hibernate.connection.release_mode - Connection Release
| 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 |
hibernate.connection.url - JDBC URL
| 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.dbserver.com:1522:/MYPDB |
hibernate.connection.username - Database User
| Parameter | hibernate.connection.username |
| Description | JDBC User for connection. |
| Ordinality | Mandatory |
| Valid Values | The value depends on the channel accessed:
Online uses Batch uses |
| 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 |
hibernate.dialect - Dialect Used
| 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 |
hibernate.jdbc.batch_size - JDBC2 Update Support
| 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 |
hibernate.jdbc.fetch_size - Solution Set Size
| 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 |
hibernate.max_fetch_depth - Join Fetch Depth
| 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 |
hibernate.query.factory_class - HQL Parser
| 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 |
hibernate.query.substitutions - Literal Mappings
| 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' |
hibernate.show_sql - Debug Mode
| 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 |
hibernate.transaction.factory_class - Transaction Class
| 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 |
hibernate.ucp.connection_wait_timeout - UCP Connection Timeout
| 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 |
hibernate.ucp.inactive_connection_timeout - Connection Inactivity Timeout
| 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 |
hibernate.ucp.jmx_enabled - Enable UCP JMX
| 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 |
hibernate.ucp.max_size - Maximum Pool Size
| 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 |
hibernate.ucp.max_statements - SQL Buffer Size
| 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 |
hibernate.ucp.min_size - Minimum Pool Size
| 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 |