Using Hibernate

in a Java Swing Application 3




  1. Modifying the Hibernate Configuration File

  2. Creating the Helper File


Modifying the Hibernate Configuration File


In this exercise you will edit the default properties specified in hibernate.cfg.xml to enable debug logging for SQL statements.


Open hibernate.cfg.xml in the Design tab. You can open the file by expanding the Configuration Files node in the Projects window and double-clicking hibernate.cfg.xml.

Expand the Configuration Properties node under Optional Properties.

Click Add button to open the Add Hibernate Property dialog box.


Invoking the Add Hibernate Property page


In the dialog box, select the hibernate.show_sql property and set the value to true. Click OK. This enables the debug logging of the SQL statements.


Setting the Hibernate property name and its value


Click Add under the Miscellaneous Properties node and select hibernate.query.factory_class in the Property Name dropdown list.

Manually, type org.hibernate.hql.classic.ClassicQueryTranslatorFactory as the Property Value. Click OK.



Setting the Hibernate Property Name and Value


If you click the XML tab in the editor you can see the file in XML view. Your file should look like the following:





Invoking the XML file format for hibernate.cfg.xml file


The following is the XML file content.


<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE hibernate-configuration PUBLIC "-//Hibernate/Hibernate Configuration DTD 3.0//EN" "">



    <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>

    <property name="hibernate.connection.driver_class">com.mysql.jdbc.Driver</property>

    <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/sakila</property>

    <property name="hibernate.connection.username">root</property>

    <property name="hibernate.connection.password">#########</property>

    <property name="hibernate.show_sql">true</property>

    <property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>




The following screenshot shows the content of the real hibernate.cfg.xml file.








The XML format for hibernate.cfg.xml file


Save your changes to the file.

When you run your project you will be able to see the SQL query printed in the IDE's Output window. We will see this later.


Creating the Helper File


To use Hibernate you need to create a helper class that handles startup and that accesses Hibernate's SessionFactory to obtain a Session object. The class calls Hibernate's configure() method, loads the hibernate.cfg.xml configuration file and then builds the SessionFactory to obtain the Session object.

In this section you use the New File wizard to create the helper class


Select and right-click the Source Packages node > select New > select Other to open the New File wizard.


Invoking the Add New File to the Java Hibernate project


Select Hibernate from the Categories list and from the File Types list. Click Next.





Selecting the file type from the Hibernate Categories


Type HibernateUtil for the class name and sakila.util as the package name. Click Finish.


Choosing the Hibernate helper class name and the package name


When you click Finish, opens in the editor. You can close the file because you do not need to edit the file.




< Java Swing and Hibernate 2 | Java and NetBeans Tutorial | Java Swing and Hibernate 4 >