File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JSP and the fly likes  SqlException accured at processing Jsp Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Java » JSP
Bookmark " SqlException accured at processing Jsp" Watch " SqlException accured at processing Jsp" New topic

SqlException accured at processing Jsp

ramesh poorella
Ranch Hand

Joined: Jul 19, 2011
Posts: 61
this is my jsp...

when i am processing above jsp i am getting exception at

then how can i solve that exception and print values

Smitesh Shinde
Ranch Hand

Joined: Feb 16, 2008
Posts: 45

Ramesh, first of all JSP isn't place to write your application logic. It is considered as bad practice.

Regarding your exception problem -

You can't be absolutely sure of which exception your JSP is throwing. You'll always get java.lang.SQLException in every case as you are explicitly throwing it from your code. Try to print the stack trace to get the exact exception.
Bear Bibeault
Author and ninkuma

Joined: Jan 10, 2002
Posts: 63052

As Smitesh Shinde pointed out, the first step os to move the Java code out of the JSP and into a Java class where it can be properly tested.

[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
It is sorta covered in the JavaRanch Style Guide.
subject: SqlException accured at processing Jsp
It's not a secret anymore!