I know that including <esql:error-results> in <esql:connection> prevents from throwing exceptions. The problem is that if the database is unreachable the RuntimeExceptions is throw by esql and this one is not caught by errors-results. So if you want to manage all esql errors you should do sth like:
<xsp:logic> try { <esql:connection> <esql:pool>cdn</esql:pool> <esql:execute-query> <esql:query>select * from foo</esql:query> <esql:results> <esql:row-results> <row> <esql:get-columns/> </row> </esql:row-results> </esql:results> <esql:no-results> <info>no results<info> </esql:no-results> <esql:error-results> <error>query error</error> </esql:error-results> </esql:execute-query> </esql:connection> } catch ( RuntimeException e ) { <error>database error</error> } </xsp:logic> so you're not able to catch all errors without using additional Java code. Is there any way to handle it more nicely? ouzo -- __ | / \ | Leszek Gawron // \\ \_\\ //_/ [EMAIL PROTECTED] _\\()//_ .'/()\'. Phone: +48(600)341118 / // \\ \ \\ // recursive: adj; see recursive | \__/ | --------------------------------------------------------------------- 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]>