com.ibm.db2.jcc.b.DisconnectException: [ibm][db2][jcc][t4][2030][11211] 통신 오류 발견됨. 사용 중인 통신 프로토콜: TCP/IP.
사용 중인 통신 API: SOCKETS. 오류가 발견된 위치: T4Agent.sendRequest().
오류를 발견한 통신 함수: OutputStream.flush(). 프로토콜 특정 오류 코드 파이프에 기록된 데이터를 읽을 프로세스가 없습니다
., *, 0. 메시지: 파이프에 기록된 데이터를 읽을 프로세스가 없습니다.
at com.ibm.db2.jcc.a.a.a(a.java:365)
at com.ibm.db2.jcc.a.a.A(a.java:334)
at com.ibm.db2.jcc.a.a.n(a.java:292)
at com.ibm.db2.jcc.b.p.c(p.java:280)
at com.ibm.db2.jcc.b.oh.d(oh.java:2345)
at com.ibm.db2.jcc.b.oh.T(oh.java:426)
at com.ibm.db2.jcc.b.oh.executeQuery(oh.java:409)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at com.kbstar.pdm.deployengine.timer.ReverseDeployTimer.runReverseDeploy(ReverseDeployTimer.java:175)
at com.kbstar.pdm.deployengine.timer.ReverseDeployTimer.run(ReverseDeployTimer.java:132)
at java.util.TimerThread.mainLoop(Timer.java:537)
at java.util.TimerThread.run(Timer.java:487)
Caused by: java.net.SocketException: 파이프에 기록된 데이터를 읽을 프로세스가 없습니다.
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:105)
at java.net.SocketOutputStream.write(SocketOutputStream.java:149)
at com.ibm.db2.jcc.a.gb.b(gb.java:1534)
at com.ibm.db2.jcc.a.gb.a(gb.java:1483)
at com.ibm.db2.jcc.a.a.A(a.java:328)
... 11 more
위의 에러가 도대체 언제 발생하는건지 모르겠네요....물론 connection pool을 이용하여 처리하고 있습니다..pool설정내역은 아래와 같습니다..
<?xml version="1.0" encoding="euc-kr"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd">
<sqlMapConfig>
<settings cacheModelsEnabled="true" enhancementEnabled="true"
lazyLoadingEnabled="true" maxRequests="512" maxSessions="128"
maxTransactions="32" useStatementNamespaces="true" />
<!-- ################################################################### -->
<!-- HOST DB연결을 위한 CONNECTION POOL설정 -->
<!-- ################################################################### -->
<transactionManager type="JDBC">
<dataSource type="DBCP">
<property name="driverClassName" value="${ZAPA.jdbc.driver}" />
<property name="url" value="${ZAPA.jdbc.url}" />
<property name="username" value="${ZAPA.jdbc.id}" />
<property name="password" value="${ZAPA.jdbc.password}" />
<property name="maxActive" value="100" /> <!-- 커넥션이 제공하는 최대개수 -->
<property name="initialSize" value="5" /> <!-- 초기생성 커넥션개수 -->
<property name="removeAbandoned" value="true" />
<property name="poolPreparedStatements" value="true" />
<property name="maximumActiveConnections" value="30" />
<property name="maximumIdleConnections" value="5" /> <!-- 대기하는 최대 커넥션개수 -->
<property name="maximumWait" value="60000" /> <!-- 대기시간 -->
<property name="logAbandoned" value="false" />
<property name="removeAbandoned" value="false" />
<property name="removeAbandonedTimeout" value="50000" />
</dataSource>
</transactionManager>
${sqlMaps}
</sqlMapConfig> |
