GeeCON Prague 2014*
The moose likes Servlets and the fly likes Servlet Exeption error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Java » Servlets
Bookmark "Servlet Exeption error" Watch "Servlet Exeption error" New topic
Author

Servlet Exeption error

Suhaila Abdullah
Greenhorn

Joined: Jun 23, 2008
Posts: 1
Hi..I'm running my application on Tomcat5.5l Lately I encounter the following error in the catalina log file. I just wanted to ask, generally what will cause this type of error since I am not able to detect which part of the application that giving this error. Thank you in advance.

Jun 23, 2008 1:18:18 PM org.apache.catalina.core.StandardWrapperValve invoke
SEVERE: Servlet.service() for servlet jsp threw exception
java.sql.SQLException: Can not issue NULL query.
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.Statement.checkNullOrEmptyQuery(Statement.java:416)
at com.mysql.jdbc.Statement.executeQuery(Statement.java:1058)
at bgoc.com.dbConn.Conn.execSQL(Conn.java:196)
at bgoc.com.dbConn.MultiDBManager.execSQL(MultiDBManager.java:27)
at bgoc.bis.siteDiary.SDWorkProgress.chkPrgTyp(SDWorkProgress.java:32)
at org.apache.jsp.bis.siteOpt.siteDiary.sd_005fview_jsp._jspService(sd_005fview_jsp.java:102)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Unknown Source)
Ben Souther
Sheriff

Joined: Dec 11, 2004
Posts: 13410

Originally posted by Suhaila Abdullah:


at bgoc.com.dbConn.Conn.execSQL(Conn.java:196)
at bgoc.com.dbConn.MultiDBManager.execSQL(MultiDBManager.java:27)


It appears that, on line 196, you're trying to perform a JDBC operation with a null SQL query.


Java API J2EE API Servlet Spec JSP Spec How to ask a question... Simple Servlet Examples jsonf
Amit Ghorpade
Bartender

Joined: Jun 06, 2007
Posts: 2716
    
    6

Hi Suhaila Abdullah, welcome to Javaranch,
as posted by Ben, the problem seems to be with the null query.
I think you should get the same with your exception stack trace in your exception handling code.




Hope this helps


SCJP, SCWCD.
|Asking Good Questions|
 
GeeCON Prague 2014
 
subject: Servlet Exeption error