2 Replies Latest reply on Jan 27, 2005 10:24 AM by Antonio Goodman


    Antonio Goodman Newbie

      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!!!