[NETBEANS-5257] Executing a series of SQL statements when not connected fails on every statement

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 12.2
• Component/s: db - SQL Editor
• Assignee: Unassigned
• Reporter: Peter
• Created: 17/Jan/21 21:13
• Updated: 20/Mar/21 18:02

Description

When executing a script from the SQL editor to a data source that is not already logged in/connected, every single statement fails and each results in a dialog box requesting the password. The result is a stack of password requests so deep that the IDE will no longer accept any input. It is not possible to dismiss any of the dialogs or interact with Netbeans itself. The only recourse is to use "kill" from the OS.

This problem is exacerbated by the fact that the connection to the database is sometimes silently closed, resulting in the stack of password boxes without warning.  As a result, my workflow now includes checking the status of the connection before executing any SQL scripts lest I end up having to kill off the IDE.

The "fix" would be to pause (or stop) executing the script until the user has entered the password in the first dialog box, then continue.