This content has been marked as final.
Show 2 replies
-
1. Re: What is wrong with my ejb-ql????
askesis Jan 2, 2006 8:22 AM (in response to askesis)An addition: could it have anything to do with the fact the "article" is a CMR field (for which the table in which the StockArticles are stored has a column "article")?
TIA
Joost -
2. Re: What is wrong with my ejb-ql????
askesis Jan 2, 2006 11:47 AM (in response to askesis)I have found the sollution of my problem. An ejb-ql query is (obvious??) not in terms of table.column but in terms of object.attribute. So the correct query is:
* @ejb.finder signature = "nl.muntpost.interfaces.StockArticle findByArticle(java.lang.String article)" * query = "SELECT OBJECT(c) FROM StockArticles AS c WHERE c.article.objectId = ?1 "