Integration

Hi All,

I am using toplink for persistence with jboss. Every thing is working fine but some time i encountered an error that say "*internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.*".

This is coming up when i am retrieving some data through procedure in for loop. Also note that this exception is not coming on regular basis. out of 10 run it is coming only in 5 time with same steps.

Following is the log. Please help me out as i m in critical project status situation. thanks in advance.

internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.
Error Code: 226
Call:SET CHAINED OFF
Query:DataModifyQuery()
16:42:59,549 INFO [STDOUT] com.pearson.pdrm.business.common.util.PdrmException: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.
Error Code: 226
Call:SET CHAINED OFF
Query:DataModifyQuery()
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.integration.dao.projects.ProjectsDAO.getApprovers(ProjectsDAO.java:1177)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.integration.dao.projects.ProjectsDAO.getLevelwiseAvailableApprovers(ProjectsDAO.java:1119)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.integration.dao.projects.ProjectsDAO.loadProjectDetails(ProjectsDAO.java:618)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.business.projects.ejb.ProjectsBean.loadProjectDetails(ProjectsBean.java:56)
16:42:59,580 INFO [STDOUT] at sun.reflect.GeneratedMethodAccessor246.invoke(Unknown Source)
16:42:59,580 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
16:42:59,580 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:585)
16:42:59,580 INFO [STDOUT] at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
16:42:59,580 INFO [STDOUT] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)
16:42:59,580 INFO [STDOUT] at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.Container.invoke(Container.java:873)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)
16:42:59,580 INFO [STDOUT] at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)
16:42:59,580 INFO [STDOUT] at $Proxy68.loadProjectDetails(Unknown Source)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.business.delegate.ProjectsDelegate.loadProjectDetails(ProjectsDelegate.java:109)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.presentation.createProject.command.CreateProjectCommand.loadProjectDetails(CreateProjectCommand.java:115)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.presentation.createProject.command.CreateProjectCommand.executeDisplayForCarProject(CreateProjectCommand.java:103)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.presentation.createProject.command.CreateProjectCommand.executeDisplay(CreateProjectCommand.java:274)
16:42:59,580 INFO [STDOUT] at com.pearson.pdrm.presentation.common.BaseAction.execute(BaseAction.java:315)
16:42:59,580 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
16:42:59,580 INFO [STDOUT] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
16:42:59,580 INFO [STDOUT] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
16:42:59,580 INFO [STDOUT] at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
16:42:59,580 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:42:59,580 INFO [STDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
16:42:59,580 INFO [STDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
16:42:59,580 INFO [STDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
16:42:59,580 INFO [STDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
16:42:59,580 INFO [STDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
16:42:59,580 INFO [STDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
16:42:59,580 INFO [STDOUT] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
16:42:59,580 INFO [STDOUT] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
16:42:59,580 INFO [STDOUT] at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
16:42:59,580 INFO [STDOUT] at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
16:42:59,580 INFO [STDOUT] at java.lang.Thread.run(Thread.java:595)
16:42:59,580 WARN [ProjectsDAO] com.pearson.pdrm.business.common.util.PdrmException: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.
Error Code: 226
Call:SET CHAINED OFF
Query:DataModifyQuery()
16:42:59,861 WARN [pdrm] com.pearson.pdrm.business.common.util.PdrmException: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.
Error Code: 226
Call:SET CHAINED OFF
Query:DataModifyQuery()
com.pearson.pdrm.business.common.util.PdrmException: com.pearson.pdrm.business.common.util.PdrmException: Exception [TOPLINK-4002] (Oracle TopLink - 10g Release 3 (10.1.3.0.0) (Build 060118)): oracle.toplink.exceptions.DatabaseException
Internal Exception: com.sybase.jdbc3.jdbc.SybSQLException: SET CHAINED command not allowed within multi-statement transaction.
Error Code: 226
Call:SET CHAINED OFF
Query:DataModifyQuery()
at com.pearson.pdrm.integration.dao.projects.ProjectsDAO.loadProjectDetails(ProjectsDAO.java:623)
at com.pearson.pdrm.business.projects.ejb.ProjectsBean.loadProjectDetails(ProjectsBean.java:56)
at sun.reflect.GeneratedMethodAccessor246.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.invocation.Invocation.performCall(Invocation.java:345)
at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:214)
at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:149)
at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:154)
at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)
at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:48)
at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:106)
at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:335)
at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:166)
at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:153)
at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:624)
at org.jboss.ejb.Container.invoke(Container.java:873)
at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:415)
at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:88)
at $Proxy68.loadProjectDetails(Unknown Source)
at com.pearson.pdrm.business.delegate.ProjectsDelegate.loadProjectDetails(ProjectsDelegate.java:109)
at com.pearson.pdrm.presentation.createProject.command.CreateProjectCommand.loadProjectDetails(CreateProjectCommand.java:115)
at com.pearson.pdrm.presentation.createProject.command.CreateProjectCommand.executeDisplayForCarProject(CreateProjectCommand.java:103)
at com.pearson.pdrm.presentation.createProject.command.CreateProjectCommand.executeDisplay(CreateProjectCommand.java:274)
at com.pearson.pdrm.presentation.common.BaseAction.execute(BaseAction.java:315)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:419)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:224)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1194)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
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.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
at java.lang.Thread.run(Thread.java:595)

Thanks and Regards,
Zeyaul