You can view the tutorials best in Google Chrome, Mozilla Firefox, Opera, higher version of Internet Explorer

Part 6 Hibernate Query Language, HQL Update,Delete Queries

Hibernate » On Jul 10, 2011 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)

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

 

Let Us See An Example On HQL DELETE

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

Product.java

Product.hbm.xml

hibernate.cfg.xml

ForOurLogic.java

Notes:

  • 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.java, Product.hbm.xml, hibernate.cfg.xml are similar to previous hql program (HQL part 5), so am directly writing the code for ForOurLogic.java

ForOurLogic.java

Notes:

  • 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

download-hibernate-source-code-for-hql-delete-query
Source code for HQL update

download-hibernate-source-code-for-hql-update-query





By [ Java/J2EE Developer & Web Designer ]
Founder of Java4s.com - Indian, lives in United States. You can contact me at sivateja [at] java4s.com
Follow me on


Comments

11 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:

    @Raju
    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. Revan says:

    Good Job !!!!!!!!

  9. 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

  10. Muskan says:

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

Name*
Mail*
Website



By posting your answer, you agree to our comments policy.
Most Recent Tutorials
Hibernate Recent Posts
Spring Recent Posts
Struts Recent Posts
Recomandded Links
Current & UpComing Tutorials
Sitemap :
spring Hibernate struts Json Ajax Log4j Log4j coreJava Servlets Web Services


Upcoming
  Web Services [ In Progress ], JSP
Facebook_Java4s  Twitter_Java4s  GooglePlus_Java4s  Youtube_Java4s 
© 2010 - 2014 Java4s - Get It Yourself.
The content is copyrighted to Sivateja Kandula and may not be reproduced on other websites.