aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Connection is already closed.due to Firewall Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Meteor in Action this week in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Connection is already closed.due to Firewall" Watch "Connection is already closed.due to Firewall" New topic
Author

Connection is already closed.due to Firewall

ramandeep mann
Greenhorn

Joined: Aug 17, 2006
Posts: 13
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

Joined: Aug 17, 2006
Posts: 13
No help here?
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 41848
    
  31
Originally posted by ramandeep mann:
No help here?


Patience Is A Virtue
ramandeep mann
Greenhorn

Joined: Aug 17, 2006
Posts: 13
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
Sheriff

Joined: Oct 13, 2005
Posts: 41848
    
  31
Don't know, I am afraid, but it sounds worthwhile discussing the problem with whoever installed the firewall.
ramandeep mann
Greenhorn

Joined: Aug 17, 2006
Posts: 13
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Connection is already closed.due to Firewall