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]
--
This e-mail may contain confidential and/or privileged information. If you are not the
intended recipient (or have received this e-mail in error) please notify the sender
immediately and destroy this e-mail. Any unauthorized copying, disclosure or
distribution of the material in this e-mail is strictly forbidden.
---------------------------------------------------------------------
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]>
