[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] [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=16839563#comment-16839563 ] Geertjan Wielenga commented on NETBEANS-2537: - Recommend starting with a fresh user directory (the About box shows where it is, close NetBeans, download the user dir, and restart), then when the problems is encountered, paste/upload the log file and message file from the user directory's 'var' folder here so we can try to see what the problem is. > 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=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] [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=16837921#comment-16837921 ] Geertjan Wielenga commented on NETBEANS-2537: - Thanks. Can you try to reproduce with the latest release, i.e., Apache NetBeans 11.0: https://netbeans.apache.org/download/index.html > 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