javamavenoracle-aq

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


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>

enter image description here


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>