• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

Connection is already closed.due to Firewall

 
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

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)

==========================================================
 
ramandeep mann
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
No help here?
 
Marshal
Posts: 64654
225
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Originally posted by ramandeep mann:
No help here?



Patience Is A Virtue
 
ramandeep mann
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Campbell Ritchie
Marshal
Posts: 64654
225
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Don't know, I am afraid, but it sounds worthwhile discussing the problem with whoever installed the firewall.
 
ramandeep mann
Greenhorn
Posts: 13
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!