Search code examples
maven-2jdbcjarm2eclipse

Adding Dependencies in pom.xml


I am creating a project which will have oracle 10g/11g at its back end. For that I need ojdbc.jar. The problem is whenever I add ojdbc14.jar and save in pom.xml (I use m2eclipse plugin)it gives me a weird error 'Missing artifact com.oracle:ojdbc14:jar:10.2.0.4.0:compile'. whenever I remove this jar file from pom.xml the error disappears. I don't get why this is happening ?? What is the solution for this ???


Solution

  • You might have to share your pom dependency. The pom dependency for Oracle 10g is

      <groupId>com.oracle</groupId>
      <artifactId>ojdbc14</artifactId>
      <!-- use the 10g drivers which are surprisingly largely bug free -->
      <version>10.0.2.0</version>
    

    Also if you are deploying this in a server environment, it is better to put the driver jar in the lib folder of the server and provide scope as provided.

    So the following things could go wrong.

    1. Do you have a specific scope qualifier in your pom?
    2. Any typos?
    3. Do you have a local maven artifacts like artifactory?