James Robinson wrote:
Howdy:
Java middlewares like JBossCMP issue many queries in the general
form of:
SELECT t1.att1, t1.att2 ... t1.attN FROM t1 WHERE (t1.id = X) or
(t1.id = Y)
where there may be anywhere between 1 and thousands of "(id = N)" blocks
ORed together.
2)
Oliver Jowett wrote:
The CMP layer could perhaps use the = ANY array syntax and setArray()
(note that setArray() in the current driver needs fixing, I have an old
patch to do this):
SELECT t1.attr1 FROM t1 where t1.id = ANY (?)
Unfortunately a bit of experimentation indicates that the
