How to use update query in hibernate

Question

hi am very new to hibernate and could anybody plz help me out how to use update query to upadte the record of the table ...i am using like this in dao class

  Session ses = HibernateUtil.getSessionFactory().openSession();
        Transaction tx = ses.beginTransaction();
        Query q = ses.createQuery("from RegisterPojo  where email =:email");
        q.setParameter("email", bean.getEmail());
        RegisterPojo pojo = (RegisterPojo) q.list().get(0);
        pojo.setUname(bean.getUname());
        ses.update(pojo);
        tx.commit();
        ses.flush();
        ses.close();

Hi i have edited my code from this am getting exception as, Could not execute JDBC batch update

thanks in advance

hi could anybody plz help me out!!

user2838630
– user2838630

2013-10-24 12:06:17 +00:00
Commented Oct 24, 2013 at 12:06 — user2838630
– user2838630, Commented Oct 24, 2013 at 12:06

Scary Wombat · Accepted Answer · 2013-10-24 06:31:00Z

1

You need to call update on the hibernate session

Observe the following example

Query q = session.createQuery("from RegisterPojo where email =:email");
q.setParameter("email", "[email protected]");
RegisterPojo  pojo= (RegisterPojo)q.list().get(0);

pojo.setName("Fred");
session.update(pojo);

edited Oct 24, 2013 at 6:31

answered Oct 24, 2013 at 5:28

Scary Wombat

44.9k6 gold badges38 silver badges67 bronze badges

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

6 Comments

Scary Wombat Over a year ago

Because the above syntax is for getting a list from a query as in select * from employees

user2838630 Over a year ago

here I could not understand what is the table name

user2838630 Over a year ago

Now the query is executing fine but the data is not updating in table

Scary Wombat Over a year ago

In that case you probably need a transaction which will need commiting as in tx = session.beginTransaction();

Scary Wombat Over a year ago

OK - does it work? You may want to wrap the code in a try/catch and only do the commit if no exceptions otherwise rollback

|

Collectives™ on Stack Overflow

How to use update query in hibernate

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related