3 Replies Latest reply on Mar 31, 2003 12:20 AM by HunterHillegas

    <query /> in jaws.xml with JBoss3.2

    Jaejun Lee Newbie

      I need to use in jaws.xml with Jboss3.2

      In order to retrieve all rows, I wrote the followin in jaws.xml
      ---

      findAllCorporateCustomers


      <read-ahead>true</read-ahead>

      ---

      but it throws
      ---
      java.sql.SQLException: ORA-00921: unexpected end of SQL command
      ---

      It seems that JBoss3.2 interprete as
      ---
      select * from CoporateCustomer where;
      ---
      rather than(in JBoss2.4)
      ---
      select * from CoporateCustomer;
      ---

      Do you know how to specify where clause to retrieve all
      rows?

      or

      Should JBoss3.2 be fixed ?

      Thank you.