...For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).

* 오류 로그

...

...

....

Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The driver was unable to create a connection due to an inability to establish the client portion of a socket.

This is usually caused by a limit on the number of sockets imposed by the operating system. This limit is usually configurable. 

For Unix-based platforms, see the manual page for the 'ulimit' command. Kernel or system reconfiguration may also be required.

For Windows-based platforms, see Microsoft Knowledge Base Article 196271 (Q196271).

at sun.reflect.GeneratedConstructorAccessor57.newInstance(Unknown Source)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.lang.reflect.Constructor.newInstance(Unknown Source)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)

at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:342)

at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2188)

at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2037)

... 38 more

Caused by: java.net.BindException: Address already in use: connect

at java.net.DualStackPlainSocketImpl.connect0(Native Method)

at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)

at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)

at java.net.AbstractPlainSocketImpl.connect(Unknown Source)

at java.net.PlainSocketImpl.connect(Unknown Source)

at java.net.SocksSocketImpl.connect(Unknown Source)

at java.net.Socket.connect(Unknown Source)

at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)

at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:301)

... 40 more

* 오류 원인

https://m.blog.naver.com/PostView.nhn?blogId=wisthood00&logNo=140162034480&proxyReferer=https%3A%2F%2Fwww.google.com%2F

루프문에서 빠른 속도로 DB 접근.

짧은 시간 Socket 접속으로 포트 한계까지 열게 됨.

* 해결 1 - 레지스트리에서 포트 한계 늘리기

regedit 실행

 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters

 Value Name: MaxUserPort·               Data Type: REG_DWORD·               Value: 65534

입력 (없으면 새로 추가)

재부팅 없이 WAS만 재기동하고 바로 오류 없어졌음.

https://www.programering.com/a/MTMyEjNwATE.html

* 해결 2 - DataSource 바꾸는 방법

http://stefanlearninglog.blogspot.com/2010/06/running-out-of-connections-when.html

안 해봄

* 기타

세션 close와는 무관함