Postgresql driver not found for maven dependency

Question

I am running a spring project with maven and I am trying to use postgresql. I've added the dependency to pom.xml, but at tomcat startup, I get the following error:

java.lang.ClassNotFoundException: org.postgresql.Driver

pom.xml dependency:

<dependency>
  <groupId>org.postgresql</groupId>
  <artifactId>postgresql</artifactId>
  <version>9.3-1101-jdbc41</version>
</dependency>

It appears that Maven isn't downloading the jar so the Driver class is not found. Any ideas?

Did you got warnings during your build? Are you behind a proxy? Have you checked if the artifacts has been downloaded or not? — khmarbaise, Mar 11 '14 at 16:40

score 11 · Answer 1 · answered Jun 04 '20 at 06:51

11

What also worked for me if you are on intellj: right klick pom.xml->Maven->Reimport Don't know why it doesn't download the artifact on copy paste.

answered Jun 04 '20 at 06:51

FishingIsLife

1,972
3
28
51

3

In my case it was: Right-click on pom.xml ->Maven->Reload project – gabcamilo Jan 03 '21 at 16:41
Worked for me as well. Can you please explain why this is needed? I'm new to the Java world. – TK-95 Mar 23 '22 at 11:19

score 5 · Answer 2 · answered Mar 11 '14 at 12:44

5

When I put this in my pom, the artifact gets downloaded. Maybe you should clean your maven repository cache or delete the folders manually and retry.

answered Mar 11 '14 at 12:44

Stefan

12,108
5
47
66

I tried that before posting the question. Still I receive the class not found exception. Do I need to add something else to pom.xml header? My current header: – Alex Mar 11 '14 at 12:51
So is the jar not existing or just not loaded? – Stefan Mar 11 '14 at 12:59
Yes, the jar didn't exist. It wasn't downloaded – Alex Mar 11 '14 at 19:06

Ismail Yavuz · Answer 3 · 2018-01-26T13:51:59.673

If you came here for "missing artifact" error, This worked for me:

    <dependency>
        <groupId>org.postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>9.4.1212</version>
    </dependency>

For PostgreSQL 10 I use this:

       <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.1.4</version>
        </dependency>

score 1 · Answer 4 · answered Dec 01 '22 at 12:52

1

Try to rebuild the artifact, most likely only the added dependency was not included there

answered Dec 01 '22 at 12:52

Дмитрий Беспалов

11
3

Your answer could be improved with additional supporting information. Please [edit] to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers [in the help center](/help/how-to-answer). – Community Dec 08 '22 at 10:10

score 0 · Accepted Answer · answered Mar 11 '14 at 19:11

0

Maven wasn't recognizing the new dependency I have added to pom.xml, so I added it through 'Dependency view' from the xml and that did the trick. Thank you for your answers.

answered Mar 11 '14 at 19:11

Alex

312
1
3
9

Quan Bui · Answer 6 · 2023-07-09T16:48:41.347

In my case, the problem was from the <minimizeJar>true</minimizeJar> configuration option for the maven-shade-plugin.

Previously, I set this configuration to true to make my shaded JAR file smaller due to the 10MB limit on AWS Lambda application.

After trying everything on SOF and nothing worked, I tried commenting out the minimizeJar option and it just worked flawlessly...

This is my working config for maven-shade-plugin:

<plugin>
  <groupId>org.apache.maven.plugins</groupId>
  <artifactId>maven-shade-plugin</artifactId>
  <version>3.4.1</version>
  <configuration>
    <createDependencyReducedPom>false</createDependencyReducedPom>
  </configuration>
  <executions>
    <execution>
      <phase>package</phase>
      <goals>
        <goal>shade</goal>
      </goals>
      <!-- <configuration>
        <minimizeJar>true</minimizeJar>
      </configuration> -->
    </execution>
  </executions>
</plugin>

I ran the Maven project using the following steps:

mvn clean package && mvn clean install
java -cp target/example-1.0.0.jar com.example.mainClassName

John F. · Answer 7 · 2014-03-11T16:44:38.480

-1

You need to place a copy of the jar in the tomcat/lib folder.

edited Mar 11 '14 at 16:44

answered Mar 11 '14 at 13:28

John F.

4,780
5
28
40

1

Tomcat manages the connections? No. Tomcat is a servlet engine but not an application server like Glassfish, JBoss, Weblogic etc. – khmarbaise Mar 11 '14 at 16:41
This will not change a thing, cause the best in such cases is to put the driver into the resulting war file which will be deployed. That's it. – khmarbaise Mar 11 '14 at 16:46

Postgresql driver not found for maven dependency

7 Answers7

Linked