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

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.us.oracle.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 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

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