Hi. I'm using Hibernate 3.0alpha and I'm a new to using Hibernate in general. Please excuse me if this is a FAQ. I looked around and haven't been able to find the answer so far. I'm trying to figure out how to delete all rows in a table.

It appears that this can be done using org.hibernate.classic.Session.delete(String query) to do this, but, this method is deprecated. It says in the API specification to use createQuery() to do this, but, I don't know how.

The other question that I have is, how to delete a Collection of objects? Do I have to iterate through the Collection and call delete() for each object? I was thinking that maybe I could just do a query for all rows in the table and then do a List.clear() and maybe it would delete the rows automatically...

BTW, I know how to do it the following way, I just want to know to do it without having to revert to using SQL...

Session s = sf.openSession();
PreparedStatement ps = s.connection().prepareStatement("TRUNCATE TABLE project");
ps.executeUpdate();

createQuery().delete()

Thanks but I'm not able to find a Session.createQuery() method (no args) or a Query.delete() method. Maybe these are new and aren't in hibernate-3.0alpha?

Why are you using the alpha?

Why not use the alpha?

Because you don't use testing versions of a software you'd like to learn?

The reason I'm using hibernate3 is because I want to get a heads up on how to do things in the new version. I've been using both hibernate2 and hibernate3 and I noticed that a lot of the APIs are deprecated in the new version, so, I'm glad that I decided to have a look at it.

BTW, you never answered the question at hand.