403: Forbidden when attempting to pull ojdbc from Oracle

[tjheslin1]

I've followed your detailed guide, which has been very helpful at getting further on with my problem of treating the ojdbc as any other external dependency 👍

My issue isn't a problem with the guide in this repo, but the solution may be useful to add.

My build.gradle looks like this

Here's a snippet:

repositories {
    jcenter()

    maven {
        url "https://www.oracle.com/content/secure/maven/content"
        credentials {
            username oracleUsername
            password oraclePassword
        }
    }
}

...

compile("com.oracle.jdbc:ojdbc7:12.1.0.2")

I have my Oracle SSO credentials in my gradle.properties and have double-checked they are correct.

My current issue, when running ./gradlew, is the following:

Could not resolve all files for configuration ':compileClasspath'.
> Could not resolve com.oracle.jdbc:ojdbc7:12.1.0.2.
  Required by:
      project :
   > Could not resolve com.oracle.jdbc:ojdbc7:12.1.0.2.
      > Could not get resource 'https://www.oracle.com/content/secure/maven/content/com/oracle/jdbc/ojdbc7/12.1.0.2/ojdbc7-12.1.0.2.pom'.
         > Could not GET 'https://www.oracle.com/content/secure/maven/content/com/oracle/jdbc/ojdbc7/12.1.0.2/ojdbc7-12.1.0.2.pom'. Received status code 403 from server: Forbidden

I tried setting up another Oracle SSO account but had the same problem.
I have also tried putting garbage log-in credentials, which results in a 401: Unauthorized error.

Any insight would be greatly appreciated.

[tjheslin1]

I have fixed this issue. The 403 Forbidden is, I believe, due to Oracle not distributing ojdbc7 over maven. They do allow you to download ojdbc8.

Therefore my build.gradle now looks like this:

def oracleUsername = hasProperty('mavenOracleUsername') ? mavenOracleUsername : System.getenv('mavenOracleUsername')
def oraclePassword = hasProperty('mavenOraclePassword') ? mavenOraclePassword : System.getenv('mavenOraclePassword')

repositories {
    jcenter()

    maven {
        url "https://www.oracle.com/content/secure/maven/content"
        credentials {
            username "${oracleUsername}"
            password "${oraclePassword}"
        }
    }
}

...

dependencies {
    compile group: 'com.oracle.jdbc', name: 'ojdbc8', version: '12.2.0.1'
}

[tjheslin1]

This link helped:

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