Can ejb-ql do select from tables and abstract-schema

[dahan]

Here is the dd where abc is an abstract schema but XYZ is a table name. Can I do this? Do I have to define an entity bean for the table XYZ?

Thanks for your input.

<query-method>
<method-name>findByXXX</method-name>
<method-params>
<method-param>java.lang.String</method-param>
</method-params>
</query-method>
<ejb-ql><![CDATA[
SELECT OBJECT(s)
FROM abc s, XYZ r
WHERE s.Val = ?1 and s.Id = r.Id

]]></ejb-ql>

[h2o_polo]

nope. It is in the spec (page 219).

i am not sure if jboss-ql circumvents that.