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

["Peter (Jira)" <ji...@apache.org>]

Peter created NETBEANS-5257:
-------------------------------

             Summary: Executing a series of SQL statements when not connected fails on every statement
                 Key: NETBEANS-5257
                 URL: https://issues.apache.org/jira/browse/NETBEANS-5257
             Project: NetBeans
          Issue Type: Improvement
          Components: db - SQL Editor
    Affects Versions: 12.2
            Reporter: Peter


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.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@netbeans.apache.org
For additional commands, e-mail: commits-help@netbeans.apache.org

For further information about the NetBeans mailing lists, visit:
https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists