User Manual

The basic configuration is ready for you to perform database operation using Hibernate.
Opening a Session for Database Operation
Opening a new session for database transaction involves:
1. “Configuring SessionFactory in the hibernate.cfg.xml File” (page 109)
2. “Creating a New Session from the SessionFactory in your Java Program” (page 109)
Configuring SessionFactory in the hibernate.cfg.xml File
Add the following lines to configure the Hibernate SessionFactory.
<?xml version='1.0' encoding='utf-8'?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
...
...
...
...
...
</session-factory>
</hibernate-configuration>
NOTE: The above configuration uses the hibernate-configuration-3.0.dtd file.
Creating a New Session from the SessionFactory in your Java Program
Add the following lines of code in your Java program:
SessionFactory sessionFactory;
Configuration cfg = new Configuration().configure();
sessionFactory = cfg.buildSessionFactory();
Session session = sessionFactory.openSession();
NOTE: To view the complete configuration snippet of hibernate.cfg.xml, see “Sample JDBC
Configuration for Hibernate” (page 338).
Closing the Session
Once the database operation is complete, close the session to deallocate the memory.
Add the following line of code when you complete the database operation.
session.close();
Configuring JDBC Type 2 or Type 4 Driver for SQL/MX Database using hibernate.properties
To complete the database operation in a Hibernate application using the JDBC driver for the
SQL/MX database, complete the following steps:
1. “Specifying the JDBC Driver Class for SQL/MX Database” (page 110)
2. “Defining the Connection URL” (page 110)
3. “Establishing the Connection” (page 110)
4. “Defining the Hibernate Dialect for SQL/MX Database” (page 110)
5. “Opening a Session for Database Operation” (page 110)
6. “Specifying the Mapping Resources” (page 111)
7. “Closing the Session” (page 111)
Configuring Hibernate Applications on NonStop Systems 109