Hi,Problem In Deleting Row. Plz help

intimate2talent · **Posted:** Mon Apr 23, 2007 7:09 am

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

chucky · **Joined:** Mon Jun 12, 2006 5:33 am **Posts:** 63

Hi intimate2talent ,

use Criteria. Try the following:

Code:

      Criteria crit = session.createCriteria(Book.class);
      List books = crit.add(Restrictions.eq("bookname", "abc")).list();
      
      Iterator it = books.iterator();
      while (it.hasNext()) {
         Book element = (Book) it.next();
         session.delete(element);
      }
      
      

You could also use HQL (closer to SQL).

chucky

Don't forget to rate if this helps
----------------------------

pramodkp · **Joined:** Mon Mar 26, 2007 12:38 am **Posts:** 119

Hi,
As far as I know, you cannot query the session without a primary key. So, here is one way.

for(Object book: session.createQuery("from Book where name = 'bookname'").list() )
session.delete(car) ;

Drawback:
select and delete statements.

Why don't you fire the delete query straight away ? ( as is )
session.createQuery("delete from Book where name = 'bookname'").executeUpdate() ;

----------------------------------------------------
Rate the reply if you find it helpful