There is a log table in MySQL which needs to be cleared now.However i am not sure how to empty it using hql ?

Of cource it is not applicable to load and delete record one by one.Do i need to use sql instead of hql ?


BTW,
i am using hibernate-2.0.2.


thanks in advance !

Yes, just use some direct SQL.

[quote="gavin"]Yes, just use some direct SQL.[/quote]


would you like showing me how to use direct sql in hibernate ? i really donot want to do as below:
...
sess.connection().createStatement()....

because this way will force me to be table-oriented NOT object-oriented :(


regards!

But hold on: you just expressed your problem as "empty a table" ..... so it is a table-oriented problem, right?


;-)


This is the only way to do it.

public void clearLog() throws OMException
{
try {
Session sess = sf.openSession(); sess.connection().createStatement().execute("delete from log");

sess.close();
}
catch(Exception e) {
throw new OMException(e);
}
}

the code is very simple but the programmer must know the table name,log.

Anyway i can accept it even if i am a pure OO fan :)


thanks !

Given that you're wanting to do a "delete" not a DB specific "truncate" or anything like that, couldn't you just do the following?


Of course, I've not actually ever done that myself, but it would work wouldn't it?

Nah, stolley, that actually loads up each object, since it needs to process cascades, collections, lifecycle callbacks, etc.


One of these days, I might get round to providing an efficient implementation in the case where none of these things exist (thats the only reason i havn't deprecated the method). But last time I thought about it there were conceptual issues....