Thread: How to get DB connection PID from JDBC

Hi Oleg,

Maybe you can use the extensions to the JDBC API:

        try (Connection conn =
DriverManager.getConnection(getJdbcUrl(), getUsername(),
getPassword())) {
            PGConnection pgconn =
conn.unwrap(org.postgresql.PGConnection.class);
            System.out.println(pgconn.getBackendPID());
        }

Regards,

On Mon, Sep 12, 2022 at 11:14 AM Oleg Golovanov <rentech@mail.ru> wrote:
>
> Hello
>
> There was a need for logging purposes to receive in a Java / Spring application using JDBC, the PID of the connection
onthe database side. I did not find such an opportunity in the JDBC sources.
 
>
> Can you explain if there is such a possibility?
>
> It seems to me to execute when establishing a connection each time a request
> select pg_backend_pid()
> not the best idea.
>
> Best Regards,
>
> Oleg Golovanov
> Tel./WhatsApp +79067778133
> Moscow, Russia
>