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
Instead of u.name = ?1 use a.name = ?1. That may fix the problem.
Also, to see the sql statement turn on debug in log4j.xml.