Try this tag:
<esql:error-results>
The error is: <esql:get-message/>
</esql:error-results>
Antonio Gallardo
El Mi�rcoles, 16 de Octubre de 2002 06:51, Michael Edge escribi�:
> Could anyone shed some light on what happens to the Cocoon connection pool
> when the database it depends on is shutdown and then restarted. I expect an
> exception to be thrown as the connections are invalid, and though I don't
> explicitly catch it using esql:error-results in my XSP page, I expect that
> this exception should appear somewhere; perhaps in a log file or returned
> as part of the XML generated by the XSP. However, if my database has been
> shutdown and then restarted, the XSP below returns <tradingbook>Sorry, no
> trading book results!</tradingbook>. I have to restart Tomcat to get it
> working again.
>
> <tradingbook>
> <esql:connection>
> <esql:pool>mosaic</esql:pool>
> <esql:execute-query>
> <esql:query>SELECT distinct
> vm_tradingbook_id as tradingbook_code, tradingbookname FROM
> V_TRADINGBOOK_VM order by 2</esql:query> <esql:results>
> <esql:row-results>
>
> <tradingbookcode><esql:get-string
> column="tradingbook_code"/></tradingbookcode> <tradingbook><esql:get-string
> column="tradingbookname"/></tradingbook> </esql:row-results>
> </esql:results>
> <esql:no-results>
> <tradingbook>Sorry, no
> trading book results!</tradingbook> </esql:no-results>
> </esql:execute-query>
> </esql:connection>
> </tradingbook>
>
> Regards
>
> Michael
>
> -----------------------------------------------
> Michael Edge
> Global Markets Technology
> Institutional Client Group
>
> Phone: +44 (0) 20 7545 3204
> Fax : +44 (0) 20 7545 1559
> Internet email: [EMAIL PROTECTED]
---------------------------------------------------------------------
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]>
