File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes need help... Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
Bookmark "need help..." Watch "need help..." New topic
Author

need help...

Oswald King
Greenhorn

Joined: Feb 11, 2005
Posts: 10
I am getting following error:

An error occurred at line: 13 in the jsp file: /saveMeterInstallNewConsumer.jsp
Generated servlet error:
Unhandled exception type SQLException


org.apache.jasper.compiler.DefaultErrorHandler.javacError(DefaultErrorHandler.java:84)
org.apache.jasper.compiler.ErrorDispatcher.javacError(ErrorDispatcher.java:328)
org.apache.jasper.compiler.JDTCompiler.generateClass(JDTCompiler.java:409)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:288)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:267)
org.apache.jasper.compiler.Compiler.compile(Compiler.java:255)
org.apache.jasper.JspCompilationContext.compile(JspCompilationContext.java:563)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:293)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
someone plz tell me what is the reason behind this message ?
even if u have some idea, plz let me know.
thanks.
Muhammad Imad Qureshi
Ranch Hand

Joined: Sep 13, 2005
Posts: 238
whats line 13 of your jsp file?
Satish Chilukuri
Ranch Hand

Joined: Jun 23, 2005
Posts: 266
The error you got is a JSP compilation error. It looks like your JSP has some code which can throw a SQLException which is unhandled and hence it is not compiling.
Ravi Shankar
Greenhorn

Joined: Apr 07, 2003
Posts: 26
To avoid this, place the database related code calls in JSP with in try{}catch{} block and handle the SQLException.
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 42935
    
  68
Or even better: Go with accepted practices, and don't perform DB operations in a JSP page. Use a bean or servlet instead.
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61766
    
  67

read this


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: need help...