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

Summary:	Stop SQL script execution when the DB connection is broken
Product:	db	Reporter:	Martin Schovanek <mschovanek>
Component:	SQL Editor	Assignee:	Jiri Rechtacek <jrechtacek>
Status:	RESOLVED FIXED
Severity:	blocker
Priority:	P1
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	DEFECT	Exception Reporter:

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