This week's book giveaway is in the OO, Patterns, UML and Refactoring forum.
We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line!
See this thread for details.
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


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: 43905
    
  33
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: 43905
    
  33
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
 
Have you checked out Aspose?
 
subject: Connection is already closed.due to Firewall
 
It's not a secret anymore!