hi max,
no, ojb does not support this proprietary extension for the in clause.
in the current trunk (ojb 1.1) the handling of expressions has been
improved so, the StringIndexOutOfBoundsException should be gone.
jakob
Max Vesely schrieb:
Hello,
Oracle and DB2 allow multiple columns to be used
Hello,
Oracle and DB2 allow multiple columns to be used for IN predicate in where
clause. I can construct a query like this SELECT * FROM CUSTOMER C WHERE
(C.STATE, C.CITY) IN (SELECT L.STATE, L.CITY FROM LOCATIONS L WHERE
L.COUNTRY='USA') to retrieve a list of customers located in the same sta