Hi All,
does the current status of Castor JDO-OQL support set-construction and
comparison like this:
"SELECT product FROM foo.Product product WHERE product.categories =
set(cat1, cat2, cat3)" ?
Object "Product" has a "java.util.Set" of "Category". The corresponding
tables have many-to-many-relationship. I am just starting on OQL but I
think comparisons as the one above are basically supported. From the
castor-documentation I can't figure out, if Castor JDO-OQL (which is
currently in status 3) already supports this.
Using oracle as database the statement transfers to:
[Castor] SELECT "PRODUCT"."ID","PRODUCT_CATEGORY"."CATEGORY_ID" FROM
"PRODUCT_CATEGORY","PRODUCT" WHERE
"PRODUCT"."ID"="PRODUCT_CATEGORY"."PRODUCT_ID"(+) AND
("PRODUCT"."CATEGORY_ID" = set('cat1' , 'cat2' , 'cat3'))
java.sql.SQLException: ORA-00936: Missing Expression
which implies, that it is not supported but maybe I am using wrong
syntax?
Thanks.
Enrico
-----------------------------------------------------------
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
unsubscribe castor-dev
