Transaction timed out after 29 seconds

用weblogic的数据源+ejb开发，经常遇到下面的情况：

调用ejb接口，操作数据库的时候，时间超过29秒就会报错，相信错误信息如下：

 

--- Cause: java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 29 seconds
BEA1-007896384D22CA217E0D]'. No further JDBC access is allowed within this transaction.
    at weblogic.ejb.container.internal.EJBRuntimeUtils.throwRemoteException(EJBRuntimeUtils.java:95)
    at weblogic.ejb.container.internal.BaseEJBObject.handleSystemException(BaseEJBObject.java:724)
    at weblogic.ejb.container.internal.BaseEJBObject.handleSystemException(BaseEJBObject.java:681)
    at weblogic.ejb.container.internal.BaseEJBObject.postInvoke1(BaseEJBObject.java:447)
    at weblogic.ejb.container.internal.StatelessEJBObject.postInvoke1(StatelessEJBObject.java:72)
    at weblogic.ejb.container.internal.BaseEJBObject.postInvokeTxRetry(BaseEJBObject.java:374)
    at com.comtop.dqmp.problemprocessing.quarterssetting.ejb.RuleTypeSetSes_owd7d8_EOImpl.insertRuleTypeSet(RuleTypeSetSes_owd7d8_EOImpl.java:219)
    at com.comtop.dqmp.problemprocessing.quarterssetting.ejb.RuleTypeSetSes_owd7d8_EOImpl_CBV.insertRuleTypeSet(Unknown Source)
    at com.comtop.dqmp.problemprocessing.quarterssetting.delegate.RuleTypeSetMan.insertRuleTypeSet(RuleTypeSetMan.java:113)
    at com.comtop.dqmp.problemprocessing.quarterssetting.action.QuartersSettingListAction.doSetQuartersOperation(QuartersSettingListAction.java:155)
    at com.comtop.dqmp.problemprocessing.quarterssetting.action.QuartersSettingListAction.execute(QuartersSettingListAction.java:60)
    at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
    at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
    at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
    at com.comtop.struts.action.ComtopActionServlet.process(ComtopActionServlet.java:78)
    at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
    at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:225)
    at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:127)
    at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
    at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
    at com.comtop.struts.action.ValidatorSessionFilterSys.doFilter(ValidatorSessionFilterSys.java:186)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
    at com.comtop.struts.logon.UserAreaCodeFilter.doFilter(UserAreaCodeFilter.java:61)
    at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:42)
    at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3212)
    at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:1983)
    at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:1890)
    at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1344)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:181)

 

 

这个很明显就是weblogic的数据源连接出错了，默认是29秒操作没完成，操作的该连接事务自动回滚，修正方法：

进入weblogic的控制台，点击service--jta
Timeout Seconds:120(超时时间，根据自己的情况设置)
Abandon Timeout Seconds:设置到一些，weblogic默认是86400

 

ejb的时间设置方法：

打开weblogic-ejb-jar.xml文件

EJB默认的事务超时时间为30秒（一般29秒就报错）

<weblogic-ejb-jar>  
      <weblogic-enterprise-bean>  
          <ejb-name>test</ejb-name>   
            <jndi-name>test</jndi-name>  

          <transaction-descriptor>  
              <trans-timeout-seconds>120</trans-timeout-seconds>  
          </transaction-descriptor>   
      </weblogic-enterprise-bean>  
</weblogic-ejb-jar>