db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Fischer <tfisc...@apache.org>
Subject Re: Torque/Village issues selects without bind variables on MyPeer.doDelete(criteria)?
Date Tue, 25 Sep 2007 20:28:29 GMT

On Tue, 25 Sep 2007, Brendan Miller wrote:

> ...
> Anyone have any ideas on how to delete the row/object without incurring
> this SELECT without bind variables query?

Knowing this is the worst statement for a OR layer: If it is just this 
single table, I'd recommend using pure jdbc for creating a prepared 
statement and issuing the delete.
Torque is a bit bitchy when it has not got any primary keys on tables...

> ...
> Does Torque/Village always do a SELECT first before it DELETEs?

currently yes.

     Thomas

---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message