5 Replies Latest reply: Jan 21, 2013 3:06 AM by 900719 RSS

    Howto write SQL Developer Extensions in JDeveloper?

    900719
      Hello,

      we want to develop an extension for SQL Developer. We want this extension to appear in the context menu at the table node. We did pretty well developing the necessary Java classes but now we have the problem to integrate our extension to the context menu. So is there any possibility to do this or where we can find some documentation or examples?

      Kind regards
      Jürgen
        • 1. Re: Howto write SQL Developer Extensions in JDeveloper?
          jflack
          Because JDeveloper and SQL Developer share a common code base, developing an extension for SQL Developer is pretty much like developing one for JDeveloper. So the place to start learning this is in the home page for the JDeveloper Extensions SDK - http://www.oracle.com/technetwork/developer-tools/jdev/downloads/index-091862.html.

          You can also find some information on the Oracle Wiki:
          https://wikis.oracle.com/display/oraclesqldeveloper/Getting+Started+with+the+SQL+Developer+SDK
          • 2. Re: Howto write SQL Developer Extensions in JDeveloper?
            rp0428
            >
            we want to develop an extension for SQL Developer. We want this extension to appear in the context menu at the table node. We did pretty well developing the necessary Java classes but now we have the problem to integrate our extension to the context menu. So is there any possibility to do this or where we can find some documentation or examples?
            >
            Make sure you use the correct matching versions of the Extension JDK, JDeveloper and sql Developer.

            See 1. Adding a Context Menu in the 'How To Create an XML User Defined Extension' example
            https://wikis.oracle.com/display/oraclesqldeveloper/How+To+Create+an+XML+User+Defined+Extension

            There are several other examples of extensions here
            https://wikis.oracle.com/display/oraclesqldeveloper/SQL+Developer+SDK+How+To%27s
            >
            Page: How To Create a Java Defined Extension
            Page: How To add a new folder to the database navigator
            Page: How To add a new node to the database navigator
            Page: How To add a new sub folder to the database navigator
            Page: How To create an editor for a Node
            Page: How To create a muliselect nodes action
            Page: How To create an action (rc context) for a Navigator Node
            Page: How To Create an XML User Defined Extension
            • 3. Re: Howto write SQL Developer Extensions in JDeveloper?
              900719
              Hi there,

              first of all, thank you for your answers. I still have one more little question. Is it possiple to launch our extension via the XML extension solution? Cause we've succeeded in applying the XML extension to SQL Developer, but we're not able to launch the extension via the CDATA element. If it's possible, can we gain some information about the actual selected node and provide it to our Java classes?

              Kind regards,
              Jürgen
              • 4. Re: Howto write SQL Developer Extensions in JDeveloper?
                rp0428
                >
                Is it possiple to launch our extension via the XML extension solution? Cause we've succeeded in applying the XML extension to SQL Developer, but we're not able to launch the extension via the CDATA element. If it's possible, can we gain some information about the actual selected node and provide it to our Java classes?
                >
                What do you mean 'launch our extension via the XML extension solution'?

                You need to give an example of what you are trying to do.

                Did you try the XML sampe and the other sample extensions I provided links to?
                • 5. Re: Howto write SQL Developer Extensions in JDeveloper?
                  900719
                  Sorry for not replying to this for such a long time, but I was on vacation the last few weeks :)

                  What I meant with "XML Extension" solution was that: https://wikis.oracle.com/display/oraclesqldeveloper/How+To+Create+an+XML+User+Defined+Extension

                  It was really easy to do that. But what I really asked for was, if it is possible to launch a Java-Class via die CDATA element instead of SQL/PLSQL statements.

                  Best regards