Data getting saved in session, but not being persisted in table.

[mara thamizhan]

Dear dudes,
In persisting data in MySQL through hibernate, i'm using a simple java class , which creates an instance of my form , sets data , reads the configuration file, builds a session factory i.e. hibernate.cfg.xml , opens the session and save data .
Actually data was not inserted into the table eventhough i'm getting the message similar to that.

I created the database in MySQL initially.
message console:

 
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Inserting Record
Done
Done1
[B]Hibernate: insert [/B]into INFORMATION (FIRSTNAME, LASTNAME, EMAIL, ID) values (?, ?, ?, ?)
Done2
 
   

My java application:"Testinghibernate.java"

   
package srit.tutorial.hibernate;
 
import java.sql.Connection;
 
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.cfg.Configuration;
 

/**
 * @author Deepak Kumar
 *
 * <a href="http://www.roseindia.net" target="_blank" rel="nofollow">http://www.roseindia.net</a>
 * Hibernate example to inset data into Contact table
 */
public class TestingHibernate {
  public static void main(String[] args) {
    Session session = null;
 
    try{
      // This step will read hibernate.cfg.xml 
 
//and prepare hibernate for use
      SessionFactory sessionFactory = new 
 
Configuration().configure().buildSessionFactory();
       session =sessionFactory.openSession();
        //Create new instance of Contact and set 
 
//values in it by reading them from form object
         System.out.println("Inserting Record");
        Information contact = new Information();
        contact.setFirstName("Deepak");
        contact.setLastName("Kumar");
        contact.setEmail("[e-mail]");
        contact.setId(32);
        session.save(contact);
        System.out.println("Done");
    }catch(Exception e){
      System.out.println(e.getMessage());
    }finally{
      // Actual contact insertion will happen at this step
        System.out.println("Done1");
      session.flush();
      System.out.println("Done2");
      session.close();
 
      }
    
  }
} 
 

 
 

Information.java

package srit.tutorial.hibernate;
 
/**
 * @author SayeeNarayanan
 *
 * Java Class to map to the datbase Contact Table
 */
public class Information {
  private String firstName;
  private String lastName;
  private String email;
  private long id;
 
  /**
   * @return Email
   */
  public String getEmail() {
    return email;
  }
 
  /**
   * @return First Name
   */
  public String getFirstName() {
    return firstName;
  }
 
  /** 
   * @return Last name
   */
  public String getLastName() {
    return lastName;
  }
 
  /**
   * @param string Sets the Email
   */
  public void setEmail(String string) {
    email = string;
  }
 
  /**
   * @param string Sets the First Name
   */
  public void setFirstName(String string) {
    firstName = string;
  }
 
  /**
   * @param string sets the Last Name
   */
  public void setLastName(String string) {
    lastName = string;
  }
 
  /**
   * @return ID Returns ID
   */
  public long getId() {
    return id;
  }
 
  /**
   * @param l Sets the ID
   */
  public void setId(long l) {
    id = l;
  }
 
} 
 

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.connection.driver_class">org.gjt.mm.mysql.Driver</property>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQLDialect</property>
        <property name="hibernate.connection.url">jdbc:mysql://localhost:3306/hibernatetutorial</property>
        <property name="hibernate.connection.username">root</property>
        <property name="hibernate.connection.password">root</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
        <property name="hibernate.connection.pool_size">10</property>
        <property name="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</property>
        <property name="hibernate.show_sql">true</property>
        
        <mapping resource="Information.hbm.xml" />  
        
        
        
        
        
        
    </session-factory>
    
</hibernate-configuration>
  

Information.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">
 
<hibernate-mapping>
  <class name="srit.tutorial.hibernate.Information" table="INFORMATION">
   <id name="id" type="long" column="ID" >
   <generator class="assigned"/>
  </id>
 
  <property name="firstName">
     <column name="FIRSTNAME" />
  </property>
  <property name="lastName">
    <column name="LASTNAME"/>
  </property>
  <property name="email">
    <column name="EMAIL"/>
  </property>
 </class>
</hibernate-mapping>
    

[mara thamizhan]

will someone please reply?

[jayachandra madopothula]

Possible corrections you have to have work
1.If you are working in eclipse please check the application structure
2. remove the

 <generator class="assigned"/>   

and run it.

[jayachandra madopothula]

see the structure shown in the picture.

after arranging the whole structure just update resource mapping tag in hibernate.cfg.xml with absolute path of the hbm.xml

[Mark Spritzler]

Hibernate requires a Transaction, and it to be commited to actually save stuff to the database. I do not see a

Transaction tx = session.beginTransaction();

and I also don't see a

tx.commit();

in your code.

Mark

[Vikky Bali]

Using Transaction it is working but Is this mandatory to use transaction in Hibernate ?