기술지원 문의

db pool에 관한 질문입니다.
박영훈 / 2003-02-13 00:00

아래와 같은 에러 메시지가 뜨는데 원인이 어떤게 있을까요?
-----------------------------------------------------
java.sql.SQLException: cant create connection from closed pool
at com.caucho.sql.DBPool.createConnection(DBPool.java:1289)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1230)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1106)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1083)
at com.framework.sql.GroupWareConManager.getUserConnection(GroupWareConManager.java:28)
at com.framework.sql.GroupWareConManager.(GroupWareConManager.java:15)
at com.kcce.user.Certification.begin(Certification.java:105)
at com.kcce.user.Certification.loadUser(Certification.java:126)
at _loginaction__jsp._jspService(_loginaction__jsp.java:72)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:311)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:342)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:272)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:536)
---------------------------------------------------------

답변좀 부탁드립니다.

Re:db pool에 관한 질문입니다.
관리자 / 2003-02-18 00:00

Connectin Pool에 연결을 못하고 이유는 기존이용했던
Connection이 끊어져버린 상태인 것 같습니다.

Resin의 경우 Connection Pool설정에 
 이런식으로
명시적으로 설정하지 않는다면
기본적으로 30초입니다. 즉 30초 이내에 재사용되지 않으면
Close됩니다. 물론 이후에 새로운 Request는 새로운
Connection이 생성되고 그놈이 처리를 합니다.

이 에러 메시지만을 가지고 정확한 상황을 예측하기는 
어렵습니다. 

--박영훈 님의 글 [2003-02-13 11:53:18]
>아래와 같은 에러 메시지가 뜨는데 원인이 어떤게 있을까요?
-----------------------------------------------------
java.sql.SQLException: cant create connection from closed pool
at com.caucho.sql.DBPool.createConnection(DBPool.java:1289)
at com.caucho.sql.DBPool.getPooledConnection(DBPool.java:1230)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1106)
at com.caucho.sql.DBPool.getConnection(DBPool.java:1083)
at com.framework.sql.GroupWareConManager.getUserConnection(GroupWareConManager.java:28)
at com.framework.sql.GroupWareConManager.(GroupWareConManager.java:15)
at com.kcce.user.Certification.begin(Certification.java:105)
at com.kcce.user.Certification.loadUser(Certification.java:126)
at _loginaction__jsp._jspService(_loginaction__jsp.java:72)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:485)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:311)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:342)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:272)
at com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at java.lang.Thread.run(Thread.java:536)
---------------------------------------------------------

답변좀 부탁드립니다.