[ 
https://issues.apache.org/jira/browse/NETBEANS-2537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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 "&useSSL=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

Reply via email to