Hibernate

The Hibernate resource template represents a Hibernate resource. Used by component implementations to access databases, the hibernate is a framework that supports storing Java objects in a relational database. Hibernate solves object-relational impedance mismatch by replacing direct database access with high-level, object-handling functions.

General

Property Required? Editable? Accepts SVars? Description
Data Source Y Y N The name of a JDBC resource that represents the connection to the database.
Schema Generation Type N N N Indicate whether to create or validate the schema in the database when the session factory is created:
  • Do Nothing - Indicate that only data is added, changed, and deleted. If the schema does not already exist, the application will experience errors when it runs.
  • Validate - Validate the schema.
  • Create - Create the schema every time the session factory is created, deleting old schema and data if it exists.
  • Create Drop - Same as Create, but drops the schema at the end of the session.
  • Update - Update the schema with the changes implied by the Java objects being mapped to the database.

Default: Do Nothing.

Dialect Y Y Y The class name of a Hibernate dialect that enables Hibernate to generate SQL optimized for a particular relational database. The supported dialects are:
  • org.hibernate.dialect
    • DB2390Dialect
    • DB2400Dialect
    • DB2Dialect
    • FirebirdDialect
    • FrontbaseDialect
    • HSQLDialect
    • InformixDialect
    • IngresDialect
    • InterbaseDialect
    • MckoiDialect
    • MySQLDialect
    • MySQLInnoDBDialect
    • MySQLMyISAMDialect
    • Oracle9Dialect
    • OracleDialect
    • PointbaseDialect
    • PostgreSQLDialect
    • ProgressDialect
    • SAPDBDialect
    • SQLServerDialect
    • SybaseAnywhereDialect
    • SybaseDialect
  • com.tibco.amf.sharedresource.runtime.core. hibernate.dialects
    • DB2Dialect
    • HSQLDialect
    • MySQL5Dialect
    • Oracle9Dialect
    • Oracle10GDialect
    • SQLServerDialect

Default: com.tibco.amf.sharedresource.runtime.core. hibernate.dialects.HSQLDialect

Advanced

Property Required? Editable? Accepts SVars? Description
Enable SQL Logging N N Y Permit data collection in the SQL Server transaction log file.

Default: Unchecked.

Batch Size N Y Y Enables JDBC batch processing.

Default: 5.

Share Session Factory N Y Y

Indicate whether clients share the session factory or whether a new factory is created for each client.

Default: Checked.

Property Required? Editable? Accepts SVars? Description
Properties N Y N Hibernate configuration properties:
  • Format SQL Enabled
  • Default Schema
  • Default Catalog
  • Max Fetch Depth
  • Default Batch Fetch Size
  • Use Order Updates
  • Use Order Inserts
  • Use Generate Statistics
  • Use Identifier Rollback
  • Use SQL Comments
  • Fetch Size
  • Batch Versioned Data
  • Batcher Factory Class
  • Use Scrollable Resultset
  • Use Stream For Binary
  • Use Get Generated Keys
  • Connection Isolation
  • Use Auto Commit
  • Connection Release Mode
  • Cache Provider Class
  • Use Minimal Puts
  • Use Query Cache
  • Use Second Level Cache
  • Query Cache Factory
  • Cache Region Prefix
  • Use Structured Entries
  • Transaction Factory Class
  • JTA Transaction JNDI Name
  • Flush Before Completion
  • Auto Close Session
  • Query Factory Class
  • Query Substitutions
  • Use Reflection Optimizer
Related reference