I forgot: See below ........
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:error-results> The erro is: <esql:get-message/> </esql:error-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]>
