u can save all ur sql in a session variable prior to executing them. Then try to get the sql that threw the exception from the session variable from ur error page.
Emma -----Original Message----- From: Lakshmeenarayana G G [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 2:21 PM To: [EMAIL PROTECTED] Subject: Re: Showing SQL in database error You can use the implicit "exception" object to get the error details. -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]]On Behalf Of Campano, Troy Sent: Tuesday, August 20, 2002 5:38 PM To: [EMAIL PROTECTED] Subject: Showing SQL in database error I have a JSP that makes a call to a database. It's a method that makes the call and throws a SQLException. At the top of my JSP I use a errorPage="" directive to catch my errors, so I can make my own custom error message. When I get a JDBC error, I'd like to also display the SQL that caused the problem. Is there a way to send the SQL String over to the error page? thanks! Troy Campano ========================= To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
