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

Summary:	Ability to change stored procedure text
Product:	db	Reporter:	Roman Mostyka <romanmostyka>
Component:	Code	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	RESOLVED FIXED
Severity:	blocker
Priority:	P2
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:
Bug Depends on:	165125
Bug Blocks:	152818

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.