cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zack Angelo" <z...@nostromocorp.com>
Subject Cocoon generated Java throwing SQLException
Date Thu, 02 May 2002 02:54:58 GMT
Hey,

I'm having some really peculiar behavior with the ESQL logicsheet. I
have the following XSP (in my own logicsheet):

<esql:query> select ID,count(ID) as count from Users where
LoginUser='zack' and Password='password' group by ID</esql:query>

The corresponding Java seems to be generating just fine: 

_esql_query = new EsqlQuery( _esql_connection, String.valueOf("select
ID,count(ID) as count from Users where LoginUser='zack' and
Password='password' group by ID") );

But, upon execution, I get this exception:

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.RuntimeException: Error
executing statement: select ID,count(ID) as count from Users where
LoginUser='zack' and Password='password' group by ID:
java.sql.SQLException: Column not found: Unknown column 'LoginUser' in
'where clause'

For some reason it's saying that one of the columns doesn't exist...I
have no idea why. I've also copied and pasted the SQL query from the
Java into the mysql client, and it works fine. Any ideas? This just
seems really strange to me. Thanks in advance.

-Zack Angelo
 Nostromo Corporation




---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail: <cocoon-users-help@xml.apache.org>


Mime
View raw message