日期:2014-05-19  浏览次数:20858 次

weblogic数据源管理事务 Transaction timed out
查询的这个脚本执行不到0.01秒,为什么报这错呢,今天生产连续报了两次,到后面连登录系统都成问题啦,好奇怪

select distinct n.unitcode,n.unitname from mm_bizprivilege_cover_td b,mm_unitmapping_tc u,mm_unit_tc n where u.departmentcode=b.departmentcode and u.unitcode=n.unitcode and b.opcode=? order by unitname
Hibernate: select payablemon0_.payableno as payableno11_, payablemon0_.agentcode as agentcode11_, payablemon0_.amount as amount11_, payablemon0_.bankname as bankname11_, payablemon0_.baseamount as baseamount11_, payablemon0_.basecurrencycode as basecurr6_11_, payablemon0_.baseusedamount as baseused7_11_, payablemon0_.businessattr as business8_11_, payablemon0_.businesschannel as business9_11_, payablemon0_.canceldate as canceldate11_, payablemon0_.cancelflag as cancelflag11_, payablemon0_.claimno as claimno11_, payablemon0_.classescode as classes13_11_, payablemon0_.clientname as clientname11_, payablemon0_.confirmsequenceno as confirm15_11_, payablemon0_.currencycode as currenc16_11_, payablemon0_.custaccountno as custacc17_11_, payablemon0_.custbankno as custbankno11_, payablemon0_.customercode as custome19_11_, payablemon0_.customername as custome20_11_, payablemon0_.custseq as custseq11_, payablemon0_.datasource as datasource11_, payablemon0_.datatype as datatype11_, payablemon0_.departmentcode as departm24_11_, payablemon0_.description as descrip25_11_, payablemon0_.endorseno as endorseno11_, payablemon0_.fatherno as fatherno11_, payablemon0_.hibernateversion as hiberna28_11_, payablemon0_.ifeffect as ifeffect11_, payablemon0_.ifupload as ifupload11_, payablemon0_.inpaymentbatchno as inpayme31_11_, payablemon0_.insuredcode as insured32_11_, payablemon0_.insuredname as insured33_11_, payablemon0_.isException as isExcep34_11_, payablemon0_.lastopdate as lastopdate11_, payablemon0_.opcode as opcode11_, payablemon0_.opdate as opdate11_, payablemon0_.opstatus as opstatus11_, payablemon0_.payableseq as payableseq11_, payablemon0_.paytype as paytype11_, payablemon0_.policyno as policyno11_, payablemon0_.returnno as returnno11_, payablemon0_.risktype as risktype11_, payablemon0_.segment7 as segment44_11_, payablemon0_.segment8 as segment45_11_, payablemon0_.subcompany as subcompany11_, payablemon0_.summaryno as summaryno11_, payablemon0_.timestamp as timestamp11_, payablemon0_.transactorcode as transac49_11_, payablemon0_.unitbankno as unitbankno11_, payablemon0_.unitcode as unitcode11_, payablemon0_.usedamount as usedamount11_ from MM_PAYABLEMONEY_TD payablemon0_ where (payablemon0_.datatype in ('502' , '516' , '536' , '538')) and ifcard='0' and (payablemon0_.opstatus in ('0' , '1')) and payablemon0_.subcompany=? and payablemon0_.policyno=? and payablemon0_.endorseno=? and payablemon0_.custseq=? and payablemon0_.customercode=? and payablemon0_.currencycode=? and payablemon0_.classescode=?
09:46:46,349 WARN AbstractBatcher[closeQueryStatement]:280 - exception clearing maxRows/queryTimeout
java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 599 seconds 
BEA1-3D45953A058A51C38C01
at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1419)
at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1331)
at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:189)
at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:64)
at weblogic.jdbc.wrapper.Statement.checkStatement(Statement.java:256)
at weblogic.jdbc.wrapper.Statement.preInvocationHandler(Statement.java:104)
at weblogic.jdbc.wrapper.PreparedStatement_oracle_jdbc_driver_T4CPreparedStatement.getMaxRows(Unknown Source)
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatche