Update query executing but not updating table with hibernate

Question

I have a db with 5 pieces (id, question, result) and i want to change my db with update query and hibernate.

I tried this

public void update()
    {
        try
        {
            Session session = getSession();
            Transaction tx = session.beginTransaction();                

            Query query = getSession().createQuery("update Nodes set question = 'test updating' where id = 1" );

            tx.commit();
            session.close();

I don't have error, in console i have

Infos: Hibernate: update node set question='test updating' where id=1

Hibernate execute my update without error but there is not in my db, why ?

Thanks

ajitksharma · Accepted Answer · 2014-05-19 17:21:38Z

1

Try this

public void update()
{
    try
    {
        Session session = getSession();
        Transaction tx = session.beginTransaction();                

        Query query = getSession().createQuery("update Nodes set question = 'test updating' where id = 1" );

        query.executeUpdate(); //add this line
        session.commit();
        session.close();

hope this helps you with your problem

edited May 19, 2014 at 17:21

answered May 19, 2014 at 16:13

ajitksharma

2,0172 gold badges22 silver badges40 bronze badges

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

7 Comments

Biohazard401 Over a year ago

Thanks for your answer but my update is not update in my db. thanks

Biohazard401 Over a year ago

no sorry, i haven't error but its no updating in db

ajitksharma Over a year ago

you can try int results=qry.executeUpdate() and printing "results" and chek value is it really updating or not. If its 1 that means code is updating but not recording in your database. If its 0, that means no problem with ur db, its your query

Biohazard401 Over a year ago

I tested, result is equals to "1"

ajitksharma Over a year ago

then your problem is might with commiting, try session.commit() instead of tx.commit();

|

Charvee Shah · Accepted Answer · 2014-05-24 10:37:51Z

0

Try this.

    public void update()
    {
        try
        {
            Session session = getSession();
            Transaction tx = session.beginTransaction();                

            Query query = session.createQuery("update Nodes set question = 'test updating' where id = 1" );

            query.executeUpdate(); //add this line
            tx.commit();
            session.close();
    }

}

Hope this will help you.

answered May 24, 2014 at 10:37

Charvee Shah

7202 gold badges6 silver badges21 bronze badges

Collectives™ on Stack Overflow

Update query executing but not updating table with hibernate

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related