How to connect to 3rd party Postgres from Jira plugin?

[Dmitrii]

How to connect to 3rd party Postgres from Jira plugin?

What connector can be used in the Jira plugin to connect to Postgres?
I'm new to Java, more details please.

[Dmitrii · Accepted solution]

В pox.xml добавил:

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

<Import-Package>*;version="0";resolution:=optional</Import-Package>

В классе добавил:

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;

 В методе соединяюсь вот так:

String url = "jdbc:postgresql://<host>:<port>/<database>";
String username = "postgres";
String password = "postgres";
Connection conn = null;

try {
    conn = DriverManager.getConnection(url, username, password);

    System.out.println("Connected to the PostgreSQL server successfully.");

    // Успешное соединение
} catch (SQLException e) {
    // Не получилось подключиться
    System.out.println(e.getMessage());
}

Перезагрузил либы и скомпилировал так:

atlas-package