How do I delete an entire table?

otseng · **Posted:** Mon Dec 15, 2003 2:25 pm

How can I do something like:
"delete from shopping_cart"

Where I can just do a single database call to delete everything?

kinjaboy · **Posted:** Mon Dec 15, 2003 2:32 pm

Hi,

You could get the connection object from your session, and execute your delete statement.

otseng · **Posted:** Mon Dec 15, 2003 2:38 pm

I was looking at the code of Session.delete(query). And it seems like it first queries all the objects that match the query, then individually deletes each object. I have a rather large table, and I'd rather not delete each row individually.

kinjaboy · **Posted:** Mon Dec 15, 2003 4:49 pm

Hi,

You could do something like this:

Code:

try {
    Connection conn = session.connection();   
    Statement stmt = conn.createStatement();
    stmt.execute("delete from myTable");
} catch (SQLException se) {
    ...
}

hope this helps

otseng · **Posted:** Mon Dec 15, 2003 5:14 pm

I guess I might have to resort to doing it this way since I don't see a way in Hibernate to do it.

emmanuel · **Posted:** Tue Dec 16, 2003 5:09 am

Hibernate have to load your objects first for many reasons includiong cascade stuff etc...
The best solution for you is to use plain JDBC

otseng · **Posted:** Tue Dec 16, 2003 9:31 am

Alright, thanks.

drj · **Posted:** Wed Dec 17, 2003 1:21 am

session.createSQLQuery() ?