Keith Chew wrote:
> 
> Hi
> 
> Is there a way in Castor to remove all records in a table? ie an equivalent
> SQL: "DELETE FROM USER_TABLE;"?
> 

Keith,
I would do this: 

db.getOQLQuery( "select u from userTable u" );
...
while ( results.hasMore() )
{
    user = ( User ) results.next();
    db.remove( user );
}
-- 
+------------------------------+
| Bruce Snyder                 |
| [EMAIL PROTECTED]              |
+------------------------------+

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev

Reply via email to