Using Oracle Maven Repository

Do you need to include Oracle JDBC jars in your Maven project? It is not as simple as with other Maven repositories, because it requires you to set up authentication. If you have not done that before, it might be quite a challenge. This guide should help you get it done. So let’s get started.

First of all, include the dependency in your pom.xml (adjust artifactId and version as you need)

<dependency>
	<groupId>com.oracle.jdbc</groupId>
	<artifactId>ojdbc8</artifactId>
	<version>12.2.0.1</version>
</dependency>

Additionally, add the Oracle Maven repository to your pom.xml

<repositories>
	<repository>
		<id>maven.oracle.com</id>
		<releases>
			<enabled>true</enabled>
		</releases>
		<snapshots>
			<enabled>false</enabled>
		</snapshots>
		<url>https://maven.oracle.com</url>
		<layout>default</layout>
	</repository>
</repositories>
<pluginRepositories>
	<pluginRepository>
		<id>maven.oracle.com</id>
		<url>https://maven.oracle.com</url>
	</pluginRepository>
</pluginRepositories>

If you try to build your Maven project now, you will get an error message Not authorized, ReasonPhrase:Authorization Required.

$ mvn clean package
...
[ERROR] Failed to execute goal on project oraclemvn: Could not resolve dependencies for project com.example:oraclemvn:jar:0.0.1-SNAPSHOT: Failed to collect dependencies at com.oracle.jdbc:ojdbc8:jar:12.2.0.1: Failed to read artifact descriptor for com.oracle.jdbc:ojdbc8:jar:12.2.0.1: Could not transfer artifact com.oracle.jdbc:ojdbc8:pom:12.2.0.1 from/to maven.oracle.com (https://maven.oracle.com): Not authorized , ReasonPhrase:Authorization Required. -> [Help 1]
...

If you go to https://maven.oracle.com, you will see, that …

• Directory browsing is not allowed on the Oracle Maven Repository
• Registration is required to access the Oracle Maven Repository. To register, please visit the registration site.
• Technical information about how to use the Oracle Maven Repository is available here.

Following the technical information, you need to use a master password for your Maven settings. This will protect your password for Oracle Maven repo. Encrypt your Maven master password using

$ mvn --encrypt-master-password masterPassw0rd
{3dH9rX5YDZgH9bArLT8icLidlqjwjcdcy0iGuXigBB8=}

and save it in settings-security.xml, which is located in your $HOME/.m2 folder (the same folder where your settings.xml file is stored)

$ cat $HOME/.m2/settings-security.xml
<settingsSecurity>
  <master>
    {3dH9rX5YDZgH9bArLT8icLidlqjwjcdcy0iGuXigBB8=}
  </master>
</settingsSecurity>

Next, encrypt your Oracle Technology Network (OTN) password. If you have no OTN account yet, you need to register here.

$ mvn --encrypt-password yourOTNpassw0rd
{ifRwrvBQqZAH0ipAAmoLrGWAIk5HLQznilXWNnnAdus=}

Finally, add server for Oracle Maven repository to your $HOME/.m2/settings.xml file

<servers>
  <server>
    <id>maven.oracle.com</id>
    <username>your.name@example.com</username>
    <password>{ifRwrvBQqZAH0ipAAmoLrGWAIk5HLQznilXWNnnAdus=}</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>

And you’re done. Your Maven project can now use any artifacts from Oracle Maven repository.

$ mvn install
...

References

https://blogs.oracle.com/dev2dev/get-oracle-jdbc-drivers-and-ucp-from-oracle-maven-repository-without-ides