I have a query which is taking more then 2 hours to run on a remote machine .But my application server is behind the firewall so the firewall is dropping the ideal connection (waiting for results )after every hour .
Please help me .Is there a way to maintain connection .
========================================================== Caught IOException: com.sybase.jdbc2.jdbc.SybConnectionDeadException: JZ0C0: Connection is already closed. at com.sybase.jdbc2.jdbc.ErrorMessage.createIOEKilledConnEx(ErrorMessage.java:775) at com.sybase.jdbc2.jdbc.ErrorMessage.raiseErrorCheckDead(ErrorMessage.java:816) at com.sybase.jdbc2.tds.Tds.handleIOE(Tds.java:3491) at com.sybase.jdbc2.tds.Tds.nextResult(Tds.java:2043) at com.sybase.jdbc2.jdbc.ResultGetter.nextResult(ResultGetter.java:69) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:220) at com.sybase.jdbc2.jdbc.SybStatement.nextResult(SybStatement.java:203) at com.sybase.jdbc2.jdbc.SybStatement.executeLoop(SybStatement.java:1766) at com.sybase.jdbc2.jdbc.SybStatement.execute(SybStatement.java:1758) at com.sybase.jdbc2.jdbc.SybPreparedStatement.execute(SybPreparedStatement.java:619) at TestDbConnect.connect(TestDbConnect.java:55) at TestDbConnect.main(TestDbConnect.java:82)
Well its a old application using Sybase as database e have more then 113 million records to process so time taken by it is normal.
I am getting your point but application was working fine from last 10 years before this new firewall was installed.
What we tried so far.. 1.Ran a new thread calling the query on same connection but this query went into the sybase queue and is getting processed after the first query complete .So it was a fail attempt.What ever we are calling on sybase is being sent to a queue.so e are not able to keep connection busy to be up for long.
2.changing firewall setting is not a option with us.
3.We tried to make a socket connection on the same port so tht it is busy .and ran setKeepalive function on it.
Joined: Oct 13, 2005
Don't know, I am afraid, but it sounds worthwhile discussing the problem with whoever installed the firewall.
Joined: Aug 17, 2006
I agree but is there a way to identify how Firewall is able to attenuate the connection.I don't see it killing the process on the specific Port.
How come a firewall detect the Connection object being ideal for two hours?.Thats funny