You can add new folders and nodes to navigators, new actions on objects (*or sets of them*), and new editors or viewers.

Depending on requirements, this can be done in either XML or java and deployed by simply copying an XML file to the appropriate directory, or creating an extension jar -- or *check for updates* bundle for XML and/or java.

* [ConnectionHelper](java/ConnectionHelper)

Optionally accept connection info from the command line and/or on a [SocketServer](https://docs.oracle.com/javase/tutorial/networking/sockets/clientServer.html)

* [ConnectionHelperClient](java/ConnectionHelperClient)

A simple command line client for the ConnectionHelper socket server.

* Added resource reference for Philipp Salvisberg's [Example-based tutorials](https://github.com/PhilippSalvisberg/sqldev) to extend SQL Developer functionality. (external)

* [Set Up / Tutorial](./setup.md) - A step by step guide to building your first extension and check for updates bundle.

* ["Simple" User Extensions (XML)](xml)

* [XML Based Favorites Example](xml/favorites)

* [Standard Extensions (java)](java)

* [Check For Updates (cfu)](cfu)

Please note these are links to external resources. They are not supplied or supported by Oracle.

* [Example Update Center](https://github.com/bjeffrie/sqldev-update-center) (external) with pre-built cfu bundles for these examples.

* Philipp Salvisberg's [Example-based tutorials](https://github.com/PhilippSalvisberg/sqldev) to extend SQL Developer functionality. (external)

Optionally accept connection info from the command line and/or on a [SocketServer](https://docs.oracle.com/javase/tutorial/networking/sockets/clientServer.html)

sqldeveloper -_conName_**=**_user_\[**/**\[_pw_]]**@**_host_**:**_port_(**:**_sid_|**/**_svc_)\[**#**_role_]

[extension.xml](ext/extension.xml) declares [ConnectionHelperPreferencePanel](src/oracle/db/example/sqldeveloper/extension/connectionHelper/ConnectionHelperPreferencePanel.java) as a trigger hook so the extension will be fully loaded once the preference page is opened and [ConnectionHelperAddin](src/oracle/db/example/sqldeveloper/extension/connectionhelper/ConnectionHelperAddin.java) as an Addin whos initialize method will be called on SQLDeveloper start up.

[ConnectionHelper](src/oracle/db/example/sqldeveloper/extension/connectionhelper/ConnectionHelper.java) is where the 'do the work' stuff lives.

1. Creates the requested connection in a "Persistent" or "Transient" folder

3. If transient, sets up a hook to remove the connection when SQLDeveloper shuts down

[ConnectionHelperAddin](src/oracle/db/example/sqldeveloper/extension/connectionhelper/ConnectionHelperAddin.java) adds an IdeListener to process ConnectionHelper options once the main window comes up. *(TODO:? Show non-deprecated technique for doing something after the window finishes loading? See OptInHandler$DialogWaitTask)*

[ConnectionHelperPreferenceModel](src/oracle/db/example/sqldeveloper/extension/connectionhelper/ConnectionHelperPreferenceModel.java) is the data class for managing connection helper preferences and integrating with the core preference storage.

[ConnectionHelperPreferencePanel](src/oracle/db/example/sqldeveloper/extension/connectionHelper/ConnectionHelperPreferencePanel.java)


* Accept command line connections - Parse SQLDeveloper command line for connection request(s) when checked and on subsequent SQDeveloper start up. *[false]*

* Persist command line connections - Persist connection(s) specified on the command line. Also controls (Persistent/Transient) folder the connection(s) will be placed in. *[false]*

* Autostart connection server - Start the ConnectionHelperServer when checked and on subsequent SQDeveloper start up. *[false]*

* External connection server port - the port to listen for connection requests on. *[51521]*

* Persist external connections - Persist connection(s) received by the ConnectionHelperServer. Also controls (Persistent/Transient) folder the connection(s) will be placed in. *[false]*

* *(TODO:? Replace button actions to start command line/server with property listeners on the preference properties so nothing happens until you OK the preference changes?)*

[ConnectionHelperServer](src/oracle/db/example/sqldeveloper/extension/connectionHelper/ConnectionHelperServer.java) is a [SocketServer](https://docs.oracle.com/javase/tutorial/networking/sockets/clientServer.html) that listens for connection requests on a specified port *[51521]*

import java.util.ArrayList;

import oracle.dbtools.util.Logger;

// Only process command line args once no matter how many times

// the preference is changed while running

/**

if (!processedCommandLineArgs) {

boolean persist = ConnectionHelperPreferenceModel.getInstance().isPersistCommandLineConnections();

ConnectionHelper.processPotentialConnectionArgument(arg, persist);

}

}

/**

public static void processPotentialConnectionRequest(String arg) {

processPotentialConnectionArgument(arg, ConnectionHelperPreferenceModel.getInstance().isPersistExternalConnectionServerConnections());

private static void processPotentialConnectionArgument(String arg, boolean persist) {

String folder = persist

if (!persist) {

if (null == shutdownHook) {

shutdownHook = new ConnectionHelperShutdownHook();

ExitCommand.addShutdownHook(shutdownHook);

}

shutdownHook.add(fqName);

private static ConnectionHelperShutdownHook shutdownHook;

/**

private static class ConnectionHelperShutdownHook implements ShutdownHook {

public ArrayList<String> fqNames = new ArrayList<>();

public void add(String fqName) {

fqNames.add(fqName);

}

@Override

public boolean canShutdown() {

return true;

}

@Override

public void shutdown() {

for (String fqName : fqNames) {

try {

ConnectionUtils.closeAndDeleteConnection(fqName);

}

catch (Throwable t) {

Logger.warn(getClass(), fqName, t);

}

}

}

private static final Integer EXT_CONN_SVR_DEFAULT_PORT = 51521; // 49152-65535 https://www.iana.org/assignments/service-names-port-numbers/service-names-port-numbers.xhtml?search=1&page=24