Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 325101

Summary:	cancel sql execution never finishes
Product:	[Tools] Data Tools	Reporter:	arne anka <eclipse-bugs>
Component:	SQLDevTools	Assignee:	dtp.sqldevtools-inbox <dtp.sqldevtools-inbox>
Status:	CLOSED WONTFIX	QA Contact:
Severity:	normal
Priority:	P3	CC:	bpayton
Version:	1.8
Target Milestone:	future
Hardware:	PC
OS:	Linux
Whiteboard:

Description arne anka

2010-09-13 07:24:51 EDT

Build Identifier: I20100608-0911

when executing an sql statement and canceling that statement, the progress view never comes to an end.
instead, the animation in the footer still goes on, and in the progress view the execution is listed as "... (cancel requested)".
last time, i quit eclipse after almost 4 hours since that ongoing little animation was much too annoying ...

Reproducible: Always

Comment 1 Brian Fitzpatrick

2010-09-13 09:42:17 EDT

Can you provide some additional data such as which database you're using? What JDBC driver? Can you provide a reproducible case that we can give a try in something like Derby?

Comment 2 arne anka

2010-09-15 04:31:31 EDT

database is (according to the connection properties' "Version" information):
MySQL 5.0.0 with JDBC 3.0.0

jdbc connectopr i am using is:
mysql-connector-java-5.1.13-bin.jar

i really don't know about a reproducible case, but i recall having seen that kind of behaviour already some years ago (didn't do database development again until recently) and i dimly remember having either seen a bug report concerning that or having posted it by myself (couldn't find it, though) back then.

recently i learned about 
mysql> show processlist
and
mysql> kill <PID>

in mysql which somehow works around the issue.

Comment 3 Brian Payton

2010-09-22 20:07:26 EDT

Unfortunately some databases / JDBC drivers don't respond to a cancel request and just keep going.  Looks like MySQL might be one of them.  Killing the process is probably your best bet here.

Comment 4 arne anka

2016-07-01 05:11:46 EDT

don't use it anymore