1 Reply Latest reply on Jul 10, 2008 3:44 PM by sfisque

    ORA-00904 Error while running CMP EJB

    kamra

      When I am running my CMP bean, I get following error,

      2006-07-02 09:58:17,171 DEBUG org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.AccountBean#fi ndByAccountNumber] Executing SQL: SELECT t0_a.ACCOUNT.UOID FROM ACCOUNT t0_a WHERE (t0_a.ACCOUNT.ACCOUNT_NUMBER = ?)

      2006-07-02 09:58:17,250 ERROR [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.AccountBean#fi ndByAccountNumber] Find failed java.sql.SQLException:
      ORA- 00904: "T0_A"."ACCOUNT"."ACCOUNT_NUMBER": invalid identifier.

      Why is it giving invalide identifier? the length of this identifer is also less then 30 and there are no special characters being used in it.

        • 1. Re: ORA-00904 Error while running CMP EJB
          sfisque

          i am having a similar issue.

          i appears that the "name" attribute of my @Column annotation is being ignored and the query is being constructed using the attribute's name and not the name assigned from the annotation.

          is there a common reason why JPA/Hibernate would ignore the annotation's name attribute and just reflect the field name as the column name?

          == s