cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Antonio Gallardo Rivera <agalla...@agsoftware.dnsalias.com>
Subject Re: Cocoon Connection Pooling and Database Shutdown
Date Wed, 16 Oct 2002 13:02:18 GMT
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:    Michael.Edge@db.com

---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message