[Squirrel-sql-users] Squirrel SQL Client Failing

[Paul M. <pau...@sp...>]

On many occasions, I have received the following stacktrace while 
running squirrel sql client.  It will cause my connection to my remote 
db to drop and I will have to open a new session instance.  I do use the 
SessionConnectionKeepAlive run method with 'SELECT 1;'

org.postgresql.util.PSQLException: An I/O error occured while sending to 
the backend.
     at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:281)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:555)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
     at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:283)
     at 
net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive.run(SessionConnectionKeepAlive.java:78)
     at 
net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
     at java.lang.Thread.run(Thread.java:679)
Caused by: java.net.SocketException: Connection reset
     at java.net.SocketInputStream.read(SocketInputStream.java:185)
     at 
org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:143)
     at 
org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:112)
     at 
org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:71)
     at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:269)
     at 
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1700)
     at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
     ... 6 more


Thank you for the help.