This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
If I use the Execute Command window to run a SELECT statement, the results are displayed in the lower half of the window. If I use it to execute a stored procedure that returns a result set, all I see is a dialog saying 'Command successfully executed' - the results are not displayed. Since we have an audit requirement that all database access should be done through SPs, it's a major limitation not to be able to test them...
You are right. The results are displayed only for SELECT statements. Stored procedures may return multiple result sets and the Execute Command window isn't designed to display more then one result set. (This window was originally designed to execute SELECT statements only and the possibility to execute other kinds of SQL/DDL commands was added later.) We are working on new generation of the Database Explorer module which should be able to display more result sets. This new module is based on different architecture and we write the module from the scratch. That's why I changed the issue type from DEFECT to ENHANCEMENT - we don't plan to add any new features to the current module. We don't work on it any more and we fix the most critical bugs only. What can I try to do is to display the results for stored procedures which return a simple result set only. If you want to display the results for stored procedures which return multiple result sets in the current module you can try to modify the current implementation of the Execute Command window and contribute it. It should not be difficult (good starting point is org.netbeans.modules.db.explorer.dataview.DataViewWindow class).
Target milestone -> 3.3.1.
Will be investigated for new module based on MDR.
Resolved for 3.3.x or earlier, no new info since then -> closing.
A mistakenly closed RESOLVED LATER/REMIND issue. Reopening.
I can't tell - is this working now for a single result set?
Not sure and I don't have time to check it now. From a quick look at the code I think it should work. Could you please try it? E.g. with a simple SP on Derby? Thanks.
Yes, I'll give it a try.
*** Issue 127596 has been marked as a duplicate of this issue. ***
Fixed.
Verified with build 080714.