Can anyone tell me how to find out what causes this error -- the
message is not very revealing!
I'm using DB2 8.1 fixpak 5 on Windows XP, using the Sun JDK 1.4.2.
Thanks,
Tom
com.ibm.db2.jcc.b.SQLException: 5
at com.ibm.db2.jcc.b.ce.e(ce.java:1093)
at com.ibm.db2.jcc.b.ce.a(ce.java:884)
at com.ibm.db2.jcc.a.bd.n(bd.java:535)
at com.ibm.db2.jcc.a.bd.i(bd.java:228)
at com.ibm.db2.jcc.a.bd.c(bd.java:54)
at com.ibm.db2.jcc.a.r.c(r.java:53)
at com.ibm.db2.jcc.a.bp.h(bp.java:156)
at com.ibm.db2.jcc.b.ce.j(ce.java:880)
at com.ibm.db2.jcc.b.cf.a(cf.java:1516)
at com.ibm.db2.jcc.b.cf.executeQuery(cf.java:303)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:17 7)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeQuery(DelegatingPreparedStatement.java:17 7)
at org.apache.ojb.broker.accesslayer.JdbcAccess.execu teQuery(JdbcAccess.java:256)
at org.apache.ojb.broker.accesslayer.RsIterator.(RsIt erator.java:245)
at org.apache.ojb.broker.accesslayer.ReportQueryRsIte rator.(ReportQueryRsIterator.java:84)
at org.apache.ojb.broker.singlevm.ReportRsIteratorFac toryImpl.createRsIterator(ReportRsIteratorFactoryI mpl.java:96)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getRsIteratorFromQuery(PersistenceBrokerImpl.ja va:2491)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getRsIteratorFromQueryExtentAware(PersistenceBr okerImpl.java:1707)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getReportQueryIteratorFromQuery(PersistenceBrok erImpl.java:2548)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getReportQueryIteratorByQuery(PersistenceBroker Impl.java:2467)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getCount(PersistenceBrokerImpl.java:2438)
at org.apache.ojb.broker.accesslayer.RsIterator.count edSize(RsIterator.java:474)
at org.apache.ojb.broker.accesslayer.RsIterator.size( RsIterator.java:501)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getCollectionByQuery(PersistenceBrokerImpl.java :1221)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getCollectionByQuery(PersistenceBrokerImpl.java :1372)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getCollectionByQuery(PersistenceBrokerImpl.java :1398)
at org.apache.ojb.broker.singlevm.PersistenceBrokerIm pl.getCollectionByQuery(PersistenceBrokerImpl.java :1385)
at org.apache.ojb.broker.singlevm.DelegatingPersisten ceBroker.getCollectionByQuery(DelegatingPersistenc eBroker.java:306)
at au.com.ids.service.persistence.ServiceDAO.findOrde rsByStatusAndPlannedInDate(ServiceDAO.java:114)
at au.com.ids.service.businesslogic.BookingConfirmati onController.findRepairBookingsByDate(BookingConfi rmationController.java:240)
at au.com.ids.service.businesslogic.BookingConfirmati onController.retrieveBookingConfirmationLines(Book ingConfirmationController.java:307)
at au.com.ids.service.businesslogic.BookingConfirmati onController.doInitForm(BookingConfirmationControl ler.java:187)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ e Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at au.com.ids.base.businesslogic.BaseController.invok eMethod(BaseController.java:238)
at au.com.ids.base.businesslogic.BaseController.callI nitMethod(BaseController.java:45)
at au.com.ids.base.action.CallInitControllerAction.pe rform(CallInitControllerAction.java:60)
at au.com.ids.base.action.BaseAction.perform(BaseActi on.java:149)
at au.com.ids.base.action.BaseAction.execute(BaseActi on.java:126)
at org.apache.struts.action.RequestProcessor.processA ctionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process( RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(Act ionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doGet(Actio nServlet.java:507)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at au.com.ids.base.businesslogic.ResponseOverridingFi lter.doFilter(ResponseOverridingFilter.java:61)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at au.com.ids.base.businesslogic.SetCharacterEncoding Filter.doFilter(SetCharacterEncodingFilter.java:14 7)
at org.apache.catalina.core.ApplicationFilterChain.in ternalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.do Filter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invo ke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invo ke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.valves.CertificatesValve.invok e(CertificatesValve.java:246)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(St andardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke( StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.valves.ErrorDispatcherValve.in voke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.ErrorReportValve.invoke (ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.valves.AccessLogValve.invoke(A ccessLogValve.java:509)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:641)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invok e(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$Standard PipelineValveContext.invokeNext(StandardPipeline.j ava:643)
at org.apache.catalina.core.StandardPipeline.invoke(S tandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(Cont ainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(Co yoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(H ttp11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11Conn ectionHandler.processConnection(Http11Protocol.jav a:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(P oolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlR unnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:534)