고객지원

기술지원 문의

  • 솔인시스템의 전문적인 지원을 받아보실 수 있습니다.

레진에서 제공하는 기본 커넥션 풀을 사용하는데_오라클
양희범 / 2003-07-15 00:00

레진에서 제공하는 기본 커넥션 풀을 사용하는데_오라클

커넥션 갯수에 제한을 따로두는 config 가 있나요?

있다면 어디에서 풀 갯수를 늘릴수 있는건가요?

현제 테스트 중인데 아래와 같은 에러 로그가 나타나서 질문드립니다.

또, 오라클 JDBC 드라이버를 레진에서 자체 제공을 하는것이 있는지도

답변 부탁 드립니다.

---------
java.sql.SQLException: IO x ?: Software caused connection abort: socket write error
java.sql.SQLException: IO x ?: Software caused connection abort: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:389)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:413)
at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:119)
at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:92)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
at ok.NewArticles.setNewList(NewArticles.java:53)
at _board._okboard._sublist__jsp._jspService(_sublist__jsp.java:64)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)

Re:레진에서 제공하는 기본 커넥션 풀을 사용하는데_오라클
관리자 / 2003-07-18 00:00

resin의 db connection pool을 이용한다면
아래

와 같은 형식으로 설정가능합니다.


--양희범 님의 글 [2003-07-15 13:05:38]
>레진에서 제공하는 기본 커넥션 풀을 사용하는데_오라클

커넥션 갯수에 제한을 따로두는 config 가 있나요?

있다면 어디에서 풀 갯수를 늘릴수 있는건가요?

현제 테스트 중인데 아래와 같은 에러 로그가 나타나서 질문드립니다.

또, 오라클 JDBC 드라이버를 레진에서 자체 제공을 하는것이 있는지도

답변 부탁 드립니다.

---------
java.sql.SQLException: IO x ?: Software caused connection abort: socket write error
java.sql.SQLException: IO x ?: Software caused connection abort: socket write error
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:389)
at oracle.jdbc.driver.OracleStatement.(OracleStatement.java:413)
at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:119)
at oracle.jdbc.driver.OraclePreparedStatement.(OraclePreparedStatement.java:92)
at oracle.jdbc.driver.OracleConnection.privatePrepareStatement(OracleConnection.java:950)
at oracle.jdbc.driver.OracleConnection.prepareStatement(OracleConnection.java:802)
at ok.NewArticles.setNewList(NewArticles.java:53)
at _board._okboard._sublist__jsp._jspService(_sublist__jsp.java:64)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:497)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:246)
at com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:164)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)