Hi cocooners!
I want to handle errors coming from esql selects and actions operate on DB.
ESQL - I try to do:

   <esql:connection>
    <esql:pool>mypool</esql:pool>
    <esql:execute-query>
     <esql:query>
      select EMPNO
      from EMP
     </esql:query>
     <esql:results>
      <esql:row-results>
       <employee>
        <id>
         <value><esql:get-long column="EMPNO"/></value>
        </id>
       </employee>
      </esql:row-results>
     </esql:results>
     <esql:no-results>
      <employee-lack/>
     </esql:no-results>
     <esql:error-results>
      <employee-error><esql:get-message/></employee-error>
     </esql:error-results>
    </esql:execute-query>
   </esql:connection>

and? When i make fail in select e.g. type "SELCET" not "SELECT" i get
"Cocoon error" and cocoon error page! I have same when I define not exist
DSN in DB connection at cocoon.xconf.
Maybe anybody knows any howto document or the way what to handle this
exceptions.
I don't handle errors in sitemap.xmap (if it has any importance).

And second question: how to handle db error when I would to use
Database*Action? Is any method to handle this error in sitemap.xmaps
<pipeline> ?

Regards
Jerzy Kut



---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

Reply via email to