Database connection pooling is useful and common feature for performance. However there are some cavets.
Sometimes your sql query just got timed out, and you wonder why.
If you suspect the TCP connection between your application hosted in DMZ to the database (which is usually sits behind a firewall) got dropped by the firewall. It is very likely firewall has a policy to terminate any idle connection.
Let’s go back to the basics to use Netcat.
nc -v -l 9999
Client (DMZ machine):
Assuming port 9999 is allowd on the firewall.
Let’s assume the firewall drops the connection after 30 minutes idle time, then the nc will be broken after 30 minutes.