Travis: Oracle on Master branch fails "peer not authenticated"

[ipolevoy]

@jfcabral , looks like Travis is running into an issue with Oracle authentication:

[ERROR] Failed to execute goal on project activejdbc: Could not resolve dependencies for project org.javalite:activejdbc:jar:3.0-SNAPSHOT: Could not transfer artifact com.oracle.jdbc:ojdbc8:jar:12.2.0.1 from/to maven.oracle.com (https://maven.oracle.com): peer not authenticated -> [Help 1]
Please, see https://travis-ci.org/javalite/javalite/jobs/648526420. I did not change anything on the Travis side, and checked and re-checked the user and password. Additionally, I deleted this dependency locally on my laptop, ran the build and it happily downloaded from maven.oracle.com to my laptop. It seems that somehow, Oracle user/password stopped working on the Travis environment. I checked the setup, but could not see any issues.

Is there a way you can take a look? I was going to release, but now stuck with a broken build :(

[ipolevoy]

incidentally, the Java8 branch has no such issue: https://travis-ci.org/javalite/javalite/builds/649019274

Also, looking art the build history, seems that this commit broke Oracle, but honestly, I have no idea why: fb5e8fd. It seems totally unrelated!

[jfcabral]

Hi @ipolevoy it is a very odd behaviour indeed :/ I've made some tests, but unfortunately it requires further experimentation... I'll try to check it out during the next weekend!

[ipolevoy]

@jfcabral appreciate the effort, good luck this weekend!

[jfcabral]

Hi @ipolevoy :) Unfortunately I haven't had the time to check this out before..

Gladly, it seems that Oracle has finally came to their senses and published their jdbc on Maven Central! It's a glorious day! 😄

https://www.reddit.com/r/java/comments/fa8wxg/jdbc_drivers_for_all_major_oracle_versions_19_18/

I tried and it seems to work just fine, and at least this way we avoid all of those shenanigans from using Oracle's private maven repo!

One thing to notice is that even though the java8 branch is working now, I believe that we could do the same thing to it. We would have to choose the proper jdbc version for JDK8, but at least it would be easier for ppl to run the tests from their own machines, thus simplifying the setup for running the integration tests. 😃 What are your thoughts on the matter @ipolevoy ?

[ipolevoy]

OMG, @jfcabral great work (Oracle, it is about time! ). I pushed the same change to Java8 branch too - much appreciate!

[ipolevoy]

@ipolevoy I went too far and rejected this change on Java8 branch, did not read your comment carefully. The Java8 driver is not in Maven Central:( I reversed the last commit on the Java8 branch

In any case, the Java8 branch is in maintenance mode at this point. I will be moving my commercial projects to Java 11.

[jfcabral]

Yeah I could've explained it better, but basically, they released lots of versions and variants. Where this would, most likely, be the proper version for java8 branch:

Oracle JDBC Driver compatible with JDK8, JDK9, and JDK11
https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc8

For the master branch I've chosen ojdbc10 as I believe it to be more future-proof :)

Oracle JDBC Driver compatible with JDK10 and JDK11
https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc10

I you'd like I can do this change to the java8 branch 😉

[ipolevoy]

@jfcabral , thank you for looking, go for it!