Java Interface (deprecated)

Version 0.2.0

To make a generator visible within SQL Developer, implement the oddgen Java interface in a JVM language of your choice such as Java, Scala, Groovy, Clojure, JRuby, Jython or Xtend. oddgen looks for classes implementing the OddgenGenerator interface in JAR files in the SQL Developer extension directory. This allows you to distribute your client generators as a SQL Developer extension or an ordinary JAR file. See Tutorial 3 – Extended 1:1 View Generator (Xtend) for an example how to create a client generator.

The Java interface is very similar to the PL/SQL interface. Basically there are three differences:

  • Every method of the Java interface has a parameter named conn to access the active database connection.
  • The method getParams returns a LinkedHashMap, this means the parameters are ordered by entry. Hence no equivalent for the PL/SQL method get_orderd_params is necessary.
  • Every method of the Java interface must be implemented.

This interface version is deprecated. Please see Java Interface for the current definitions.


oddgen for SQL Developer is completely developed in Xtend, mainly because of its excellent template expression support. However, for the interface itself the language does not really matter. Here’s the interface in Java, based on OddgenGenerator.xtend:


Here’s an example of a simple oddgen Java interface implementation, based on HelloWorldClientGenerator.xtend: