Check the (for pay) documentation.
Great. JBOSS is Open Source but Closed Documentation, right?
Well I actually bought the JBoss Administration & Development docs for 2.4.x sometime and all that's in there is info on the architecture and other stuff which seems only of interrest to folks *building* application servers instead of *using* them. Money wasted for me. No EJB-QL or JBOSS-QL stuff in there. I assume the same goes for the newer docs on 3.2.x.
What payed docs would you recommend on JBOSSS-QL then? I don't want to waste money again on internal server docs.
Yes the current version of the Administrators and Developers Guide does contain JBoss-QL information.
Not sure if anyone has added information to the Wiki on this subject yet.
Since 3.2.4 we also now have a new EJBQL compiler that is not documented yet. I'll update the wiki evetually.
In standardjbosscmp-jdbc.xml in the defaults you can see
This is the compiler we have been using so far. You can change it to
in the defaults or even per query like:
<query> <query-method> <method-name>ejbSelectSelect</method-name> <method-params> <method-param>java.lang.String</method-param> <method-param>java.lang.Object</method-param> </method-params> </query-method> <dynamic-ql/> <ql-compiler>org.jboss.ejb.plugins.cmp.jdbc.EJBQLToSQL92Compiler</ql-compiler> </query>
This compiler is EJBQL2.1 compatible and uses INNER and OUTER joins and subqueries. Of course, it won't work with databases that do not support this functionality.