New to this

[MSE]

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

[DarrylBurke]

Forum Rules -- particularly the third paragraph.

Nothing to do with Applets. Moving to Servlets.

db

[AeneasTroy]

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.

[Tolls]

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.