i"m sorry about the HTML text, didn't even realize it was enabled.
Here's my XSP code:
<esql:connection>
<esql:pool>mySql</esql:pool>
<esql:execute-query>SELECT ID,Date,Status from
Messages</esql:execute-query>
<esql:results>
<messages>
<esql:row-results>
<message>
<id> <esql:get-long
column="ID"/> </id>
<datetime> <esql:get-date
column="Date"/> </datetime>
<status> <esql:get-string
column="Status"/> </status>
<fetchurl> not yet implemented
</fetchurl>
</message>
</esql:row-results>
</messages>
</esql:results>
</esql:connection>
Here's the Java that's throwing (or not throwing) the exceptions:
Line 397, column 58: method valueOf() not found in class java.lang.String
_esql_query = new EsqlQuery( _esql_connection, String.valueOf() );
Line 508, column 82: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
XSPObjectHelper.xspExpr(contentHandler,_esql_query.getResultSet().getLong(
"ID"));
Line 535, column 82: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
XSPObjectHelper.xspExpr(contentHandler,
_esql_query.getResultSet().getDate("Date"));
Line 562, column 84: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
XSPObjectHelper.xspExpr(contentHandler,
_esql_query.getResultSet().getString("Status")
Line 613, column 51: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
_esql_query.setKeepGoing( _esql_query.nextRow() );
Line 622, column 27: unreported exception: java.sql.SQLException; must
be caught or declared to be thrown
_esql_query.nextRow()
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
