1 Reply Latest reply on Mar 26, 2002 11:30 AM by armint

    EJB-QL problem

    ups2000

      JBOSS 3.0 beta2
      CMP2 and defined finder method
      ---
      SELECT OBJECT (a)
      FROM UserBean AS a
      WHERE u.name= ?1
      --

      deploying was OK, however
      Exception while called this finder method
      -------
      9:06:25,170 ERROR [LogInterceptor] TransactionRolledbackException, causedBy:
      ava.sql.SQLException: ORA-00904: invalid column name
      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:180)
      at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
      ------------

      The definition of field "name" in jbosscmp-jdbc.xml is exactly the same as in database.
      May be somebody knows why it fails in runtime?

      Thanks