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.

Bug 188303

Summary: Make 'Run SQL' with SELECT statements non-blocking
Product: db Reporter: tomzi <tomzi>
Component: SQL EditorAssignee: Jiri Rechtacek <jrechtacek>
Status: RESOLVED DUPLICATE    
Severity: normal    
Priority: P3    
Version: 6.x   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Exception Reporter:

Description tomzi 2010-07-02 07:28:09 UTC
When I execute a batch statement with a lot of selects:

select * from User.Table1;
select * from User.Table2;
select * from User.Table3;
select * from User.Table4;
select * from User.Table5;
select * from User.Table6;
select * from User.Table7;

The IDE is blocked until the batch statement is executed. This could sometimes take a while.

Interestingly the IDE does not block if I execute:

delete from Table1;
insert into Table1.....

Please make the 'Run SQL' with 'Select' statements non-blocking.
Comment 1 Jiri Rechtacek 2011-01-06 14:24:29 UTC
The executing SELECT statements is not-blocking but displaying the results (constructing tables) has to run in AWT thus this part of execution blocks rest of IDE. So, the matter to solving is speedup of displaying the result - already tracked as issue 181028.

*** This bug has been marked as a duplicate of bug 181028 ***