How do I execute the following statement in hibernate?

wei7777wei

String sql = "DELETE FROM item WHERE (i_id <> (SELECT MIN (i_id) AS i_id"
+ "FROM item t1 WHERE item.i_link = t1.i_link))";

How do I execute the following statement in hibernate3?

虫子fred

Is it session.createSQLQuery (sql)

alllost

Session session = (SessionFactoryImpl) factory) .openSession ();
PreparedStatement pstmt = ((SessionImpl) session) .getBatcher (). PrepareStatement (sql);
pstmt.execute ();

wei7777wei

I tried the method upstairs, the returned int is correct, but it was not deleted in fact, and the database is also locked