Problem in insert query

[amishrm sharma]

Hi everyone! I'm developing my first java application using hibernate. I'm stuck with this problem and I can't figure out where's my mistake, so if someone has any idea it would be very helpful.

Basically,my code is properly excuted, but each and every excution time previous data from the table is deleted from the database and new data is inserted into the db. Please suggest me.

i am using Oracle 10g database server.

Please check the below code.
---------------------------------------------------------------------------
in HibernateUtil class
---------------------------------------------------------------------------

 
package com.example.util;
import org.hibernate.*;
import org.hibernate.cfg.*;
public class HibernateUtil {
    private static final SessionFactory sessionFactory;
    static {
        try {
            sessionFactory = new Configuration().configure().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;
    }
}

---------------------------------------------------------------------------
in DataManger class
---------------------------------------------------------------------------

 
package com.example.beans;
import org.hibernate.Session;
import org.hibernate.Transaction;
import com.example.util.HibernateUtil;
public class DataManager {
public static void main(String[] args) {
        com.example.beans.Login pojoObj = new com.example.beans.Login();
 
pojoObj.setLoginid("sanjeev");
pojoObj.setPassword("ola");
pojoObj.setAddress("jp nagar");
pojoObj.setPhno(12345);
pojoObj.setId(5);
pojoObj.setEmail("[e-mail]");
DataManager obDataManager = new DataManager();
obDataManager.createAndStoreData(pojoObj);
    }
 
    private void createAndStoreData(Login obLogin) {
 
        Session session = HibernateUtil.getSessionFactory().getCurrentSession();
        session.beginTransaction();
        
        session.save(obLogin);
        session.getTransaction().commit();
    }
}

---------------------------------------------------------------------------
in Mapping file
---------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping auto-import="true" default-lazy="false">
<class 
    name="com.example.beans.Login" 
    table="TBLLOGIN">
    <id
        name="id"
        type="java.lang.Integer"
        column="id">
        <generator class="native" />
    </id>
    <property
        name="loginid"
        type="java.lang.String"
        column="loginid"
        not-null="true"
        unique="true"
        length="20"
    />
    <property
        name="password"
        type="java.lang.String"
        column="password"
        not-null="true"
        length="20"
    />
    
     <property
        name="email"
        type="java.lang.String"
        column="email"
        not-null="false"
        length="30"
    />
    <property name="address" type="java.lang.String" column="address" not-null="false" length="60"/>
 
  <property name="phno" type="int" column="phno" not-null="false" length="11" />
  </class>
</hibernate-mapping>

---------------------------------------------------------------------------
in Configuration File 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">oracle.jdbc.driver.OracleDriver</property>
        <property name="hibernate.connection.password">welcome1</property>
        <property name="hibernate.connection.url">jdbc  :-o	  racle:thin:@10.151.50.178:1523:BNPLINK</property>
        <property name="hibernate.connection.username">Netpay</property>
        <!-- JDBC connection pool (use the built-in) -->
        <property name="connection.pool_size">1</property>
        <!-- SQL dialect -->
        <property name="hibernate.dialect">org.hibernate.dialect.OracleDialect</property>
        <!-- Enable Hibernate's automatic session context management -->
        <property name="current_session_context_class">thread</property>
        <!-- Disable the second-level cache  -->
        <property name="cache.provider_class">org.hibernate.cache.NoCacheProvider</property>
        <!-- Echo all executed SQL to stdout -->
        <property name="show_sql">true</property>
<property name="format_sql">true</property>
        <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">create</property>
        <mapping resource="com/example/beans/Login.hbm.xml"/>
    </session-factory>
</hibernate-configuration>

--------------------------------------
Best Regards,
Amit Sharma
[ December 17, 2008: Message edited by: Paul Sturrock ]

[Paul Sturrock]

Basically,my code is properly excuted, but each and every excution time previous data from the table is deleted from the database and new data is inserted into the db. Please suggest me.

From your hibernate.cfg.xml:

 <!-- Drop and re-create the database schema on startup -->
        <property name="hbm2ddl.auto">create</property>

This means your tables will be removed everytime your restart your application. If you want Hibernate to do DDL stuff, you might consider changing this value to update.
[ December 17, 2008: Message edited by: Paul Sturrock ]

[amishrm sharma]

Thanks Paul..
it's working now.