server.log
2003-08-12 16:01:07,579 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery. UpdateEJB.findAll] Executing SQL: SELECT FROM updatetable t0_o 2003-08-12 16:01:07,579 DEBUG [org.jboss.ejb.plugins.cmp.jdbc.JDBCEJBQLQuery. UpdateEJB.findAll] Find failed java.sql.SQLException: ERROR: parser: parse error at or near "FROM" at character 9
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131) at org.postgresql.jdbc1.AbstractJdbc1Connection. ExecSQL(AbstractJdbc1Connection.java:505) at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement. java:320) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement. java:48) at org.postgresql.jdbc1.AbstractJdbc1Statement. executeQuery(AbstractJdbc1Statement.java:153) at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement. executeQuery(WrappedPreparedStatement.java:289)
As you can see from above, findAll produces a SQLException because the SQL Select statement is incomplete. Can you give some ideas/tips that will lead me to solve this problem? I don't know whats causing this problem.
I experienced this problem when my primary key class (in this case a compound primary key) was incompletely generated by xDoclet. Check your primary key class.
-marek
------------------------------------------------------- This SF.Net email sponsored by: Free pre-built ASP.NET sites including Data Reports, E-commerce, Portals, and Forums are available now. Download today and enter to win an XBOX or Visual Studio .NET. http://aspnet.click-url.com/go/psa00100003ave/direct;at.aspnet_072303_01/01 _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
