What is your original ejb-ql statement as it appears in ejb-jar.xml?
> -----Original Message----- > From: Paulo Bengero [mailto:[EMAIL PROTECTED] > Sent: Tuesday, August 12, 2003 10:27 AM > To: [EMAIL PROTECTED] > Subject: [JBoss-user] CMP Deployment: findAll has incomplete SQL > Statement > > > 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(AbstractJd bc1Statement. > java:320) > at > org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJd bc2Statement. > 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. > > ************************************ > Paulo A. Bengero > Application Systems Engineer > Team ORION > ************************************ > > ------------------------------------------------------- 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
