Error: On Column Name

[alexb]

Hello,

I'm using JBoss3.0.3 and Sybase 11.0.3.3, also using MSSQL 7.0 everything deploys using both database's.....

When I run the client to retrieve an entity bean it works fine but when I try to create an entity bean I get this error.....

15:44:23,432 ERROR [BidItem] Could not create entity
com.sybase.jdbc2.jdbc.SybSQLException: Column name company_no appears more than once in the result column list.

Has anyone seen this error before or has a clue how to fix this thanks in advance
Alex

[scoy]

This is an FAQ :-)

I'll bet you're trying to use CMR and your CMR attribute has a <cmp-field> element in your ejb-jar.xml file?

Don't do that.

Steve

[alexb]

My code deploys and works fine on weblogic so if its an cmr with a cmp-field as the same name would this still deploy.....

[scoy]

It's my understanding of the spec that you have one or the other. Check out section 10.3.1.

If this is indeed what you have done, then it may be a weblogic extension (or bug).

Steve