<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
    <session-factory>

        <!-- hibernate dialect -->
        <property name="hibernate.dialect">org.hibernate.dialect.DerbyDialect</property>


        <property name="hibernate.connection.driver_class">org.apache.derby.jdbc.ClientDriver</property>
        <property name="hibernate.connection.url">jdbc:derby:C:\Users\user1\MyDbTest</property>
        <property name="hibernate.connection.username"></property>
        <property name="hibernate.connection.password"></property>
        <property name="transaction.factory_class">org.hibernate.transaction.JDBCTransactionFactory</property>

        <!-- Automatic schema creation (begin) === -->
        <property name="hibernate.hbm2ddl.auto">create</property>


        <!-- Simple memory-only cache -->
        <property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>

        <!-- ############################################ -->
        <!-- # mapping files with external dependencies # -->
        <!-- ############################################ -->

        <mapping resource="com/sample/DBAccess/Employee.hbm.xml" />

    </session-factory>
</hibernate-configuration>

package com.sample.DBAccess;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;

@SuppressWarnings("deprecation")
public class SessionFactoryUtil {
   private static final SessionFactory sessionFactory;
       static {
           try {
               // Create the SessionFactory from hibernate.cfg.xml
               //sessionFactory = new Configuration().configure().buildSessionFactory();
              Configuration cfg = new Configuration();
              cfg.configure("hibernate.cfg.xml");
              sessionFactory = cfg.buildSessionFactory();
              
           } catch (Throwable ex) {
               // Make sure you log the exception, as it might be swallowed
               System.err.println("Initial SessionFactory creation failed." + ex);
               throw new ExceptionInInitializerError(ex);
           }
       }

       public static SessionFactory getSessionFactory() {
           return sessionFactory;
       }

   }

package com.sample.DBAccess;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;


public class TestDBAccess {
   public static void main(String[] args) {
      Session session = SessionFactoryUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        createEmployee(session);
        queryEmployee(session);
    }

    private static void queryEmployee(Session session) {
        Query query = session.createQuery("from Employee");                 
        List <Employee>list = query.list();
       java.util.Iterator<Employee> iter = list.iterator();
        while (iter.hasNext()) {
           Employee employee = iter.next();
            System.out.println("Employee: \"" + employee.getEmpNo() +"\", " + employee.getEmpName() +"\", " + employee.getAddr() + "\", " + employee.getDesignation() + "\", " + employee.getDept());
        }
        session.getTransaction().commit();
    }

    public static void createEmployee(Session session) {
           Employee employee = new Employee();
           employee.setEmpNo(4943);
           employee.setEmpName("Next Employee");       
           employee.setAddr("D3-104, South City, Some City");       
           employee.setDesignation("Manager");
           employee.setDept(102);
           session.save(employee);
   }
}