From: SourceForge.net <no...@so...> - 2012-01-20 20:07:05
|
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 |