Postgres JDBC maven dependency not found

Question

I wanted to include Postgres JDBC driver in my Java application, so I added it as maven dependency. I chose the last version from this list, which happened to be, to my astonishment, hosted by Atlassian. Now I am receiving this error:

Missing artifact postgresql:postgresql:jar:9.4.1208-jdbc42-atlassian-hosted

I also tried an older version that is not hosted by Atlassian, but got the same error! Is there another proper place to get the jar from?

This is my current pom.xml:

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>PostgresListener</groupId>
<artifactId>PostgresListener</artifactId>
<version>0.0.1-SNAPSHOT</version>
<build>
    <sourceDirectory>src</sourceDirectory>
    <plugins>
        <plugin>
            <artifactId>maven-compiler-plugin</artifactId>
            <version>3.5.1</version>
            <configuration>
                <source>1.8</source>
                <target>1.8</target>
            </configuration>
        </plugin>
    </plugins>
</build>
<dependencies>
    <!-- https://mvnrepository.com/artifact/postgresql/postgresql -->
    <dependency>
        <groupId>postgresql</groupId>
        <artifactId>postgresql</artifactId>
        <version>9.4.1208-jdbc42-atlassian-hosted</version>
    </dependency>
</dependencies>

Why are you trying to use a third-party dependency, instead of the official postgresql JDBC maven dependency? — Mark Rotteveel
– Mark Rotteveel, Commented Jan 19, 2017 at 9:18
Where is the official one, I found this on the mvnrepository.com, that is a part of my question: is there a better repository/host. — AHH
– AHH, Commented Jan 19, 2017 at 9:21
mvnrepository.com is just a view (index) of repo1.maven.org (and some other non-standard repository, like that one from Atlassian), but to answer your question: it is here: mvnrepository.com/artifact/org.postgresql/postgresql — Mark Rotteveel
– Mark Rotteveel, Commented Jan 19, 2017 at 21:14

Rodrigo · Accepted Answer · 2017-01-19 08:29:56Z

23

What exactly do you have in your pom.xml file?

Should be something like:

<!-- https://mvnrepository.com/artifact/org.postgresql/postgresql -->
<dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.4.1212</version>
</dependency>

Make sure you're using org.postgresql as the groupId, instead of postgresql.

answered Jan 19, 2017 at 8:29

Rodrigo

5174 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

AHH Over a year ago

This one worked, but how did you find it? A google search wont get me to it!

Mark Rotteveel Over a year ago

@AHH jdbc.postgresql.org/download.html, links to Maven using the link search.maven.org/…

Csa77 · Accepted Answer · 2018-09-13 14:21:41Z

3

Should be:

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

Do not put the version. Let Maven does that itself

edited Sep 13, 2018 at 14:21

Csa77

77714 silver badges19 bronze badges

answered Sep 20, 2017 at 7:17

olasammy

7,5265 gold badges28 silver badges34 bronze badges

Comments

Mark Rotteveel · Accepted Answer · 2022-07-18 07:02:41Z

0

If you use DBeaver, try this:

Choose Database option from menu,
Driver manager,
choose PostgreSQL and edit this,
Go to Libraries and choose Add Artifact,
Dependency Declaration,
Paste your needed dependency (in the above answers) into it, and you're done

edited Jul 18, 2022 at 7:02

Mark Rotteveel

110k240 gold badges160 silver badges232 bronze badges

answered Apr 11, 2022 at 8:47

ParisaN

2,1324 gold badges27 silver badges61 bronze badges

Comments

Goatie · Accepted Answer · 2019-11-16 21:44:45Z

-2

Just downgrade the version of postgresql

answered Nov 16, 2019 at 21:44

Goatie

13 bronze badges

Collectives™ on Stack Overflow

Postgres JDBC maven dependency not found

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related