CMR FIELDS IN JBOSS-3.2.6

[antonio1]

Hi guys!

I need your help !

Early i used jboss-3.0.8 - ms sql 2000 and all works fine!!!
but now i try to update application server to 3.2.6, and have some problem with CMR fields:
everyWhere i used cmr fields i recieved the error:

2005-01-27 00:11:59,677 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCLoadEntityCommand.BookLoan] Executing SQL: SELECT Kod, Name, enumLoanType FROM Loan WHERE (Id=?)
2005-01-27 00:11:59,747 ERROR [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackLocalException in method: public abstract java.lang.String ru.ifirst.holding.core.entity.book.BookLoan.getName(), causedBy:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid column name 'enumLoanType'.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
...


in the debug source select use 3 field, but one of them (enumLoanType) is relation...
why did it happen?

thanks for help!!!

[aloubyansky]

What query was executed in 3.0.8? Do you have a column enumLoadType in the table? Did you create a table or JBossCMP? How do you map this CMR in jbosscmp-jdbc.xml?

[antonio1]

What query was executed in 3.0.8?

i can't see that query now... but i didn't change my source.

Do you have a column enumLoadType in the table?

The table don't have this column, 'enumLoadType' it's relation-field name.

Did you create a table or JBossCMP?

I use JBossCMP

How do you map this CMR in jbosscmp-jdbc.xml?

I used JBuilder9 designer. Today i think that solve my problem:

i have two CMP bean: Loan and LoanType...
i need many to one relation for these entities...
early i create relation from Loan to Loan Type and had my trouble...

Now i tried to create relation from LoanType to Loan and it's working 8-)

i think that it's jbuilder9 bug

what's y opinion?