Truncate Tables

MikeyJudd · **Joined:** Mon Oct 06, 2008 10:40 am **Posts:** 12

Hibernate Version: Unknown
Database: Oracle

I am looking into how to truncate a table through a session call.

I have tried:

Code:

session.createQuery("DELETE FROM TableName").executeUpdate();

And also replaced DELETE with TRUNCATE. I keep getting "TableName is not mapped."

I would greatly appreciate any help on this. Thanks!

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

Well ... is TableName mapped?
BTW, truncate is not allowed. AFAIK.

Check your hibernate.cfg.xml, your code, or wherever you map tables to classes.
On your database side, check if there could be a privileges or schema naming problem.