Hi,

I know about session.delete() but I don't want to remove each entry one at a time. How does one delete all entries in a table in one shot? This is known to be much faster in MySQL than individual deletes.

Gili

use JDBC.

Gavin,

So are you are saying that:

1) There is no way to do this in Hibernate code?
2) "delete from X" is portable across all databases?

Thank you,
Gili

And while we're on the same page, I can't seem to find a reference in the FAQ or documentation on how to tunnel raw JDBC updates through an already-opened Hibernate session. Any idea how this would be done?

Gili

1- orm = get object and then do what you want with them, if you don't need to get object, do it in jdbc, that's why orm is not a performant tool for massive delete/update
2- why this question?




http://www.hibernate.org/hib_docs/api/n ... onnection()

javadoc is good

session.connection() gets the underlying JDBC connection. Then use "truncate table myTable" which is portable across most if not all databases.

Thank you all.

Gili