Paulo Bengero wrote:

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

Reply via email to