Re: 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(at)mail(dot)ru> wrote:
>
> Hello
>
> There was a need for logging purposes to receive in a Java / Spring application using JDBC, the PID of the connection on the 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
>