2 Replies Latest reply on Jul 15, 2002 6:55 PM by Dain Sundstrom

    Bad sql generated for finder methods

    sergiu sergiu Newbie

      Hi,
      I'm having big problems making a simple findBy... method work for my EJB application. The cause is the sql generated by JBoss. He generates sql's like:
      "SELECT FROM benutzer WHERE " for a findByPrimaryKey
      "SELECT FROM benutzer WHERE LOGIN_KENNUNG=? " for findByLoginKennung
      "SELECT FROM benutzer " for findAll
      I have tried to declare EJB-QL statements for the finder, but nothing changed.
      The attached file containes a part of the jboss log file.
      Does somebody knows a reason for this?

      Sergiu