Get Oracle JDBC drivers and UCP from Oracle Maven Repository (without IDEs)

New !! Oracle 19.3 JDBC drivers and Universal Connection Pool (ucp.jar) are on Maven Central Repository !! Refer to the blog for more details. 

The Oracle JDBC drivers and Universal Connection Pool (UCP) are also available on the Oracle Maven Repository. The following versions are available on the Oracle Maven repository:  19.3.0.0., 18.3.0.0, 12.2.0.1, 12.1.0.2, 12.1.0.1, and 11.2.0.4. In addition, the companion jars including simplefan.jar, ons.jar, orai18n.jar etc., required for specific features are also available. 

GAV details for ojdbc8.jar from 19.3.0.0:

<groupId>com.oracle.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>19.3.0.0</version>

Here is the list of artifacts available on Oracle Maven repository:
<groupid> is the same for all versions. Make sure to change the <artifactid> and <version> to the exact jar that you want to download.

• ojdbc8.jar: JDBC driver certified with JDK8
• ucp.jar: Universal Connection Pool to use with JDK8
• orai18n.jar: Classes for NLS or Internalization support
• simplefan.jar: Java APIs for subscribing to RAC events via ONS
• ons.jar: Oracle Notification Services (ONS) daemon
• osdt_core.jar, osdt_cert.jar, oraclepki.jar: Required to access Oracle Wallets from Java
• xdb6.jar and xmlparserv2.jar: To support standard java.sql.SQLXML interface
• ojdbc8_g.jar: Same as ojdbc8.jar except compiled with "javac -g" and contains tracing code
• ojdbc8dms.jar: Same as ojdbc8.jar, except that it supports DMS and limited java.util.logging calls
• ojdbc8dms_g.jar: Same as ojdbc8_g.jar except that it contains instrumentation to support DMS.

Refer to Get Oracle JDBC drivers and UCP from the Oracle Maven Repository - NetBeans, Eclipse, Intellij for steps while using NetBeans, Eclipse, and Intellij.  Follow the steps mentioned in this blog to successfully download the required version of Oracle JDBC drivers, UCP, or any other companion jars. 

Step #1: Download Maven

• Install Apache Maven if you do not have it already. 
• Update M2_HOME and JAVA_HOME environment variables:
  Make sure to update M2_HOME to point to the path where Maven is installed and JAVA_HOME to point to the location where the JDK is installed. If you require a specific Java version then set it using these system arguments.
  -Dmaven.compiler.source=1.8 -Dmaven.compiler.target=1.8

Step#2: Registering with the Oracle Maven site

The Oracle Maven repository requires a valid user registration and the user should also accept the terms and conditions (T&Cs) by logging into http://maven.oracle.com. This username will be used in settings.xml.

Step#3: Create a settings-security.xml

Create a settings-security.xml file that holds the master password information under the local  maven repository (Example: {USER_HOME}/.m2/ ) that is usually under the user home directory.  For example: If the username is test then the path will be

• Unix : /home/test/.m2/settings.xml
• Windows : C:\Users\test\.m2\settings.xml

<settingsSecurity> 
<master>{By8wW7YcTxAHof0MF4Z3wPKboywhGJvxHD9m0NvHA2U=}</master> 
</settingsSecurity> 

<settings>
  <proxies>
    <proxy>
      <active>true</active>
      <protocol>http</protocol>
      <host>proxy.mycompany.com</host>
      <nonProxyHosts>mycompany.com</nonProxyHosts>
   </proxy>
  </proxies>

<servers>
  <server>
    <id>maven.oracle.com </id>
    <username>firstname.lastname@test.com</username>
    <password>{pnwmhVnzdM8H3UAneUKLmaHGZCoaprbMQ/Ac5UktvsM=}</password>
  <configuration>
    <basicAuthScope>
      <host>ANY </host>
      <port>ANY </port>
      <realm>OAM 11g </realm>
    </basicAuthScope>
    <httpConfiguration>
      <all>
      <params>
        <property>
          <name>http.protocol.allow-circular-redirects </name>
          <value>%b,true </value>
        </property>
      </params>
      </all>
    </httpConfiguration>
  </configuration>
  </server>
  </servers>
</settings>

<dependencies>
  <dependency>
    <groupId>com.oracle.jdbc</groupId>
    <artifactId>ojdbc8</artifactId>
    <version>19.3.0.0</version>
  </dependency>
</dependencies>
<repositories>
  <repository>
    <id>maven.oracle.com</id>
    <name>oracle-maven-repo</name>
    <url>https://maven.oracle.com</url>
    <layout>default</layout>
    <releases>
      <enabled>true</enabled>
      <updatePolicy>always</updatePolicy>
    </releases>
  </repository>
</repositories>
<pluginRepositories>
  <pluginRepository>
    <id>maven.oracle.com</id>
    <name>oracle-maven-repo</name> 
    <url>https://maven.oracle.com</url>
    <layout>default</layout>
    <releases>
      <enabled>true</enabled>
      <updatePolicy>always</updatePolicy>
    </releases>
  </pluginRepository>
</pluginRepositories>