#82 JBoss 3.0.0 - Support for JBoss-QL

open
nobody
vendor (9)
5
2002-09-20
2002-09-20
Chris Mein
No

After reading the JBoss 3.0.0 CMP documentation it seems that
the mechanism for overriding a finder methods EJB-QL with JBoss-
QL is to provide a correct <query> tag in the jbosscmp-jdbc.xml
file.

I assume that the current @ejb:finder and
@jboss:finder-query tags were designed to allow this type of
configuration to be done simply. However the tags seem to
produce output in the jaws.xml file. This will not work with JBoss
3.0.0. The configuration that is need is:

<query>

<query-method>
<method-
name>findMatchingUsersUserName</method-name>

<method-params>
<method-
param>java.lang.String</method-param>
</method-
params>
</query-method>
<jboss-
ql><![CDATA[SELECT OBJECT(a) FROM User a WHERE
(LCASE(a.username) = LCASE(?1))]]></jboss-
ql>
</query>

Searching through the *.j files in XDoclet
there is no sign of a jboss-ql being produced.

It seems that
either the existing tags need to be changed for JBoss 3.0.0 or a new
tag produced. The jboss:declared-sql seems to have been
intended to do something like this but does not look designed for
JBoss 3.0.0.

Any comments welcome...

Chris
Mein

Discussion