Hi

Greetings!

Could anybody help me out for following query.

By running below code i m being able to delete the row where bookid=12.

long bookid = 12;
Session sess = HibernateFactory.currentSession();
Object book = sess.load(Book.class, bookid);
sess.delete(book);

now i want to delete the row based on any other column of the table which is not the primary key for that table.

Like could u get me the code for below query in the same way..

delete from tablename where bookname="abc";

Note:-Bookname is not the primary key.


Thanks.

With Regards
Saurav Jain

Something like this should help

Query query = sess.createQuery("from Book as b where b.bookName = ?");
query.setParameter(0, "abc", Hibernate.STRING);
List result = query.list();
Object book = result.get(0);
sess.delete(book);