David's Technical Note

[WebLogic Troubleshooting] JDBC connection leak not detected on WebLogic Server 10.0.2 (10g mp2) 본문

Product Engineering/2. Oracle Weblogic

[WebLogic Troubleshooting] JDBC connection leak not detected on WebLogic Server 10.0.2 (10g mp2)

David Joo 2012. 9. 18. 14:32

 

JDBC connection leak not detected on WebLogic Server 10.0.2 (10g mp2)

 

Product ver. WebLogic Server 10.0.2 

setting parameters below To find the JDBC connection leak 

 - inactive connection time out 100초 설정

 - profile connectin leak 설정

 

1. 증상

1. sympton

application 소스 (JSP) 소스 내용중 conn.colse() 를 주석처리한 후 connection이 반환 되지 않도록 테스트 중  inactive time-out 후 connection 이 강제 반환 되지 않는 현상

When conn.close is not defined on the application source, WebLogic Server doesn't detect JDBC Connection leak, Also connection is not forcely returned to Connection Pool

 

2. 원인

2. Cause

제품 버그이며  BUG 9372936 임

it is Bug 9372936

 

3. 추가 정보

3. Additional info.

 

WebLogic Server 10.0.1, 9.2MP1, 9.1에서 connection leak note detected 에 따른 버그 패치 존재, BUG8123030임

same sympton is detected in WebLogic Server 10.0.1, 9.2MP1, 9.1 and Bug patchs each ver. are like below

제품명               패치ID

product ver.      Patch ID

10g MP1           J388

9.1                   219J

9.2MP1            4ARA

 

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

[WebLogic Administration] increase JTA time-out  (0) 2012.10.17
[WebLogic TroubleShooting] Connecting to t3://localhost:8550 with userid weblogic ... 메세지를 유지한채 장시간 서버가 종료되지 않는다  (0) 2012.10.10
[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