Re: [Squirrel-sql-develop] JDBC Cancel request

Hello Gerd,

thank you for the info.
I forwarded it to the support of Progress, they managed to reproduce the issue and will discuss it with their development.


Stefan


-----Original Message-----
From: Gerd Wagner [mailto:ger...@t-...] 
Sent: Samstag, 5. November 2016 11:42
To: Marquardt Stefan; squ...@li...
Subject: Re: [Squirrel-sql-develop] JDBC Cancel request

SQuirreL uses the mechanism you mention. Here is what it does in a bit of detail:
1. Queries are executed in separate threads which prevents SQuirreL from freezing and is needed to make the cancel button actually accessible.
2. When the cancel button is clicked another thread is started. In this thread statement.cancel() is called. If this thread does not finish within 1500 milli seconds a time out message is written to the message panel. But even if after the time out statement.cancel() succeed or fails an according message is written to the message panel.

The core of the implementation can bee seen here:
https://sourceforge.net/p/squirrel-sql/git/ci/master/tree/sql12/core/src/net/sourceforge/squirrel_sql/client/session/CancelStatementThread.java

So your problem I think should be different one. Could you please have a look at the logs after the problem appeared an see if there is more information. If so please post it.

Gerd



==================================
Hannover Rück SE, Handelsregister (Commercial Register) Hannover HRB 6778 / E+S Rückversicherung AG, Handelsregister (Commercial Register) Hannover HRB 6117; für beide Gesellschaften gilt (applicable to both companies): Karl-Wiechert-Allee 50, 30625 Hannover, Germany; Sitz (registered office) der Gesellschaften: Hannover; Aufsichtsrat (Supervisory Board): Herbert K. Haas (Vorsitzender/Chairman); Vorstand (Executive Board): Ulrich Wallin (Vorsitzender/Chairman), Sven Althoff*, Claude Chèvre*, Jürgen Gräber*, Dr. Klaus Miller, Dr. Michael Pickel, Roland Vogel (*nur Mitglied des Vorstands der Hannover Rück SE/member of the Hannover Rück SE Executive Board only)