Can the new “SCRAM-SHA-256” password authentication mechanism in Postgres 10 and later work with any JDBC drivers?

Question

Postgres 10 added support for a new password authentication mechanism, Salted Challenge Response Authentication Mechanism (SCRAM-SHA-256, see RFC 7677). Discussed by Michael Paquier.

➥ Can this mechanism work with JDBC drivers?

If not, why not?

If so, have any drivers yet implemented this feature?

Answer 1

I have not verified this myself, but the answer seems to be Yes, from version 42.2.0 of the driver from the jdbc.postgresql.org project.

To quote the changelog for Version 42.2.0:

Support SCRAM-SHA-256 for PostgreSQL 10 in the JDBC 4.2 version (Java 8+) using the Ongres SCRAM library.

See GitHub pull request # 842.

That driver uses the SCRAM Java Implementation project by ongres.