You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@netbeans.apache.org by "Eric Bresie (Jira)" <ji...@apache.org> on 2021/03/20 18:03:00 UTC

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

    [ https://issues.apache.org/jira/browse/NETBEANS-5257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17305525#comment-17305525 ] 

Eric Bresie commented on NETBEANS-5257:
---------------------------------------

Is this maybe related to NETBEANS-189 "SQL editor, shouldn't ask evertime to set the connection"?  If a connection is set then those problems may not happen.  Or am I missing something?

> 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
>            Priority: Minor
>
> 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