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. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3954888#3954888 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3954888 Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user