Author: Dima Fedotov <billy(at)dautkom(dot)lv>
Page: 7.4/jdbc-datasource.html
----
(sorry for my bad english)
I have maked simple example using connection pool. I test situation when connection between db-server and client are broken.
My test client gets connection from pool, do some transactions and put connection back to pool (using con.close()).
If restart postgres while client is working, all established connections from pool becomes not functional. If call con.close() connection puts back to pool, but it not working! If do not call con.close, then after few restarting of postgres pool riches maximum connection count.... How to invalidate not working connections?