Re: Raw delete

2010-10-20 Thread Michael Gentry
I've done this in the past: QueryChain chain = new QueryChain(); // Add raw SQL templates to the chain. chain.addQuery(new SQLTemplate(Customer.class, "DELETE FROM Customers")); chain.addQuery(new SQLTemplate(Item.class, "DELETE FROM Items")); chain.addQuery(new SQLTemplate(L

Raw delete

2010-10-20 Thread brd
Hello all, Whats the better way to do a regular delete from in raw sql? I tried a raw sql named query on the modeler but i get a Null PK error, maybe because no data rows are returned? Thank you