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 172298 - Stop SQL script execution when the DB connection is broken
Summary: Stop SQL script execution when the DB connection is broken
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: All All
: P1 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-15 15:25 UTC by Martin Schovanek
Modified: 2009-09-18 22:18 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Martin Schovanek 2009-09-15 15:25:51 UTC 
[#200909140908, jdk1.6]

to reproduce:
-------------
1) connect to a MySQL db
2) restart (shutdown) the MySQL
NOTE: so the original connection is broken
3) execute a SQL script
ERROR: IDE throws Connect and Err dialogs for each SQL statement

a) IDE should stop script execution in such cases
b) we should not allow to open more then one Connect dialog at onec

I have 275 line long .sql file and it reliably killing my IDE. Next have problem to kill the IDE because the OS is
almost unresponsive due flood of Connect modal dialogs => P1.
Comment 1 Jiri Rechtacek 2009-09-16 09:20:36 UTC 
Martin, could you attach your messages.log when it'd appeared? And attach (or send me by email) your script. Thanks
Comment 2 Jiri Rechtacek 2009-09-16 09:56:30 UTC 
I can reproduce the problem myself, I'm fixing it...
Comment 3 Jiri Rechtacek 2009-09-16 14:57:22 UTC 
core-main/rev/cf3e4bd68dfd
Comment 4 Quality Engineering 2009-09-18 22:18:10 UTC 
Integrated into 'main-golden', will be available in build *200909181401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/cf3e4bd68dfd
User: Jiri Rechtacek <jrechtacek@netbeans.org>
Log: #172298: Stop SQL script execution when the DB connection is broken