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 are some actions in DB Explorer which can take quite a long time and they are currently executed in AWT thread, blocking the IDE until they finish, without any progress being displayed, the IDE simply "frozen" (grey). This behaviour must be changed to be correctly responsive, not freezing the IDE. For example here are some times I measured for actions (with trunk build 200403311800, oracle connection using jdbc:oracle:thin to a server on the local network). Of course the times can be much much longer when using a slower DB connection. 1) ADDING A COLUMN to an existing table: 3062ms, 2750ms, 2922ms 2) CREATING A TABLE with a few columns: 703ms, 319ms, 1219ms 3) RECREATE TABLE: 969ms, 500ms, 359ms Note that for example Delete table action is done asynchronously, not blocking the IDE.
4) REFRESH on an expanded table node
add. 1-3: It seems the generated command is not executed in non-AWT thread. Commands executed from command window run in a separate thread.
Hopefully fixed. Actions run in a separate thread.
Sorry, I still see the problem.
Tondo, you mean problem in those 3(4) cases you've mentioned or somewhere else? Thanks
Yes.
Which action do you exactly mean? All mentioned actions run in a separate thread, not in AWT thread. Could you attach a thread dump, please?
Tondo, the FTD, please. Otherwise I close it as fixed or worksworme. I can't see anything wrong.
Created attachment 17559 [details] OptimizeIt window snapshot - creating DB table in AWT thread, blocking it for the time
Thanks for the snapshot, it should be fixed now.
Verified