[Eclipsesql-bugs] [ eclipsesql-Bugs-3466577 ] GUI freezes when connection times out

[SourceForge.net <no...@so...>]

Bugs item #3466577, was opened at 2011-12-28 13:52
Message generated for change (Comment added) made by hhilbert
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3466577&group_id=132863

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Mark (siking1)
Assigned to: Nobody/Anonymous (nobody)
Summary: GUI freezes when connection times out

Initial Comment:
Running:
- Linux Mint 12 (AMD64)
- Eclipse 3.7.1
- OpenJDK 1.6.0_23-b23
- SQL Explorer 3.6.1
- db2jcc4-9.7.100.177.jar connector

Open a connection to a database, and allow the connection to time out. After time out, try to close the connection. The entire GUI freezes up and has to be force-killed.

FYI: I have seen this exact same behaviour with SQuirreL, which I believe SQL Explorer is at least partially based on.

----------------------------------------------------------------------

Comment By: Heiko Hilbert (hhilbert)
Date: 2012-01-20 12:07

Message:
You can check the possible parameters for your db2 JDBC driver. Perhaps you
can define connection timeouts there. Or there are java system properties
that could be set fpr your driver?


----------------------------------------------------------------------

Comment By: Mark (siking1)
Date: 2012-01-20 10:36

Message:
I am still hitting this issue, even after the above suggested workaround. I
can provide additional information, but I do not know what would be
relevant.

----------------------------------------------------------------------

Comment By: Mark (siking1)
Date: 2011-12-29 15:04

Message:
Thanx hhilbert. I have been running with this all day, and it works
perfect.
Happy holidays! ;)

----------------------------------------------------------------------

Comment By: Heiko Hilbert (hhilbert)
Date: 2011-12-29 01:18

Message:
Probably this is a problem with the underlying db2 JDBC driver. The call to
close the connection on a timed out connection will never return.
A workaround is to use the new preference:
Close unused connections after (seconds)
If you set it to a value lesser then the db2 connection timeout the
connection is closed before time out. If you don't need connection specific
db values like temp tables or sql session values you can set this value as
small aus you like. SQL Explorer creates a new connection if required.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=725495&aid=3466577&group_id=132863