PSQLException: server does not support SSL

Question

Environment

Windows HikariCP version: 2.6.0 JDK version: 1.8.0_65 Database: PostgreSQL Driver version: 42.0.0 org.postgresql

---

It works for a while, for example, 2 hours, then an exception occurs. My configuration:

    ds = new HikariDataSource();
    ds.setMaximumPoolSize(poolSize);
    ds.setLeakDetectionThreshold(15000);
    ds.setDataSourceClassName("org.postgresql.ds.PGSimpleDataSource");
    ds.addDataSourceProperty("serverName", serverAddress);
    ds.addDataSourceProperty("databaseName", database);
    ds.addDataSourceProperty("user", user);
    ds.addDataSourceProperty("portNumber", port);
    ds.addDataSourceProperty("password", password);

My postgresql.conf is not installed by anything related to ssl either.

Answer 1

You can disable SSL explicitly by setting useSSL = false

eg.

ds.addDataSourceProperty("useSSL", "false");