Cannot connect over SSL using PostgreSQL JDBC driver

Question

I am trying to connect a database over SSL(namely TLSv1.3).

When tested with psql, it connects over TLSv1.3.

With JDBC driver as below, the connection is not secured by SSL at all for some reason.

(confirmed this by executing select * from pg_stat_ssl;)

      val props = new Properties()
      props.setProperty("user", "postgres")
      props.setProperty("password", "example")
      props.setProperty("ssl", "true")
      props.setProperty("sslmode", "allow")
      props.setProperty("sslfactory", "org.postgresql.ssl.NonValidatingFactory")
      DriverManager.getConnection("jdbc:postgresql://localhost/", props)

What would be the cause of this problem?

PostgreSQL JDBC driver versions: 42.2.5/42.2.22

Laurenz Albe · Accepted Answer · 2021-07-01 03:49:46Z

2

If you set sslmode to allow, the client will prefer non-encrypted connections. Change the setting to require or prefer.

answered Jul 1, 2021 at 3:49

Laurenz Albe

257k22 gold badges312 silver badges388 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot connect over SSL using PostgreSQL JDBC driver

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related