I get an error for finder methods with ejb-ql queries of
Type SELECT OBJECT(o) FROM Owner(o).
When I run the client,I get an javax.EJB.FinderException saying that missing expression in finder query.
On further diagonistics,I found that any ejb-ql query consisting of the keyword OBJECT,when translated to sql by JBOSS 3.0 had a missing term between the SELECT and the FROM clause.
for the ejb-ql query below
SELECT OBJECT(o) FROM Owner(o).
JBoss X'lated it to
SELECT FROM tabOwner
Please note :
OWNER is Schema-name
tabOwner is the Table name on which the Query is to be executed.
You want to use the schema name (Owner) in your query. I believe your syntax is a little off and should be
SELECT OBJECT(o) FROM Owner o
SELECT OBJECT(o) FROM Owner AS o
Hope this helps.