Part 6 Hibernate Query Language, HQL Update,Delete Queries

Hibernate » on Jul 10, 2011 { 20 Comments } By Sivateja

so far we have been executed the programs on Hibernate Query Language (HQL) select only, now we will see the DML operations in HQL like insert, delete, update., you know some thing..? this delete, update query’s are something similar to the select query only but insert query in Hibernate Query Language(HQL) is quite different, i will let you know while we are going to execute the program on HQL insert, for now let us see an example on delete, update queries

Remember.., while we are working with DML operations in HQL we have to call executeUpdate(); to execute the query, which will returns one integer value after the execution, will discuss more on this later..

files required.. (for both delete, update query’s)

  • (POJO class)
  • Product.hbm.xml
  • hibernate.cfg.xml
  • (Our logic)


Let Us See An Example On HQL DELETE

Actually, Product.hbm.xml and hibernate configuration files are some for both logics




  • see line number 17, i have been used label to pass the value at run time, and nothing to explain more in this…. what do you say ;)

Database Output Before Execution

Run the program in eclipse

Eclipse console

Database Output After Execution

Let Us See An Example On HQL UPDATE

Mates,, Product.hbm.xml, hibernate.cfg.xml are similar to previous hql program (HQL part 5), so am directly writing the code for


  • update query written in line number 17,  here i am going to set value in run time by using question mark symbol in the query, that’s it.

Database Output Before Execution

Run the program in eclipse

Eclipse Console

Database Output After Execution

And that’s it ………………..   ;)

Source code for HQL delete

Source code for HQL update


You Might Also Like

  ::. About the Author .::

- Full Stack Java/J2EE & UI Web Developer
Founder of Java4s - Get It Yourself, A popular Java/J2EE Programming Blog, Love Java and UI frameworks.
You can sign-up for the Email Newsletter for your daily dose of Java tutorials.


20 Responses to “Part 6 Hibernate Query Language, HQL Update,Delete Queries”
  1. Raju says:

    Actually you are told that every DML operations are performed in presence of session only ok thats fine but when the time of using HQL update,delete you are not used any transaction how it will work please explain me.

    Thank you in advance.

  2. Mohammed Vaseem says:

    Excellently Analyzed…
    We have to use Transaction and has to say transaction.commit().
    then only database modifications will be done.
    In the above program, no deletion of the entities in the database is happening coz we are just querying but not commiting… when commiting only, modifications will be done and be saved into the database.

  3. Java4s says:

    @Raju, @Vaseem

    Raju am very sorry for giving late reply, we thought its better to wait until we know the exact answer.

    Actually am checking the same with my friends as well.
    As we said, modifications wont be effected until we say commit, but i guess it got committed.

    I think transactions is mandatory for DMLs. Even i mailed the same to hibernate forums but no response from them.

    Any ways vaseem can you check with/with out transaction and check the database and conform once ?

  4. Mohammed Vaseem says:

    When i checked with out transaction and did not say tx.commit(), then in the console of the program it has shown that database is updated but when checking in database, database was not updated. This means query is executed but not committed.

    When i checked with Transaction and used tx.commit(),then the value is updated in the database. nothing but query is executed and as well committed.

    I can say that if we want to update any values in the database we must has to use transaction and has to use tx.commit(), then only the values will be updated or else not.

  5. Mohammed Vaseem says:

    Hello java4s,
    Thanks for sharing this much of valuable information with all…
    As a user, I has to get all the updated information very easily. So I request to maintain a separate web page for “What readers are saying” option so that i can easily find the happening updates very easily…
    Thanks again..

  6. Java4s says:

    @ Vaseem
    Oops some thing what we expected :-)

    Thank for the conformation.

  7. Kiran says:

    Hi all i got the same problem Not updating at database side when i coded without committing transaction for delete or update. i think trnx.commit() ; is needed. I wish you all keep experimenting and letting others know them.

  8. Master says:

    In above example we have passed value as updated.. but in screenshot only 1 dot is being displayed. Will there be 2 dots or 1 dot only

  9. Muskan says:

    how to delete record without providing id no. (like here 110)……..

  10. rashid says:

    Hi java4s please help me
    can you please explain me how to insert 5 records or some records at a time by using insert query.
    and in insert query we writing like this insert….table_name + select….table_name both the table name should same or different

  11. srinivas says:

    Good Analysis…!!

  12. Ashok Kumar says:

    DML delete and update not work on my system.

  13. Alok singh says:

    Hi java4s,
    In class two lines are missing, without these lines code is not able to delete or update in database table
    Transaction tx=session.beginTransaction(); // missing
    int res=query.executeUpdate();
    tx.commit(); // missing

    Alok singh

  14. Ganesh says:

    Nice example but without transaction we cannot perform any DML operations.

  15. Murali says:

    Hello Friends…!
    I observe..
    Without Transaction and without commit also delete and update are successfully working on database…that I am sure…
    need more explanation on this concept…
    thank you

  16. Mujeeb says:

    HQl Update i’m getting this message in connsole

    Exception in thread “main” java.lang.IllegalArgumentException: node to traverse cannot be null!

    Configuration cfg=new Configuration();

    SessionFactory sf=cfg.buildSessionFactory();
    Session ses=sf.openSession();
    Transaction ts=ses.beginTransaction();

    String hql = “update Pojo set Name=’ghjf’ where Id=’335′”;

    Query q =ses.createQuery(hql);
    int i = q.executeUpdate();
    System.out.println(“Command successfully executed….”);
    System.out.println(“Numer of records effected due to update query “+i);

  17. Mujeeb says:

    Showing message in hql update
    Exception in thread “main” java.lang.IllegalArgumentException: node to traverse cannot be null!

  18. something is wrong,,,whichever demo i m trying ,I am getting exception of "connection not open"..please help me


By posting your answer, you agree to our comments policy.
Most Recent Posts from Top Categories
Hibernate Spring Struts
Contact | About Us | Privacy Policy | Advertise With Us

© 2010 - 2018 Java4s - Get It Yourself.
The content is copyrighted to Sivateja Kandula and may not be reproduced on other websites.