incorrect sql statements in jboss3.2.2

[baumgarten]

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

[baumgarten]

I have analysed the problem a little bit more and I found out that the problem occurs by entity beans with more than 62 attributes/columns. The SELECT statement only contains the first 62 columns of the entity. Calling the getters of the 63 attribute/column an new (incorrect) SELECT statment is created that contains no columns.

Is this a configuration problem?

regards Sven

[pshrimpton]

Its a known problem, that I think has been fixed in CVS