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