2 Replies Latest reply on Nov 7, 2003 8:41 AM by Phil Shrimpton

    incorrect sql statements in jboss3.2.2

    Sven Baumgarten Newbie

      I deployed my application which runs fine on 3.2.2.RC2 to 3.2.2. If I access cmp entity beans I get some sql exception because of statements like "SELECT FROM...". I compared the generated statements with that from jboss3.2.2.RC2.

      an example:

      I have an entity bean with 3 persistent attributes A,B,C (columns A,B,C in table T). Now I instanciate the entity read the attributes. jboss3.2.2.RC2 generates the following statement:

      SELECT A,B,C FROM T WHERE...

      jboss3.2.2 does this:

      SELECT A,C FROM T WHERE...

      and when I call getB():

      SELECT FROM T WHERE...

      I can't explain myself why this happens. It happens only for some entity beans not for all but there is no difference between the beans. They have alle the same architecture.

      Has anyone a suggestion how to solve this problem?

      regards
      Sven