[FIXED] Oracle Advanced Queue, Java and Maven : unable to find valid certification path to requested target

Issue

Not getting in any project and even jdbc dependency:

First time tried project using Oracle Advanced Queue in Maven and got following error

Failed to collect dependencies at com.oracle:aqapi:jar:11.2.0.0: Failed to read artifact descriptor for com.oracle:aqapi:jar:11.2.0.0: Could not transfer artifact com.oracle:aqapi:pom:11.2.0.0 from/to integrator-releases (https://artifactory.fintegrator.cosng.net/libs-release): PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>ojdbc6</artifactId>
        <version>11.2.0.3</version>
    </dependency>
    
    <dependency>
        <groupId>com.oracle</groupId>
        <artifactId>aqapi</artifactId>
        <version>11.2.0.0</version>
    </dependency>

Is there anything i am missing with?

Repositories:

  <distributionManagement>
    <repository>
      <id>integrator-libs-release-local</id>
      <name>Integrator Libraries Release Local</name>
      <url>https://artifactory.fintegrator.cosng.net/libs-release-local</url>
    </repository>
    <snapshotRepository>
      <id>integrator-libs-snapshot-local</id>
      <name>Integrator Libraries Snapshot Local</name>
      <url>https://artifactory.fintegrator.cosng.net/libs-snapshot-local</url>
    </snapshotRepository>
  </distributionManagement>

Solution

It seems like you're using some dated dependencies.

Try these instead:

<dependency>
  <groupId>com.oracle.database.jdbc</groupId>
  <artifactId>ojdbc6</artifactId>
  <version>11.2.0.4</version>
</dependency>

<dependency>
  <groupId>com.oracle.database.messaging</groupId>
  <artifactId>aqapi</artifactId>
  <version>19.3.0.0</version>
</dependency>

Answered By - Janez Kuhar