This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
There needs to be a way to cancel long running queries. When using the DB Explorer to view data, if the query takes too long to execute, there needs to be a way to terminate the process. If you click on the process bar in the bottom right corner and select cancel process, the process doesn't always cancel. It appears that the system is stuck in a wait state watching for data to be returned by the database and cannot process the cancellation request. Method to test: 1) Create a database with 2 tables where a is a parent table of b such that a.foreign_key = b.key Each record should be at least 100 fields in size to simulate poorly designed legacy systems data. 2) Populate each table with 100000 rows of dummy data. 3) Connect via JDBC 4) Select to excecute a command 5) command to execute is select * from a,b where a.foreign_key = b.key 6) Execute the command. 7) After 1 or 2 minutes try to cancel the operation.
Reassigned to new owner.
Created attachment 116634 [details] implement query canceling for the query and requery case
Created attachment 116635 [details] hiding the result component causes display of further queries to fail - patch for this
*** Bug 211121 has been marked as a duplicate of this bug. ***
Patches integrated as http://hg.netbeans.org/core-main/rev/ca4a4299c4e6 Many thanks to Matthias.
Integrated into 'main-golden', will be available in build *201206260002* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress) Changeset: http://hg.netbeans.org/main-golden/rev/ca4a4299c4e6 User: Jaroslav Havlin <jhavlin@netbeans.org> Log: #159929: Unable to cancel long running queries