[jira] [Commented] (NETBEANS-2537) SQL Editor loses MySQL/MariaDB comments
[ https://issues.apache.org/jira/browse/NETBEANS-2537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16840474#comment-16840474 ] D. Clemons commented on NETBEANS-2537: -- I should probably have remembered to add that after re-creating the user directory, the MySQL error is different. I designated the MySQL 8 JDBC driver's .JAR file, and was able to edit the connection URL with "useSSL=false" but when I click the "Test Connection" button, Netbeans is unable to authenticate to the MySQL instance (specifically MySQL's configuration/admin database), even using a username/password combination that can successfully connect to that database via the command-line. Hope that helps. > SQL Editor loses MySQL/MariaDB comments > --- > > Key: NETBEANS-2537 > URL: https://issues.apache.org/jira/browse/NETBEANS-2537 > Project: NetBeans > Issue Type: Improvement > Components: db - SQL Editor >Affects Versions: 8.2 > Environment: Debian 9 (Stretch), 64-bit. >Reporter: D. Clemons >Priority: Minor > Attachments: After.png, Before.png, messages.log > > > Steps to reproduce: > # Open database in NetBeans. > # Expand DB tree. > # Right click stored procedure and select "Edit." > # Add comments to stored procedure. > # Execute SQL (via icon, in my case). > # Close stored procedure. > # Right-click stored procedure folder and select "Refresh." > # Re-open stored procedure by right-clicking and selecting "Edit." > # Verify that comments have indeed been dropped. > (See attached "Before.png" and "After.png" for illustration.) -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
[jira] [Updated] (NETBEANS-2537) SQL Editor loses MySQL/MariaDB comments
[ https://issues.apache.org/jira/browse/NETBEANS-2537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] D. Clemons updated NETBEANS-2537: - Attachment: messages.log > SQL Editor loses MySQL/MariaDB comments > --- > > Key: NETBEANS-2537 > URL: https://issues.apache.org/jira/browse/NETBEANS-2537 > Project: NetBeans > Issue Type: Improvement > Components: db - SQL Editor >Affects Versions: 8.2 > Environment: Debian 9 (Stretch), 64-bit. >Reporter: D. Clemons >Priority: Minor > Attachments: After.png, Before.png, messages.log > > > Steps to reproduce: > # Open database in NetBeans. > # Expand DB tree. > # Right click stored procedure and select "Edit." > # Add comments to stored procedure. > # Execute SQL (via icon, in my case). > # Close stored procedure. > # Right-click stored procedure folder and select "Refresh." > # Re-open stored procedure by right-clicking and selecting "Edit." > # Verify that comments have indeed been dropped. > (See attached "Before.png" and "After.png" for illustration.) -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
[jira] [Commented] (NETBEANS-2537) SQL Editor loses MySQL/MariaDB comments
[ https://issues.apache.org/jira/browse/NETBEANS-2537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16839488#comment-16839488 ] D. Clemons commented on NETBEANS-2537: -- So no real progress last evening. Previously, when I tried to expand the "Procedures" folders after connecting to a MySQL 8.0 database, the console error-message complained that it couldn't find the "mysql.procs" table. So last night, I installed the MySQL 8 JDBC connector and verified that its .JAR file was added to my $PATH variable. I still can't expand the "Procedures" folder, but there's an additional problem in that I'm no longer able to edit the database URL in Netbeans. That matters because MySQL 8's default authentication wants SSL, and I have to add "=false" to the end of the URL to use plain username/password authentication. So I'm not sure how to proceed from here. > SQL Editor loses MySQL/MariaDB comments > --- > > Key: NETBEANS-2537 > URL: https://issues.apache.org/jira/browse/NETBEANS-2537 > Project: NetBeans > Issue Type: Improvement > Components: db - SQL Editor >Affects Versions: 8.2 > Environment: Debian 9 (Stretch), 64-bit. >Reporter: D. Clemons >Priority: Minor > Attachments: After.png, Before.png > > > Steps to reproduce: > # Open database in NetBeans. > # Expand DB tree. > # Right click stored procedure and select "Edit." > # Add comments to stored procedure. > # Execute SQL (via icon, in my case). > # Close stored procedure. > # Right-click stored procedure folder and select "Refresh." > # Re-open stored procedure by right-clicking and selecting "Edit." > # Verify that comments have indeed been dropped. > (See attached "Before.png" and "After.png" for illustration.) -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
[jira] [Commented] (NETBEANS-2537) SQL Editor loses MySQL/MariaDB comments
[ https://issues.apache.org/jira/browse/NETBEANS-2537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16838204#comment-16838204 ] D. Clemons commented on NETBEANS-2537: -- Hi again Mr. Wielenga. I installed NetBeans 11 on an Ubuntu 18.04 workstation, and can successfully connect to its MySQL 8.0 instance. But I'm currently not able to view the stored prcocedures, and I'm still debugging that error-message. I should have time to continue debugging tomorrow evening, but wanted you to know what I've attempted so far. Thanks! > SQL Editor loses MySQL/MariaDB comments > --- > > Key: NETBEANS-2537 > URL: https://issues.apache.org/jira/browse/NETBEANS-2537 > Project: NetBeans > Issue Type: Improvement > Components: db - SQL Editor >Affects Versions: 8.2 > Environment: Debian 9 (Stretch), 64-bit. >Reporter: D. Clemons >Priority: Minor > Attachments: After.png, Before.png > > > Steps to reproduce: > # Open database in NetBeans. > # Expand DB tree. > # Right click stored procedure and select "Edit." > # Add comments to stored procedure. > # Execute SQL (via icon, in my case). > # Close stored procedure. > # Right-click stored procedure folder and select "Refresh." > # Re-open stored procedure by right-clicking and selecting "Edit." > # Verify that comments have indeed been dropped. > (See attached "Before.png" and "After.png" for illustration.) -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
[jira] [Created] (NETBEANS-2537) SQL Editor loses MySQL/MariaDB comments
D. Clemons created NETBEANS-2537: Summary: SQL Editor loses MySQL/MariaDB comments Key: NETBEANS-2537 URL: https://issues.apache.org/jira/browse/NETBEANS-2537 Project: NetBeans Issue Type: Improvement Components: db - SQL Editor Affects Versions: 8.2 Environment: Debian 9 (Stretch), 64-bit. Reporter: D. Clemons Attachments: After.png, Before.png Steps to reproduce: # Open database in NetBeans. # Expand DB tree. # Right click stored procedure and select "Edit." # Add comments to stored procedure. # Execute SQL (via icon, in my case). # Close stored procedure. # Right-click stored procedure folder and select "Refresh." # Re-open stored procedure by right-clicking and selecting "Edit." # Verify that comments have indeed been dropped. (See attached "Before.png" and "After.png" for illustration.) -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@netbeans.apache.org For additional commands, e-mail: commits-h...@netbeans.apache.org For further information about the NetBeans mailing lists, visit: https://cwiki.apache.org/confluence/display/NETBEANS/Mailing+lists
