This discussion is archived
1 Reply Latest reply: Aug 11, 2012 2:54 AM by odie_63 RSS

extension.xml and catching compile event in sql developer

955166 Newbie
Currently Being Moderated
Hi,

recently I've been trying to make a few plug-in/extensions for sql developer. One allows you to search through entire schema to find and procedures or functions that utilize any given procedure or function, this one works fine. The second one and the one that is giving me trouble is an extension that allows you to see if any items (procedures, functions,...) are broken, the goal with this one is for it to do this task automatically when a procedure or function is compiled to show if the compilation of the function or procedure broke anything else. I have this one working as a button in the toolbar and choice in the main menu, but I can not for the life of me figure out how to hook it on to a compile or run event. Please help!!!!

here is my extension file so far:



<extension id="brokenSearch" version="1.0" esdk-version="1.0" rsbundle-class="infinTech.brokensearch.Res"
xmlns="http://jcp.org/jsr/198/extension-manifest">
<name>Broken Search</name>
<dependencies>
<import>oracle.jdeveloper.db.connection</import>
<import>oracle.ide</import>
</dependencies>
<trigger-hooks xmlns="http://xmlns.oracle.com/ide/extension">
<!-- TODO Declare triggering functionality provided by extension: infinTech.schemasearch -->
<triggers>

</triggers>
</trigger-hooks>
<hooks>
<!-- TODO Declare functionality provided by the yourcompany.showmepassword extension. -->
<jdeveloper-hook xmlns="http://xmlns.oracle.com/jdeveloper/1013/extension">
<actions>
<action id="infinTech.brokenitems.BrokenItems">
<properties>
<property name="Name">Broken Items</property>
<property name="SmallIcon">${OracleIcons.PLACEHOLDER}</property>
<property name="LongDescription">Broken Items</property>
</properties>
<controller-class>infinTech.brokensearch.ShowMeDatabasePasswordController</controller-class>
<command-class>infinTech.brokensearch.ShowMeDatabasePasswordCommand</command-class>
</action>
</actions>
     
     <context-menu-listeners>
<site idref="navigator">
<listener-class>infinTech.brokensearch.MenuContextMenuListener</listener-class>
</site>
<site idref="editor">
<listener-class>infinTech.brokensearch.MenuContextMenuListener</listener-class>
</site>
<site idref="explorer">
<listener-class>infinTech.brokensearch.MenuContextMenuListener</listener-class>
</site>
</context-menu-listeners>
     
</jdeveloper-hook>

<!-- Hook into menus and toolbars -->
<menu-hook>
<menus>
<!--
Add the action in its own separator group at the top of the File
menu.
-->
<menubar id="javax.ide.view.MAIN_WINDOW_MENUBAR_ID">
<menu id="javax.ide.VIEW_MENU_ID">
<section id="schema.search"
before="javax.ide.NEW_SECTION_ID">
<item action-ref="infinTech.brokenitems.BrokenItems"/>
</section>
</menu>
</menubar>

</menus>

<toolbars>
<toolbar id="javax.ide.view.MAIN_WINDOW_TOOLBAR_ID">
<section id="SCHEMA_SEARCH_SEACTION" weight="2.0">

<item action-ref="infinTech.brokenitems.BrokenItems"/>
</section>
</toolbar>
</toolbars>
</menu-hook>


<feature-hook>
<description>Simple utility that finds any/all broken items.</description>
</feature-hook>
</hooks>
</extension>

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points