How can I insert data into a database using hibernate without erasing its previous data?

Question

I'm trying to update a database using hibernate..I used the following code for that and that overwrite the database when I tried to enter some values after the first set of values entered.. How can I insert a set of values without erasing previous values??

This is the code that I used.

String firstName = txtfnm.getText();
                String lastName = txtlnm.getText();
                String empId = txtuid.getText();


                //Configuration config = new Configuration();
                Configuration config = new Configuration();
                config.addAnnotatedClass(Employee.class);
                config.configure("hibernate.cfg.xml");

                //to create a new table
                new SchemaExport(config).create(true, true);


                ServiceRegistry servicereg = new ServiceRegistryBuilder().applySettings(config.getProperties()).buildServiceRegistry();

                //create a session factory
                SessionFactory factory = config.buildSessionFactory(servicereg);
                Session session = factory.getCurrentSession();

                //SessionFactory session = factory.getCurrentSession();

                session.beginTransaction();


                Employee emp1 = new Employee();

                emp1.setFname(firstName);
                emp1.setLname(lastName);
                emp1.setUsrid(Integer.valueOf(empId));



                session.update(emp1);

                session.getTransaction().commit();

This is the entity class

@Entity
@Table(name="empdtls")
public class Employee {

    @Column(name="emp_id")
    private int usrid;

    @Column(name="emp_fnm")
    private String fname;

    @Column(name="emp_lnm")
    private String lname;

    @Id
    public int getUsrid() {
        return usrid;
    }

    public void setUsrid(int usrid) {
        this.usrid = usrid;
    }

    public String getFname() {
        return fname;
    }

    public void setFname(String fname) {
        this.fname = fname;
    }

    public String getLname() {
        return lname;
    }

    public void setLname(String lname) {
        this.lname = lname;
    }





}

Vedaradhya Agrahar · Accepted Answer · 2015-03-23 07:16:47Z

1

For updating an entity we have to load the entity from database and update using session...

In u r case u r creating new entity that's y its updating all the fields...

please change code after session.beginTransaction() as fallow....

the following code will get entity from database, having empid "4" ... Its primary key

Employee emp1 = (Employee) session.get(Employee.class, 4);

    emp1.setFname(firstName);

    emp1.setLname(lastName);

    emp1.setUsrid(Integer.valueOf(empId));

    session.update(emp1)

edited Mar 23, 2015 at 7:16

answered Mar 23, 2015 at 7:11

Vedaradhya Agrahar

263 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mitul Sanghani Over a year ago

he want to add new data and you are explaining how to update the entity.?

Mitul Sanghani · Accepted Answer · 2015-03-23 06:52:26Z

0

hibernate consider id to the primary key so in your case

@Id
@Column(name="emp_id")
private int usrid;

userId is the primary key if you are trying to save employee object whose userId(same value e.g 4) is already there in database it will update the value

one more thing if you want to save new fresh data why are you using update() method. use save() or Persist() or in case you don't know the object with same userId is already there in database then go for saveOrUpdate()

edited Mar 23, 2015 at 6:52

answered Mar 23, 2015 at 6:39

Mitul Sanghani

2301 silver badge12 bronze badges

2 Comments

Chatura Mohotti Over a year ago

I did use save() and Persist().But it doesn't work.Still it overwrites the tables data.

Mitul Sanghani Over a year ago

by the way creating every time new sessionfactory is wrong approach from your code it looks like you are creating it. make you code something like sessionFactory will created only one time and then get sessions from the sessionFactory whenever you want to perform some operation. it will work for sure try it. for more details please go through this link

Saurabh Jhunjhunwala · Accepted Answer · 2015-03-23 06:52:50Z

0

Agree with Mitul, but i suppose you should also close the session.

answered Mar 23, 2015 at 6:52

Saurabh Jhunjhunwala

2,9223 gold badges32 silver badges60 bronze badges

Comments

Viswanath Donthi · Accepted Answer · 2015-03-23 11:41:56Z

0

You need to set hibernate.hbm2ddl.auto property as update inside hibernate configuration file.

answered Mar 23, 2015 at 11:41

Viswanath Donthi

1,8211 gold badge12 silver badges12 bronze badges

Collectives™ on Stack Overflow

How can I insert data into a database using hibernate without erasing its previous data?

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related