Hai

In Hibernate we are trying to insert data to database in DAO layer of our application my query is

in simple JDBC Program we can make sure that datas are inserted or not by using the ResultSet.executeUpdate() (which will return number of rows updated or deleted for the update and delete operation)

In hibernate program how can i make sure that data i am trying to insert to database is sucessfully inserted or not

In Short "How can i acheive the exectuteUpdate() method functionality of ResultSet Interface in Hibernate" to make sure that my operation is sucessfull

when u r using HQL, then use executeUpdate() on ur Query object.

if u r using Object based data insertion and deletion use save(),delete() and update() methods on session object.

for eg.,
if using HQL.
SessionFactory fact = new Configuration().configure().buildSessionFactory();
sess = fact.openSession();
Transaction tr = sess.beginTransaction();
sess.createQuery("delete from Hosts where hostId = " + new Integer(hid)).executeUpdate();

if Object based.,
Hosts h=new Hosts();
h.setName('Madan');
session.save(h); // insertion

// for deleting host object with id=41;
Hosts hd=(Hosts) session.find(Hosts.class,41);
session.delete(hd);

**) don't forget to commit ur transaction, then only session changes updated to DB.

Hey Madan

Thanks for the Reply :) ur information are helpful for me and i got one more query if i am inserting the data means how can i acheive the executeUpdate() functionlaity


Thanks & Regards
S.Sathiya Moorthy

if u r going to insert new Host information without HQL. then use following tech

Hosts h=new Hosts();
h.setName('Madan'); //
... set the values for new host object
session.save(h);

if u call save(), hibernate use insert query in background for inserting new row into table. if u wanna to explore that set show_sql property to true in hibernate.cfg.xml file.

Or if u going to save new objects throu HQL means.
sess.createQuery("insert into Hosts values('Prabhu',2)").executeUpdate();

when u r calling executeUpdate() from query object it returns number of rows affected by that query.

hi friend if u feel my post helpful for ur solution, Don't forget to rate me.