java.lang.Object
org.odpi.openmetadata.adapters.connectors.oracle.utilities.OracleUtils

public class OracleUtils extends Object
OracleUtils provides simple functions to work with Oracle Database names and connection strings.
  • Constructor Details

    • OracleUtils

      public OracleUtils()
  • Method Details

    • getDatabaseURL

      public static String getDatabaseURL(String cdbRootURL, String pdbServiceName)
      Convert the connection string for the CDB root into a connection string for one of its pluggable databases (PDBs). Oracle JDBC URLs use the EZCONNECT syntax, identifying the target service through the final path segment (eg "jdbc:oracle:thin:@//host:port/serviceName"), so the existing service name on the CDB root URL is replaced with the PDB's service name rather than appended as a connection property.
      Parameters:
      cdbRootURL - connection string used to connect to the Oracle Database Server's CDB root
      pdbServiceName - service name of the pluggable database
      Returns:
      connection string