2 Replies Latest reply on Oct 6, 2003 1:36 AM by jdijkmeijer

    ejb/jboss-ql select statement

    jdijkmeijer Newbie

      Hi,

      I'm currently trying to implement an findall method (simplest of the simplest) but I cant get it to work allright. It deploys fine, but as soon as I call home.findAll() it fails with the following stacktrace dump:

      javax.ejb.FinderException: Find failed: java.sql.SQLException: Unexpected token: FROM in statement [SELECT FROM SUBJECT t0_s]
      at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:194)

      I have jboss-ql generated by xdoclet:

      <query-method>
      <method-name>findAll</method-name>
      <method-params>
      </method-params>
      </query-method>
      <jboss-ql><![CDATA[select OBJECT(s) from Subject As s]]></jboss-ql>


      It seems that in the generated sql being fired to the server the specification of the select statement is void. So I expect that I'm doing something wrong with column names or so.
      Could somebody help me??
      If desired I can provide the complete ejb-jar, jbosscmp-jdbc files.

      Many Thnx in advance.
      Jeroen