Link to home
Start Free TrialLog in
Avatar of sarveshr
sarveshr

asked on

This exception ocurrs when the DAO code hits database to access page data.

I have an application running in the following environment:
WAS 5.1, hibernate, Oracle 9.1
The following error is thrown by the code while access database:
javax.ejb.TransactionRolledbackLocalException:  ; nested exception is: java.lang.ArrayIndexOutOfBoundsException: -1237668171
java.lang.ArrayIndexOutOfBoundsException: -1237668171
      at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java(Compiled Code))
      at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:965)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java(Compiled Code))
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java(Compiled Code))
      at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3445)
      at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:4394)
      at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:401)
      at com.server.common.entity.persistence.paging.session.DatastoreBasedPagingSessionManager.getPage(DatastoreBasedPagingSessionManager.java:142)
      at com.server.MyApp.entity.persistence.hibernate.application.ApplicationSummaryDAO.getCurrentPage(ApplicationSummaryDAO.java:299)
      at com.server.MyApp.service.MyAppApplicationManagerBean.getApplicationSummaries(MyAppApplicationManagerBean.java(Compiled Code))
      at com.server.MyApp.service.EJSLocalStatelessMyAppApplicationManager_3e746743.getApplicationSummaries(Unknown Source)
      at com.server.MyApp.handler.application.GetApplicationSummariesEventHandler.handle(GetApplicationSummariesEventHandler.java:29)
      at com.server.common.service.main.StateMachine.processEvent(StateMachine.java:80)
      at com.server.common.service.event.AEventHandlingFacadeBean$1.run(AEventHandlingFacadeBean.java:54)
      at com.server.common.session.SessionProfileManager.runUnderSessionProfile(SessionProfileManager.java:54)
      at com.server.common.service.event.AEventHandlingFacadeBean.handle(AEventHandlingFacadeBean.java:37)
      at com.server.MyApp.service.event.EJSLocalStatelessMyAppEventHandlingFacade_21511e19.handle(Unknown Source)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean$1.run(AMainFacadeWithAuthenticationBean.java:98)
      at com.server.common.session.SessionProfileManager.runUnderSessionProfile(SessionProfileManager.java:54)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean$4.run(AMainFacadeWithAuthenticationBean.java:303)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.runWithExceptionLogging(AMainFacadeWithAuthenticationBean.java:310)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.runUnderSessionProfileWithExceptionLogging(AMainFacadeWithAuthenticationBean.java:301)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.handle(AMainFacadeWithAuthenticationBean.java:85)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.handle(AMainFacadeWithAuthenticationBean.java:66)
      at com.server.MyApp.service.main.EJSRemoteStatefulMyAppMainFacade_d5018591.handle(Unknown Source)
      at com.server.MyApp.service.main._MyAppMainFacade_Stub.handle(_MyAppMainFacade_Stub.java:334)
      at com1.MyApp.MyAppMainFacadeDelegate.handle(MyAppMainFacadeDelegate.java:106)
      at com1.MyApp.handlers.ApplicationsHandler.perform_list(ApplicationsHandler.java:140)
      at com1.MyApp.handlers.ApplicationsHandler.perform_filterSet(ApplicationsHandler.java:350)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
      at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
      at com1.MyApp.handlers.ABPMApplicationHandler.retrievePageDetails(ABPMApplicationHandler.java:82)
      at com1.MyApp.handlers.ABPMApplicationHandler.perform(ABPMApplicationHandler.java:65)
      at com1.server.thin.ControllerServlet.performInternalForward(ControllerServlet.java:596)
      at com1.server.thin.ControllerServlet.performConfiguredForward(ControllerServlet.java:522)
      at com1.server.thin.ControllerServlet.performConfiguredForward(ControllerServlet.java:504)
      at com1.server.thin.ControllerServlet.performInternalForward(ControllerServlet.java:599)
      at com1.server.thin.ControllerServlet.processSinglePartRequest(ControllerServlet.java:295)
      at com1.server.thin.ControllerServlet.processRequest(ControllerServlet.java:228)
      at com1.server.thin.ControllerServlet.doAny(ControllerServlet.java:468)
      at com1.server.thin.ControllerServlet.doPost(ControllerServlet.java:486)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
      at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
      at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
      at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
      at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
      at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
      at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1036)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:544)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:210)
      at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:139)
      at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:332)
      at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
      at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:120)
      at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:258)
      at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
      at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
      at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
      at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))
javax.ejb.TransactionRolledbackLocalException:  ; nested exception is: java.lang.ArrayIndexOutOfBoundsException: -1237668171
      at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapCSIException(LocalExceptionMappingStrategy.java:96)
      at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapException(LocalExceptionMappingStrategy.java:165)
      at com.ibm.ejs.container.LocalExceptionMappingStrategy.mapCSITransactionRolledBackException(LocalExceptionMappingStrategy.java:293)
      at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java(Compiled Code))
      at com.server.MyApp.service.EJSLocalStatelessMyAppApplicationManager_3e746743.getApplicationSummaries(Unknown Source)
      at com.server.MyApp.handler.application.GetApplicationSummariesEventHandler.handle(GetApplicationSummariesEventHandler.java:29)
      at com.server.common.service.main.StateMachine.processEvent(StateMachine.java:80)
      at com.server.common.service.event.AEventHandlingFacadeBean$1.run(AEventHandlingFacadeBean.java:54)
      at com.server.common.session.SessionProfileManager.runUnderSessionProfile(SessionProfileManager.java:54)
      at com.server.common.service.event.AEventHandlingFacadeBean.handle(AEventHandlingFacadeBean.java:37)
      at com.server.MyApp.service.event.EJSLocalStatelessMyAppEventHandlingFacade_21511e19.handle(Unknown Source)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean$1.run(AMainFacadeWithAuthenticationBean.java:98)
      at com.server.common.session.SessionProfileManager.runUnderSessionProfile(SessionProfileManager.java:54)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean$4.run(AMainFacadeWithAuthenticationBean.java:303)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.runWithExceptionLogging(AMainFacadeWithAuthenticationBean.java:310)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.runUnderSessionProfileWithExceptionLogging(AMainFacadeWithAuthenticationBean.java:301)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.handle(AMainFacadeWithAuthenticationBean.java:85)
      at com.server.common.service.main.AMainFacadeWithAuthenticationBean.handle(AMainFacadeWithAuthenticationBean.java:66)
      at com.server.MyApp.service.main.EJSRemoteStatefulMyAppMainFacade_d5018591.handle(Unknown Source)
      at com.server.MyApp.service.main._MyAppMainFacade_Stub.handle(_MyAppMainFacade_Stub.java:334)
      at com1.MyApp.MyAppMainFacadeDelegate.handle(MyAppMainFacadeDelegate.java:106)
      at com1.MyApp.handlers.ApplicationsHandler.perform_list(ApplicationsHandler.java:140)
      at com1.MyApp.handlers.ApplicationsHandler.perform_filterSet(ApplicationsHandler.java:350)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
      at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
      at com1.MyApp.handlers.ABPMApplicationHandler.retrievePageDetails(ABPMApplicationHandler.java:82)
      at com1.MyApp.handlers.ABPMApplicationHandler.perform(ABPMApplicationHandler.java:65)
      at com1.server.thin.ControllerServlet.performInternalForward(ControllerServlet.java:596)
      at com1.server.thin.ControllerServlet.performConfiguredForward(ControllerServlet.java:522)
      at com1.server.thin.ControllerServlet.performConfiguredForward(ControllerServlet.java:504)
      at com1.server.thin.ControllerServlet.performInternalForward(ControllerServlet.java:599)
      at com1.server.thin.ControllerServlet.processSinglePartRequest(ControllerServlet.java:295)
      at com1.server.thin.ControllerServlet.processRequest(ControllerServlet.java:228)
      at com1.server.thin.ControllerServlet.doAny(ControllerServlet.java:468)
      at com1.server.thin.ControllerServlet.doPost(ControllerServlet.java:486)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
      at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
      at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
      at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
      at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
      at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
      at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:1036)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:544)
      at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:210)
      at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:139)
      at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:332)
      at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
      at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:120)
      at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:258)
      at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
      at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
      at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
      at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
      at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))

The error is happening while executing a callable statement. This error does not happen in all environments. But happens only in one specific environment. Any clue as to what can be the reason?
ASKER CERTIFIED SOLUTION
Avatar of Bart Cremers
Bart Cremers
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of sarveshr
sarveshr

ASKER

What I last understand is the solution of setting JIT compiler to false is temporary and IBM has released patch for this bug.
I haven't been following up the bug because I recently switched jobs and because of this appservers ;). Last thing I knew was that both IBM and Oracle were blaming each other. Good thing IBM took responsibility and finally fixed it.