[jira] [Commented] (NETBEANS-1603) I can't see MySQL stored procedures in NetBeans

["Stjepan Brbot (Jira)" <ji...@apache.org>]

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

Stjepan Brbot commented on NETBEANS-1603:
-----------------------------------------

I figured out what is the problem for this bug. For fetching info about MySQL routines (Procedures and Functions) NetBeans uses obsolete table MYSQL.PROC. This table does not even exist in newer MySQL versions. Information about routines in MySQL is now stored in INFORMATION_SCHEMA.ROUTINES table. SQL queries is NetBeans code should be changed.

> I can't see MySQL stored procedures in NetBeans
> -----------------------------------------------
>
>                 Key: NETBEANS-1603
>                 URL: https://issues.apache.org/jira/browse/NETBEANS-1603
>             Project: NetBeans
>          Issue Type: Bug
>          Components: db - MySQL
>    Affects Versions: 8.2
>         Environment: Windows 10
>            Reporter: Stjepan Brbot
>            Priority: Major
>         Attachments: i16Eq.png, lSQYR.png
>
>
> I cannot see or edit MySQL stored procedures in NetBeans IDE 8.2 (Build 201609300101). I can see tables and views but not procedures. I tried different MySQL versions 5.5.62,5.7.23, 8.0.13 as well as different JDBC Connectors 5.1.8, 5.1.47, 8.0.13 but still am not able to see stored procedures. Of course, I see and can manage stored procedures inside the same database in MySQL Workbench.
>  
>  



--
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