[JBoss-user] finders, postgresql and jboss3.2.0RC1

[Jason Essington]

I have a session bean that has finders defined by xDoclet tags like so:

* @ejb.finder
* signature="java.util.Collection findAll()"
* mapping="Local"
* intf="LocalHome"
* query="SELECT OBJECT(o) FROM ReportWV o"
*
* @ejb.finder
* signature="java.util.Collection findByClientID(java.lang.Integer clientID)"
* mapping="Local"
* intf="LocalHome"
* query="SELECT OBJECT(o) FROM ReportWV o WHERE o.clientID = ?1"

now when I deploy the bean I see in the log:
2003-01-16 17:49:28,264 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ReportWV.findAll] EJB-QL: SELECT OBJECT(o) FROM ReportWV o
2003-01-16 17:49:28,268 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ReportWV.findAll] SQL: SELECT FROM treportwherevalues t0_o
2003-01-16 17:49:28,268 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ReportWV.findByClientID] EJB-QL: SELECT OBJECT(o) FROM ReportWV o WHERE o.clientID = ?1
2003-01-16 17:49:28,351 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ReportWV.findByClientID] SQL: SELECT FROM treportwherevalues t0_o WHERE t0_o.clientid = ?

notice the SQL lines

so of course when I attempt to call one of these finders, all hell breaks loose:

2003-01-16 17:51:28,171 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ReportWV.findByClientID] Executing SQL: SELECT FROM treportwherevalues t0_o WHERE t0_o.clientid = ?
2003-01-16 17:51:28,173 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery.ReportWV.findByClientID] Find failed
java.sql.SQLException: ERROR: parser: parse error at or near "FROM"

at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:123)
at org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:429)
at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:198)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
...
rest of the stack trace hacked off for brevity.

What am I doing wrong that is causing JBoss to generate bad sql?

-jason