1 Reply Latest reply on Jan 16, 2003 11:05 AM by Alex Shneyderman

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

    Steve Lu Newbie

      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>