This content has been marked as final.
Show 1 reply
-
1. Re: EJB-QL query
konstantinidis May 13, 2004 11:48 AM (in response to nacho2004)Hi,
subqueries are not supported in EJB-QL or JBossQL.
You can use non-standard JBoss DeclaredSQL.
In Bean Catparents you write
@ejb.finder
query = "" <-- needs to be empty
signature = "Collection findByXXX()"
@jboss.Declared-SQL
alias = "A"
where = "<your WHERE-clause>" (With Database-Fields instead of
BeanFields)
signature = "Collection findByXXX()"
In this case you would get a collection containing all Catparents entities fitting your selection.
look at http://xdoclet.sourceforge.net for further details on the tags. Also look at the JBoss Docs for some skin-deep info.