Hibernate Delete Query
In this lesson we will show how to delete rows from the
underlying database using the hibernate. Lets first write a java class to delete
a row from the database.
Create a java class:
Here is the code of our java file (DeleteHQLExample.java),
which we will delete a row from the insurance table using the query "delete from Insurance insurance where id = 2"
Here is the code of delete query: DeleteHQLExample.java
package roseindia.tutorial.hibernate;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.Configuration;
public class DeleteHQLExample {
/**
* @author vinod
Kumar
*
* http://www.roseindia.net Hibernate
Criteria Query Example
*
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
Session sess = null;
try {
SessionFactory fact = new
Configuration().configure().buildSessionFactory();
sess = fact.openSession();
String hql = "delete from
Insurance insurance where id = 2";
Query query = sess.createQuery(hql);
int row = query.executeUpdate();
if (row == 0){
System.out.println("Doesn'
t deleted any row!");
}
else{
System.out.println("Deleted
Row: " + row);
}
sess.close();
}
catch(Exception e){
System.out.println(e.getMessage());
}
}
}
|
Download this code.
Output:
| log4j:WARN No appenders
could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Hibernate: delete from insurance where ID=2
Deleted Row: 1
|
| 
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Current Comments
16 comments so far (post your own) View All Comments Latest 10 Comments:I am new to Hibernate and this tutorial found it quite handy otherwise.
Posted by Anjana on Thursday, 08.14.08 @ 15:25pm | #72815
After googling a lot I found a better way to delete a record:
long contactid = 3;
Object contact = sess.load(Contact.class, contactid);
sess.delete(contact);
Posted by Anjana on Thursday, 08.14.08 @ 15:23pm | #72814
Hi
Actually above example is not woking. you have to modify code as follows
SessionFactory sessionFactory = new Configuration().configure().buildSessionFactory();
session =sessionFactory.openSession();
Transaction tx = session.beginTransaction();
List insurance = session.createSQLQuery("select * from insurance ins where Id='2'").addEntity("ins", Insurance.class).list();
Insurance insuranceObject = null;
if(it.hasNext())
{
insuranceObject = (Insurance) it.next();
System.out.println("ID: " +
ct.getLngInsuranceId());
System.out.println("Name: " + insuranceObject.getInsuranceName());
}
session.delete(insuranceObject);
tx.commit();
Posted by pramod on Wednesday, 07.30.08 @ 16:44pm | #69975
If we write down the HQL in HQL editor(in MyEclips) how to transfer it in java class
Tanks 4 all and roseindia site
Posted by manjula on Wednesday, 05.14.08 @ 14:13pm | #59784
this tut is good...keep it up
Posted by aditya on Friday, 05.9.08 @ 13:23pm | #59007
hibernate3 jar interface Query is having method 'executeUpate' and in example we are using 'executeUpdate'. And while executing Delete process I am getting exception
log4j:WARN No appenders could be found for logger (org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
java.lang.NullPointerException
at org.hibernate.hql.antlr.HqlSqlBaseWalker.path(HqlSqlBaseWalker.java:2193)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:2281)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2232)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:498)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.deleteStatement(HqlSqlBaseWalker.java:276)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:156)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:414)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:814)
at org.hibernate.impl.SessionImpl.executeUpdate(SessionImpl.java:801)
at org.hibernate.impl.QueryImpl.executeUpate(QueryImpl.java:89)
at roseindia.tutorial.hibernate.DeleteHQLExample.main(DeleteHQLExample.java:23)
null
Can you please help me in this error.
Posted by Abhi on Thursday, 05.8.08 @ 12:15pm | #58891
A lots thanks to Roseindia for this tutorial, but on execution I've:
NULL
and no change in my database.
Then I've addded the "Transaction instructions" and I've changed the "hql" String in:
delete Insurance where id = 2
and on execution I've:
Hibernate: delete from INSURANCE insurance0_ where (id=2)
Exception in thread "main"
org.hibernate.exception.SQLGrammarException: could not execute update query
....
Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insurance0_ where (id=2)' at line 1"
Where i wrong?
Posted by magister on Thursday, 04.17.08 @ 14:35pm | #56788
this example doesn't work properly..you must use transaction..
Transaction tx = sess.beginTransaction();
tx.commit();
Posted by Magicman on Friday, 03.21.08 @ 14:14pm | #53569
HIbernate tutorial for validating a jsp form
Posted by rajesh on Wednesday, 02.20.08 @ 15:59pm | #49202
A lots thanks to Roseindia for the beginner tutorial on hibernate & swing...
Dayal
Posted by Dayal Manna on Monday, 02.18.08 @ 17:29pm | #48892