Java Database Connectivity (JDBC)

Hello,

There is an issue in the application but surprisingly it occurs sometime. I believe that its due to data (depneding on the number of rows).

Please refer the following stack trace.

2010-04-15 14:35:26,981 [WebContainer : 10] ERROR DS-UTIL - ERROR: class java.lang.ArrayIndexOutOfBoundsException Exception caught during insert: -32393
java.lang.ArrayIndexOutOfBoundsException: -32393
at oracle.jdbc.driver.OraclePreparedStatement.setupBindBuffers(OraclePreparedStatement.java:2673)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:10689)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteBatch(WSJdbcPreparedStatement.java:958)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.executeBatch(WSJdbcStatement.java:705)
at com.labvantage.sapphire.DataSetUtil.insert(DataSetUtil.java:191)
at com.labvantage.sapphire.actions.sdidata.AddDataSet.processAction(AddDataSet.java:361)
at sapphire.action.BaseAction.processAction(BaseAction.java:81)
at com.labvantage.sapphire.services.ActionService.processActionClass(ActionService.java:371)
at com.labvantage.sapphire.services.ActionService.processAction(ActionService.java:256)
at com.labvantage.sapphire.services.ActionService.processAction(ActionService.java:178)
at com.labvantage.sapphire.actions.workitem.AddSDIWorkItem.applyWorkItemItem(AddSDIWorkItem.java:595)
at com.labvantage.sapphire.actions.workitem.AddSDIWorkItem.applyWorkItem(AddSDIWorkItem.java:519)
at com.labvantage.sapphire.actions.workitem.AddSDIWorkItem.processAction(AddSDIWorkItem.java:379)
at com.labvantage.sapphire.actions.workitem.AddSDIWorkItem.processAction(AddSDIWorkItem.java:223)
at sapphire.action.BaseAction.processAction(BaseAction.java:81)
at com.labvantage.sapphire.services.ActionService.processActionClass(ActionService.java:371)
at com.labvantage.sapphire.services.ActionService.processAction(ActionService.java:256)
at com.labvantage.sapphire.services.ActionService.processActionBlock(ActionService.java:141)
at com.labvantage.sapphire.ejb.ActionManagerBean.processActionBlock(ActionManagerBean.java:51)
at com.labvantage.sapphire.ejb.EJSLocalStatelessActionManager_c885a3b6.processActionBlock(Unknown Source)
at com.labvantage.sapphire.ejb.BaseAccessManager.processActionBlock(BaseAccessManager.java:50)
at com.labvantage.sapphire.ejb.EJSLocalStatelessLocalAccessManager_6665518d.processActionBlock(Unknown Source)
at sapphire.accessor.ActionProcessor.processActionBlock(ActionProcessor.java:135)
at sapphire.accessor.ActionProcessor.processAction(ActionProcessor.java:111)
at sapphire.accessor.ActionProcessor.processAction(ActionProcessor.java:102)
at sapphire.custom.gsklift.actions.AssignGSKSpec.executeAddWorkItemList(AssignGSKSpec.java:1051)
at sapphire.custom.gsklift.actions.AssignGSKSpec.doAddGSKSpecToMiscSample(AssignGSKSpec.java:723)
at sapphire.custom.gsklift.actions.AssignGSKSpec.processAction(AssignGSKSpec.java:127)
at com.labvantage.sapphire.services.ActionService.processActionClass(ActionService.java:371)
at com.labvantage.sapphire.services.ActionService.processAction(ActionService.java:256)
at com.labvantage.sapphire.services.ActionService.processActionBlock(ActionService.java:141)
at com.labvantage.sapphire.ejb.ActionManagerBean.processActionBlock(ActionManagerBean.java:51)
at com.labvantage.sapphire.ejb.EJSLocalStatelessActionManager_c885a3b6.processActionBlock(Unknown Source)
at com.labvantage.sapphire.ejb.BaseAccessManager.processActionBlock(BaseAccessManager.java:50)
at com.labvantage.sapphire.ejb.EJSLocalStatelessLocalAccessManager_6665518d.processActionBlock(Unknown Source)
at sapphire.accessor.ActionProcessor.processActionBlock(ActionProcessor.java:135)
at sapphire.accessor.ActionProcessor.processAction(ActionProcessor.java:111)
at sapphire.accessor.ActionProcessor.processAction(ActionProcessor.java:102)
at sapphire.custom.gsklift.sdcrules.Sample.postAdd(Sample.java:390)
at com.labvantage.sapphire.actions.sdi.AddSDI.processAction(AddSDI.java:578)
at sapphire.action.BaseAction.processAction(BaseAction.java:81)
at com.labvantage.sapphire.services.ActionService.processActionClass(ActionService.java:371)
at com.labvantage.sapphire.services.ActionService.processAction(ActionService.java:256)
at com.labvantage.sapphire.services.ActionService.processActionBlock(ActionService.java:141)
at com.labvantage.sapphire.ejb.ActionManagerBean.processActionBlock(ActionManagerBean.java:51)
at com.labvantage.sapphire.ejb.EJSLocalStatelessActionManager_c885a3b6.processActionBlock(Unknown Source)
at com.labvantage.sapphire.ejb.BaseAccessManager.processActionBlock(BaseAccessManager.java:50)
at com.labvantage.sapphire.ejb.EJSLocalStatelessLocalAccessManager_6665518d.processActionBlock(Unknown Source)
at sapphire.accessor.ActionProcessor.processActionBlock(ActionProcessor.java:135)
at sapphire.accessor.ActionProcessor.processAction(ActionProcessor.java:111)
at sapphire.accessor.ActionProcessor.processAction(ActionProcessor.java:102)
at com.labvantage.opal.actions.DSActions.doCopySDIDetail(DSActions.java:1018)
at com.labvantage.opal.actions.DSActions.processAction(DSActions.java:127)
at com.labvantage.sapphire.services.ActionService.processActionClass(ActionService.java:371)
at com.labvantage.sapphire.services.ActionService.processAction(ActionService.java:256)
at com.labvantage.sapphire.services.ActionService.processActionBlock(ActionService.java:141)
at com.labvantage.sapphire.ejb.ActionTransManagerBean.processActionBlock(ActionTransManagerBean.java:43)
at com.labvantage.sapphire.ejb.EJSLocalStatelessActionTransManager_3cd0c7cc.processActionBlock(Unknown Source)
at com.labvantage.sapphire.ejb.ActionManagerBean.processActionBlock(ActionManagerBean.java:41)
at com.labvantage.sapphire.ejb.EJSLocalStatelessActionManager_c885a3b6.processActionBlock(Unknown Source)
at com.labvantage.sapphire.ejb.BaseAccessManager.processActionBlock(BaseAccessManager.java:50)
at com.labvantage.sapphire.ejb.EJSLocalStatelessLocalAccessManager_6665518d.processActionBlock(Unknown Source)
at sapphire.accessor.ActionProcessor.processActionBlock(ActionProcessor.java:135)
at sapphire.accessor.ActionProcessor.processAction(ActionProcessor.java:111)
at com.ibm._jsp._gskcreatesdi.runAddSdi(_gskcreatesdi.java:195)
at com.ibm._jsp._gskcreatesdi._jspService(_gskcreatesdi.java:865)
at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:87)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1146)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:118)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:524)
at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:122)
at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:232)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.include(WebAppRequestDispatcher.java:639)
at com.labvantage.sapphire.servlet.command.JspRequest.includeRequest(JspRequest.java:174)
at com.labvantage.sapphire.servlet.command.JspRequest.requestObject(JspRequest.java:123)
at com.labvantage.sapphire.servlet.RequestController.doGet(RequestController.java:192)
at com.labvantage.sapphire.servlet.RequestController.doPost(RequestController.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1146)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145)
at com.labvantage.sapphire.servlet.filter.Compression.doFilter(Compression.java:134)
at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130)
at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837)
at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680)
at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588)
at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:524)
at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90)
at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:751)
at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1478)
at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:125)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458)
at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387)
at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102)
at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136)
at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196)
at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751)
at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)
2010-04-15 14:35:26,991 [WebContainer : 10] ERROR ADDDATASET 1270837695024 - GENERAL_ERROR: DataSetUtil.insert Exception: -32393
sapphire.SapphireException: DataSetUtil.insert Exception: -32393
at com.labvantage.sapphire.DataSetUtil.insert(DataSetUtil.java:199)
at com.labvantage.sapphire.actions.sdidata.AddDataSet.processAction(AddDataSet.java:361)
at sapphire.action.BaseAction.processAction(BaseAction.java:81)
at com.labvantage.sapphire.services.ActionService.processActionClass(ActionService.java:371)
at com.labvantage.sapphire.services.ActionService.processAction(ActionService.java:256)


Please some buddy help me.

Many thanks!