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 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 experiences 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.

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