Not able to find ojdbc driver after adding it in the pom.xml file

599

Praveenks :

I am trying to add ojdbc dependency in my pom.xml file to connect with Oracle database.

As shown below, this jar is available in maven repository.

But, after adding it pom.xml file, it's throwing below error. My settings are on auto import, so it should import it automatically.

Error:

com.oracle.ojdbc8.12.2.0.1.0 not found..

I am using Intellij IDEA and java version is 1.8.

Update:

After cleaning and compiling, I got to to know the actual root cause. My repository is set as below :

<repositories>
        <repository>
            <id>confluent</id>
            <url>http://packages.confluent.io/maven/</url>
        </repository>
    </repositories>

So, it's trying to look for ojdbc driver in this repository and not able to find it(my guess). I can't remove the above repository as it is required for other dependency. So, I would like to know how can I force ojdbc dependency to look into maven instead of io.confluent repository. Do I have to set two repositories?

Error :

[ERROR] Failed to execute goal on project PaymentEngine: Could not resolve dependencies for project com.example.test:PaymentEngine:jar:1.0-SNAPSHOT: Failure to find com.oracle:ojdbc8:jar:12.2.0.1.0 in http://packages.confluent.io/maven/ was cached in the local repository, resolution will not be reattempted until the update interval of confluent has elapsed or updates are forced -> [Help 1]

JF Meier :

Please note that mvnrepository has nothing to do with MavenCentral.

When you find an artifact there, it does not mean that Maven will find it in MavenCentral.

Instead, you need to figure out a repository from which you can get the desired jar and then add that repository to your <repositories>.

For the specific jar, this might be difficult, see here (as already suggested by Ben R.):

Find Oracle JDBC driver in Maven repository

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2020-06-18

Comments

0 comments

Jenkins is not invoking the correct POM file after moving the source code to Gitlab if the pom is inside the multiple directory(A/B/C/pom.xml)

TOP Ranking

Article

Not able to find ojdbc driver after adding it in the pom.xml file

Not able to find ojdbc driver after adding it in the pom.xml file

Failed to listen on localhost:8000 (reason: Cannot assign requested address)

pump.io port in URL

How to import an asset in swift using Bundle.main.path() in a react-native native module

Loopback Error: connect ECONNREFUSED 127.0.0.1:3306 (MAMP)

Compiler error CS0246 (type or namespace not found) on using Ninject in ASP.NET vNext

BigQuery - concatenate ignoring NULL

Spring Boot JPA PostgreSQL Web App - Internal Authentication Error

ggplotly no applicable method for 'plotly_build' applied to an object of class "NULL" if statements

ngClass error (Can't bind ngClass since it isn't a known property of div) in Angular 11.0.3

How to remove the extra space from right in a webview?

Change dd-mm-yyyy date format of dataframe date column to yyyy-mm-dd

Jquery different data trapped from direct mousedown event and simulation via $(this).trigger('mousedown');

maven-jaxb2-plugin cannot generate classes due to two declarations cause a collision in ObjectFactory class

java.lang.NullPointerException: Cannot read the array length because "<local3>" is null

How to use merge windows unallocated space into Ubuntu using GParted?

flutter: dropdown item programmatically unselect problem

Pandas - check if dataframe has negative value in any column

Nuget add packages gives access denied errors

Can't pre-populate phone number and message body in SMS link on iPhones when SMS app is not running in the background

Generate random UUIDv4 with Elm

Client secret not provided in request error with Keycloak