David's Technical Note

[WebLogic Administration] increase JTA time-out 본문

Product Engineering/2. Oracle Weblogic

[WebLogic Administration] increase JTA time-out

David Joo 2012. 10. 17. 18:09

1.  JTA > 시간초과(초)에서 시간 설정을 늘려준다.

 

 

Transaction time-out 이 발생하면 웹로직 로그는 아래와 같이 로그를 발생시킨다.

만약 해당 Transaction이 장시간 수행이 필요한 경우라면 늘려주겠지만... 보통 300초 이상을 늘려주는 일은 없을 듯

보통 배치작업으로 인한 오랜 transaction의 수행이 필요한 경우 늘려줄 수 도 있을 듯...

에러 로그 확인

### Cause: java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 300 seconds
BEA1-0000290FB242D2982A16]'. No further JDBC access is allowed within this transaction.
; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 300 seconds
BEA1-0000290FB242D2982A16]'. No further JDBC access is allowed within this transaction.; nested exception is java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 300 seconds
BEA1-0000290FB242D2982A16]'. No further JDBC access is allowed within this transaction.
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:71)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358)
at $Proxy54.delete(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.delete(SqlSessionTemplate.java:260)
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:65)
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:25)
at $Proxy186.deleteCer_CORR02(Unknown Source)
... 47 more
Caused by: java.sql.SQLException: The transaction is no longer active - status: 'Marked rollback. [Reason=weblogic.transaction.internal.TimedOutException: Transaction timed out after 300 seconds
BEA1-0000290FB242D2982A16]'. No further JDBC access is allowed within this transaction.
at weblogic.jdbc.wrapper.JTSConnection.checkIfRolledBack(JTSConnection.java:193)

 

'Product Engineering > 2. Oracle Weblogic' 카테고리의 다른 글

[WebLogic TroubleShooting] Connecting to t3://localhost:8550 with userid weblogic ... 메세지를 유지한채 장시간 서버가 종료되지 않는다  (0) 2012.10.10
[WebLogic Troubleshooting] JDBC connection leak not detected on WebLogic Server 10.0.2 (10g mp2)  (0) 2012.09.18
[WebLogic Administration] How to reset username and password of WebLogic AdminServer  (0) 2012.07.12
[WebLogic Administration] JDBC connection Error 로 인한 WebLogic Server instance가 Admin mode로 빠지는 현상  (0) 2012.06.20
[Weblogic Troubleshooting]WLS 10.0.1 Out of Memory Error on Admin Server instance of Weblogic Server  (0) 2012.05.13
'Product Engineering/2. Oracle Weblogic' Related Articles more