Try changing ur esql snippet to following, <esql:connection> <esql:pool>users</esql:pool> <esql:execute-query> <esql:query>select * from users</esql:query> <esql:results> <table> <esql:row-results> <tr> <td><esql:get-string column="username"/></td> <td><esql:get-string column="password"/></td> </tr> </esql:row-results> </table> </esql:results> </esql:execute-query> </esql:connection>
HTH --Amir -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: August 16, 2002 1:36 PM To: [EMAIL PROTECTED] Subject: ESQLcompile error: page must catch or throw exception Hi All, I've got an XSP that uses (or rather, is TRYING and FAILING to use) the ESQL logicsheet. When trying to access the page, Cocoon shoots back an error page, the stack trace being: org.apache.cocoon.ProcessingException: Language Exception: org.apache.cocoon.components.language.LanguageException: Error compiling sample1_xsp. Line 421, column 58: method valueOf() not found in class java.lang.String Line 589, column 51: unreported exception: java.sql.SQLException; must be caught or declared to be thrown Line 598, column 27: unreported exception: java.sql.SQLException; must be caught or declared to be thrown Below are the ESQL tags, plus the namespace declarations. <xsp:page language="java" xmlns:xsp="http://apache.org/xsp"; xmlns:esql="http://apache.org/cocoon/SQL/v2";> .... ommitted some stuff for clarity... <esql:connection> <esql:pool>users</esql:pool> <esql:execute-query>select * from users</esql:execute-query> <esql:results> <table> <esql:row-results> <tr> <td><esql:get-string column="username"/></td> <td><esql:get-string column="password"/></td> </tr> </esql:row-results> </table> </esql:results> </esql:connection> ... Any and all solutions most gratefully accepted Using Cocoon 2.0.3 MySQL JDK 1.3.1 WindowsXP and Unix --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
