AHH
AHH

Reputation: 1083

Postgres JDBC maven dependency not found

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>

Upvotes: 10

Views: 36376

Answers (4)

ParisaN
ParisaN

Reputation: 2092

If you use DBeaver, try this:

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

Upvotes: 0

Goatie
Goatie

Reputation: 1

Just downgrade the version of postgresql

Upvotes: -2

olasammy
olasammy

Reputation: 7366

Should be:

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

Do not put the version. Let Maven does that itself

Upvotes: 3

Rodrigo
Rodrigo

Reputation: 517

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.

Upvotes: 23

Related Questions