Re: Torque/Village issues selects without bind variables on MyPeer.doDelete(criteria)?

2007-09-25 Thread Brendan Miller
Thomas Fischer 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 > stat

Re: Torque/Village issues selects without bind variables on MyPeer.doDelete(criteria)?

2007-09-25 Thread Thomas Vandahl
Brendan Miller wrote: > If there's still a better way, I'd love to hear about it. There is BasePeer.deleteAll() which bypasses Village when deleting records. However, you will need to have a single column which has a single value (IOW: a primary key) for this to work. > Does Torque/Village always

Re: Torque/Village issues selects without bind variables on MyPeer.doDelete(criteria)?

2007-09-25 Thread Thomas Fischer
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 p

Torque/Village issues selects without bind variables on MyPeer.doDelete(criteria)?

2007-09-25 Thread Brendan Miller
I have a table that has no true primary key at the database (Oracle) layer. The only way for me to find a row is to use criteria. I am trying to delete this row. I have Criteria criteria = new Criteria(); criteria.add(FIELD_A, value_a); criteria.add(FIELD_B, value_b); criteria.