SQL Developer Extension Create about oracle-db-examples HOT 3 CLOSED

  for (String qualifiedConnectionName : ConnectionResolver.getConnectionNames()) {
    // Get shared connection for qualified name (this is the one SQLDeveloper uses for the navigator and displays)
    java.sql.Connection sharedConn = ConnectionResolver.getConnection(qualifiedConnectionName);
    
    // Get unique (unnamed) connection using credentials from qualifiedConnectionName 
    java.sql.Connection uniqueConn = ConnectionResolver.getUniqueConnection(qualifiedConnectionName);
    
    // Get new connection for name/pw using connection driver info from qualifiedConnectionName
    String folderName = null; // Will use "Connections based on " + qualifiedConnectionName if null
    String username = "someUser"; // Must be unique as it will be used as the connection name
    String password = "somePassword";
    ConnectionUtils.addNewConnectionBasedOn(folderName, qualifiedConnectionName, username, password);
    String newConnQualifiedName = ConnectionResolver.getQualifiedConnectionName(username);
    java.sql.Connection newConn = ConnectionResolver.getConnection(newConnQualifiedName);
    
    java.sql.Connection myConn = newConn; // or uniqueConn
    String displayName = ConnectionResolver.getConnectionName(myConn); // null for uniqueConn(s)
    
    // do stuff ...
    // See if one of the DBUtil.getInstance(myConn).execute... methods work for you - it handles locking/error reporting
  
   // if using newConn, close and remove sqldev connection  
    Connections.close(newConnQualifiedName);

                SwingUtilities.invokeLater(() -> {
                    final String folder = "Testing";
                    final String user = "someUser"; // Must be unique as it will be used as the connection name
                    final String pw = "somePassword";
                    ConnectionUtils.addNewConnectionBasedOn(folder, connectionName, user, pw);
                    final String fqName = ConnectionUtils.getFqConnectionName(user);
                    ConnectionUtils.connect(fqName);
                    ExitCommand.addShutdownHook(new ShutdownHook() {
                        @Override
                        public boolean canShutdown() {
                            return true;
                        }
                        @Override
                        public void shutdown() {
                            ConnectionUtils.closeAndDeleteConnection(fqName);
                        }
                    });
                });