I use postgreSQL 9.2 as the database and Java 6 as the programming language.
There is no problem when I run my program on the server computer. But when I run my program from a remote client, oftentimes (not always) when I run a query, the program on the client side hangs and the network connection goes RTO (I ping the connection with -t).
There is no exception thrown by the program, it just hangs. But when the program doesn't run any query, the network connection's just fine. There is no RTO.
The connection from client to server goes through 2 hub. It is connected because sometimes the program runs fine. No firewall on both computers.
Has anyone else had this problem before? How do I handle this, there is no timeout exception. Nothing.