When my application runs and access the Database if an error occurs the oracle error will be displayed on the page. I wold like to know how could I catch the error and handle the error message to give something more understandable for my end users? I try to use <dtml-try> and <dtml-exepcion> but I didn't manage to make it work.
Houw did you use <dtml-try>/<dtml-except> ?
first I tryied to wrap arround a SQL statment in ZSQL method: <dtml-try> select bla bla bla..... <dtml-except> <p> Not found</p> </dtml-try> then I tried to wrap arround the ZQL method <dtml-try> <dtml-var myZsqlMethod> dtml-except> <P> not found</p> </dtml-try>
What error do you get from Oracle ? The problem is not the error itself because it is working. What I want to do is to handle the errors.
Do you kown how this cold be done?
I'm not sure about DCOracle, but I have hade similar uncatchable behaviour when some underlying libraries don't catch the error but print it to stdout instead.
I even had PoPy just drop dead and produced _no_ output whatsoever - my bug-report on it lingers on sourceforge for months ;(
----- Original Message ----- From: "Hannu Krosing" <hannu@tm.ee> To: "Ricardo Seghizzi" <ricardo@cnbe.mar.org.uk> Cc: "Chris McDonough" <chrism@digicool.com>; <zope@zope.org> Sent: Thursday, June 28, 2001 7:40 PM Subject: Re: [Zope] Re: Oracle Error Messages
I created a website that connect to an Oracle 8.0 DB.
My web application is working fine. I created a web application that access a external DB in only 2 weeks! And during this period I as learning Zope and DTML as well. Not to bad...
Zope is wonderfull...
When my application runs and access the Database if an error occurs the oracle error will be displayed on the page. I wold like to know how could I catch the error and handle the error message to give something more understandable for my end users? I try to use <dtml-try> and <dtml-exepcion> but I didn't manage to make it work.
Houw did you use <dtml-try>/<dtml-except> ?
What error do you get from Oracle ?
Do you kown how this cold be done?
I'm not sure about DCOracle, but I have hade similar uncatchable behaviour when some underlying libraries don't catch the error but print it to stdout instead.
I even had PoPy just drop dead and produced _no_ output whatsoever - my bug-report on it lingers on sourceforge for months ;(
------------- Hannu
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )