All Forums Connectivity
PheobeChang 1 post Joined 11/12
30 Nov 2012
Connection Pool issue(Connection reset by peer: socket write error) with server in DMZ

I am using connection pool with Tomcat 7.  The web server sits in the DMZ, while Teradata is in the internal network.  Port 1025 opened in the web server.  When the application first starts up, everything works fine.  But it seems after a short time, the pooled connection fails, with the following error:
SQLException: [Teradata JDBC Driver] [TeraJDBC] [Error 1000] [SQLState 08S01]
Login failure for Packet transmit Fri Nov 30 07:42:41 CST 2012 socket orig= local=/ remote=/
keepalive=false nodelay=false receive=65156 send=65156 linger=10 traffic=0 concurrent=3 contimeout=10000 conwait=1000
connecttime=0 connecttotaltime=0 connectattempts=1 connectfailures=0 failurecache={} cid=b4ef239 sess=1908 Connection reset by peer: socket write error   at Method)  
at   at ava:136)  
at   at (
at com.teradata.jdbc.jdbc_4.statemachine.SendState.sendPa cket(   at com.teradata.jdbc.jdbc_4.statemachine.StatementSendSta te.action(
at com.teradata.jdbc.jdbc_4.statemachine.StatementControl ler.runBody(   at com.teradata.jdbc.jdbc_4.statemachine.StatementControl
at com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(   at com.teradata.jdbc.jdbc_4.TDStatement.prepareRequest(TD 
at com.teradata.jdbc.jdbc_4.TDPreparedStatement.<init>(TD   at com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement.<ini t>(
at com.teradata.jdbc.jdk6.JDK6_SQL_Connection.constructPr eparedStatement(   at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TD 
at com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TD   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
The same setting (in Tomcat context.xml) works without issues in the DEV and TEST environment (which is inside the firewall).

Your help is very much appreciated.

tomnolan 594 posts Joined 01/08
01 Dec 2012

Are you running Tomcat on Linux? If so, then you may be encountering the "Slow Logon on Linux" problem.

You must sign in to leave a comment.