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

Reply via email to