Results 1 to 4 of 4

Thread: New to this

  1. #1
    MSE
    MSE is offline Member
    Join Date
    Oct 2012
    Posts
    1
    Rep Power
    0

    Default New to this

    Hey guys I have a error on a intranet server. The server froze one day and I had to restart it. I lost most of the company intranet functionality. Here is the Error I get when i try to search for a part number on the company intranet. Any help would be greatly appreciated.

    Oops! There was an error.
    javax.servlet.ServletException: query failed: select catnum, catname, asize, aprice from chemical where catnum like 'f2%' and catname like '%' and asize like '%' order by catnum union select catnum, catname, ' ' as asize, 0.0 as aprice from spspec where catnum like 'f2%' and catname like '%' order by catnum
    javax.servlet.ServletException: query failed: select catnum, catname, asize, aprice from chemical where catnum like 'f2%' and catname like '%' and asize like '%' order by catnum union select catnum, catname, ' ' as asize, 0.0 as aprice from spspec where catnum like 'f2%' and catname like '%' order by catnum at org.apache.struts.action.RequestProcessor.processE xception(RequestProcessor.java:523) at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:421) at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:224) at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1196) at org.apache.struts.action.ActionServlet.doGet(Actio nServlet.java:414) at javax.servlet.http.HttpServlet.service(HttpServlet .java:689) at javax.servlet.http.HttpServlet.service(HttpServlet .java:802) at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invo ke(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.invok e(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.servic e(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11 ConnectionHandler.processConnection(Http11BaseProt ocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.process Socket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThr ead.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:619)
    null

  2. #2
    DarrylBurke's Avatar
    DarrylBurke is offline Forum Police
    Join Date
    Sep 2008
    Location
    Madgaon, Goa, India
    Posts
    11,423
    Rep Power
    20

    Default Re: New to this

    Forum Rules -- particularly the third paragraph.

    Nothing to do with Applets. Moving to Servlets.

    db
    If you're forever cleaning cobwebs, it's time to get rid of the spiders.

  3. #3
    AeneasTroy is offline Arma virumque cano
    Join Date
    Oct 2012
    Location
    Indianapolis
    Posts
    20
    Rep Power
    0

    Default Re: New to this

    You did an sql query and it failed.

    You are supposed to wrap your queries in try{CODE GOES HERE}catch(Exception e){e.printStackTrac();} before running so you don't get errors like that.

  4. #4
    Tolls is offline Moderator
    Join Date
    Apr 2009
    Posts
    12,091
    Rep Power
    20

    Default Re: New to this

    Looks to me like they are doing that, and possibly throwing their own exception rather than wrapping the one that caused the problem.
    Because that really isn't telling us what the error is.
    Please do not ask for code as refusal often offends.

    ** This space for rent **

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •