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.

Bug 145284 - Ability to change stored procedure text
Summary: Ability to change stored procedure text
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
: 133182 145283 (view as bug list)
Depends on: 165125
Blocks: 152818
  Show dependency tree
 
Reported: 2008-08-27 12:34 UTC by Roman Mostyka
Modified: 2015-04-15 18:37 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Roman Mostyka 2008-08-27 12:34:15 UTC
1. Connect to DB.
2. Create stored procedure.
3. Rightclick it's node.

Result: There is no item in context menu to show text of stored procedure and change it. But user should have ability
not only view stored procedures text, but user should be able also to change it easily in editor.
Comment 1 Jiri Rechtacek 2009-10-16 14:16:06 UTC
Reassigned to new owner.
Comment 2 Jiri Rechtacek 2009-10-23 09:24:24 UTC
*** Issue 145283 has been marked as a duplicate of this issue. ***
Comment 3 matthias42 2012-08-20 07:46:00 UTC
*** Bug 133182 has been marked as a duplicate of this bug. ***
Comment 4 matthias42 2014-09-23 18:44:33 UTC
Closing as fixed - there is a menu entry "Edit" under "View" in netbeans 8.0.1 - at least for supported DBs (derby and informix both fail).
Comment 5 ogj 2015-04-15 11:49:27 UTC
What needs to be done in order to make Informix a supported database here?
Comment 6 matthias42 2015-04-15 18:37:09 UTC
If I'm not totally mistaken, you need to implement an Informix variant of the ProcedureNode, that represents functions/procedures in the GUI.

So if you want to implement support it should be doable:

- Checkout netbeans source
- Open the db project
- Open class org.netbeans.modules.db.explorer.node.ProcedureNode
- The node is created in the static create method beginning in line 10 => there it needs to be detected if you are connected to an informix database
- the second part is implementing the class for the node see org.netbeans.modules.db.explorer.node.ProcedureNode.MySQL for an example (beginning in line 298)

When this is implemented I can give it a look and we can talk about integrating it into netbeans.

With regard to the code you can work with (all repositories are hosted on: http://hg.netbeans.org/):

- core-main is the home of the database code
- main-golden and main-silver are integration repositories

When I started with this I created patches based on main-golden. That repository was the repository that was most stable when it came to be able to build netbeans from it (core-main should be, but -silver and -golden are only updated if basic testing succeeds).

I don't know whether there is a strict limit with regard to patch size before a signed OCA is required, but looking at the MySQL source it is a good chunk of code (~ 250-300 lines are in the mysql class). So I'd suggested making sure you agree to it (http://www.oracle.com/technetwork/community/oca-486395.html#b).

If you feel flashed - don't hesitate to contact me directly I'll try to help with understanding and more info.