I use Oracle 9i Database and try to deploy a very simple Entity EJB having a "findAll()" method in JBoss 3.2.0, but I face a error below:
Error compiling EJB-QL statement 'SELECT OBJECT(p) FROM POWER p'; - nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "POWER" at line 1, column 23.
Do I need do more configuration with the database?
Please give me some idea. Thank you.
query="SELECT OBJECT(p) FROM Power as p"
Where power has to be schema name not the table name.
I hope this helps.