in your catch block you can write
catch(Exception e){
throw new SQLException("The query is "+sqlquery+" the database error
is: "+e.getMessage());
}
Regards,
Vikramjit Singh,
GTL Ltd.
Ph. 7612929-1059
> -----Original Message-----
> From: Campano, Troy [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 5:22 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Showing SQL in database error
>
>
> I have a variable named sSQL that contains the value of my SQL.
> Is there anyway to display that SQL?
> Maybe by adding the sSQL to the exception somehow?
>
>
>
>
> thanks!
>
> -----Original Message-----
> From: Lakshmeenarayana G G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 8:25 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Showing SQL in database error
>
>
> I think it will give deatils of JDBC Exception. I don't think
> it will give you the SQL Query.
>
>
> -----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:47 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Showing SQL in database error
>
>
> Would that give me the SQL code as well or just more details
> on the JDBC database error?
>
>
> -----Original Message-----
> From: Lakshmeenarayana G G [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 8:21 AM
> 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
>
> ==============================================================
> =============
> 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
