I'm not able to insert record in Derby using Hibernate

[Sanjeev Kumaar]

Hi All!

This is my first example of Hibernate. I'm trying to insert a record in Derby using Hibernate. I've created a web application where a servlet is doing the main stuff.

I've used
IDE : Netbeans 6.8
Database : Derby
Server : Glassfish



here is my hibernate.cfg.xml
<?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> <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://localhost:1527/sample</property> <property name="hibernate.connection.username">app</property> <property name="hibernate.connection.password">app</property> <mapping resource="pack1/Student.hbm.xml"/> </session-factory> </hibernate-configuration>


my hibernate.reveng.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE hibernate-reverse-engineering PUBLIC "-//Hibernate/Hibernate Reverse Engineering DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-reverse-engineering-3.0.dtd"> <hibernate-reverse-engineering> <schema-selection match-schema="APP"/> <table-filter match-name="STUDENT"/> </hibernate-reverse-engineering>

my pack1.Student.hbm.xml

<?xml version="1.0"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <!-- Generated May 23, 2011 2:10:04 PM by Hibernate Tools 3.2.1.GA --> <hibernate-mapping> <class name="pack1.Student" table="STUDENT" schema="APP"> <id name="roll" type="int"> <column name="ROLL" precision="4" scale="0" /> <generator class="assigned" /> </id> <property name="sname" type="string"> <column name="SNAME" length="20" not-null="true" /> </property> </class> </hibernate-mapping>


my pack1.Student.java

package pack1;
// Generated May 23, 2011 2:10:03 PM by Hibernate Tools 3.2.1.GA
/**
 * Student generated by hbm2java
 */
public class Student  implements java.io.Serializable {
     private int roll;

     private String sname;
    public Student() {
    }

    public Student(int roll, String sname) {
       this.roll = roll;
       this.sname = sname;
    }
  
    public String getSname() {
        return this.sname;
    }
    
    public void setSname(String sname) {
        this.sname = sname;
    }

    /**
     * @return the roll
     */
    public int getRoll() {
        return roll;
    }

    /**
     * @param roll the roll to set
     */
    public void setRoll(int roll) {
        this.roll = roll;
    }

}

my pack1.NewHibernateUtil.java

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package pack1;

import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.SessionFactory;

/**
 * Hibernate Utility class with a convenient method to get Session Factory object.
 *
 * @author appnetix
 */
public class NewHibernateUtil {
    private static final SessionFactory sessionFactory;

    static {
        try {
            // Create the SessionFactory from standard (hibernate.cfg.xml) 
            // config file.
            sessionFactory = new AnnotationConfiguration().configure().buildSessionFactory();
        } catch (Throwable ex) {
            // Log the exception. 
            System.err.println("Initial SessionFactory creation failed." + ex);
            throw new ExceptionInInitializerError(ex);
        }
    }

    public static SessionFactory getSessionFactory() {
        return sessionFactory;
    }
}

n my pack1.NewServlet.java

 PrintWriter out = response.getWriter();
        try {
        Student s1=new Student();
        s1.setSname("Sanjeev");
        Session ses=NewHibernateUtil.getSessionFactory().openSession();
        ses.beginTransaction();
        ses.save(s1);

        ses.close();
        out.print("Success");


        }
        catch(Exception e){
            out.print(e);
        }
        finally {
            out.close();
        }

I'm having STUDENT table inside "sample" db on my local Derby server.
create table "APP".STUDENT ( ROLL INTEGER not null primary key, SNAME VARCHAR(20) NOT NULL )



while calling servlet it shows success but doesn't inserting record .

Please guide me.

Thanks in advance.

[Paul Sturrock]

Where do you commit your transaction?

[Sanjeev Kumaar]

Thanks Paul for showing interest ,

as per tutorial saving the session was enough and I if committing the transaction is necessary then how I'll do this ? I mean which method I'll use?

[Sanjeev Kumaar]

Problem resolved ....

I modified my servlet code a bit like following.

 response.setContentType("text/html;charset=UTF-8");
        PrintWriter out = response.getWriter();
        Session ses=null;
        try {
        Student s1=new Student();

        s1.setSname(request.getParameter("name"));
        s1.setRoll(Integer.parseInt(request.getParameter("roll")));

        ses=NewHibernateUtil.getSessionFactory().openSession();
        Transaction tran=ses.beginTransaction();
        tran.begin();
        ses.save(s1);
        ses.flush();
        tran.commit();
        //ses.close();
        out.print("Success");


        }
        catch(Exception e){
            out.print(e);
        }
        finally {
            if(ses!=null && ses.isOpen())
                ses.close();
            out.close();
        }

Tell me if I can improve this ...


Thanks Paul ! you were really helpful .

[Paul Sturrock]

Sanjeev Kumaar wrote:
Thanks Paul for showing interest ,

as per tutorial saving the session was enough and I if committing the transaction is necessary then how I'll do this ? I mean which method I'll use?

You are welcome.

The tutorial you are using is wrong.