We are seeeing connection timeout problems via teradata java driver v13.10. We tried to set the connection keep alive from the connection pool manager, still no luck. we still the socket failure excrption. Any pointers what could be done to get around this issue? Any solution ASAP would really help.
According to the stack trace you posted, you are using Teradata JDBC Driver 13.10.00.31.
You should upgrade to a newer version of the Teradata JDBC Driver; for example, Teradata JDBC Driver 13.10.00.35, that includes the fix for JDBC DR 155367 "Intermittent socket communication failures when using setQueryTimeout with large result sets"
Assuming that you obtain that fix, if you continue to receive Error 804, please be aware that Error 804 can occur for different reasons. The exception error message is important for distinguishing the different error conditions.
Typically, Error 804 with the error message "Socket communication failure for Packet receive" means that a network communication failure occurred. This can be due to a variety of reasons, such as:
1. Network problem
2. Teradata Database restart
3. Teradata session was aborted by Teradata Manager, Teradata Viewpoint, or some other administrator process that aborts idle sessions
Will upgrade the driver and see if the exception goes away [apart from validating that the conns are not getting killed]