Thanks for the background, Chris! As well as the warning dialog pop-up about no SQL connection, I believe Netbeans also logs the message to the status bar at the bottom?
I think the ideal solution would be support for multiple SQL dialects (with ability to add more via plugin), with the option to chose which dialect is parsed from a drop-down on the SQL editor (similar to a SQL plugin I've seen for IntelliJ) That seems a lot of work though, so a quick win to get the already included SQL completion more visible / usable might be: 1) Change the auto pop-up logic so it pops up after first character typed (and filters on this), rather than only after . 2) Remove the dialog about no SQL connection popping up, so the error is just on the status bar at the bottom of NB? 3) Just klimming to code, I've got a feeling the code completion will hang on completion (with the Please wait... message) after a . if no SQL connection is made. So that should be handled gracefully. Thoughts, anyone? P On Tue, 31 Mar 2020, 11:33 Christian Lenz, <[email protected]> wrote: > Hey Pete, > > I think your ticket https://issues.apache.org/jira/browse/NETBEANS-188 is > dependent from the other with the missing Connection > https://issues.apache.org/jira/browse/NETBEANS-189. So the Problem is, if > 189 is not resolved, 188 doesn’t make sense. Because, as often as you type, > and the Code completion Comes up immediately, it Shows you the Dialog of > missing Connection, when you have a simple SQL file w/o a Connection to a > DB which is annoying. > > > Cheers > > Chris > > > > > Von: Pete Whelpton > Gesendet: Dienstag, 31. März 2020 11:51 > An: [email protected] > Betreff: Re: Auto completion support for Database languages. > > One thing I noticed about the basic SQL completion in Netbeans, the > getAutoQueryTypes(JTextComponent component, String typedText) method > of SQLCompletionProvider.java starts with the following: > > if (!".".equals(typedText)) { > return 0; > } > > which means the Code Completion dialog won't pop-up automatically, > except after a . character. So it will offer auto-completion for > things like column names for fully qualified columns ([table].[column] > etc.), but not SQL keywords - which can make it appear that Netbeans > has no SQL completion at all! Code completion dialog, including SQL > keywords, will still pop-up when hitting Ctrl-Space though... > > Chris L logged a Jira about it: > https://issues.apache.org/jira/browse/NETBEANS-188 > > I assumed that code was there for a reason, so was hesitant to remove > it. But if there is no good reason to suppress the Code Completion > dialog, perhaps that code should be removed? I'd be happy to do the > PR. > > > Also, the list of supported SQL keywords is very basic, and based on > the SQL-99 Complete book. See > /ide/dbapi/src/org/netbeans/modules/db/api/sql/SQLKeywords.java > > Hope that helps! > > P > > > On Tue, Mar 31, 2020 at 12:42 AM Tim Boudreau <[email protected]> wrote: > > > > Well, that shows how often I do SQL in anything other than a text console > > :-) > > > > -Tim > > > > On Mon, Mar 30, 2020 at 4:04 PM Matthias Bläsing < > [email protected]> > > wrote: > > > > > Hi, > > > > > > Am Montag, den 30.03.2020, 21:04 +0600 schrieb Brain Rebooting: > > > > Is there any possibility that Netbeans will support autocompletion > for > > > > database language like IntelliJ Idea in the near future? > > > > > > there already is. Create a ".sql" file and connect to a DB. You will > > > get SQL completion and syntax highlighting. > > > > > > It is currently tied to a connected DB, but it could be improved. An > > > issue is already filed for this: > > > > > > https://issues.apache.org/jira/browse/NETBEANS-189 > > > > > > Greetings > > > > > > Matthias > > > > > > > > > --------------------------------------------------------------------- > > > To unsubscribe, e-mail: [email protected] > > > For additional commands, e-mail: [email protected] > > > > > > For further information about the NetBeans mailing lists, visit: > > > https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists > > > > > > > > > > > > -- > > http://timboudreau.com > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > For further information about the NetBeans mailing lists, visit: > https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists > > > > >
