Hikari pool (Java) with Supabase throws SSL error: Received fatal alert: insufficient_security

I am trying to connect to my supabase db (free account) from Scala using Hikari pool. Here is the code snippet I am using for connecting:

private val config = new HikariConfig
config.setJdbcUrl(ConfigManager.get("db.url"))
config.setUsername(ConfigManager.get("db.user"))
config.setPassword(ConfigManager.get("db.password"))
config.setDriverClassName(ConfigManager.get("db.driver"))
config.setMaximumPoolSize(ConfigManager.get("db.maxPoolSize").toInt)
config.setIdleTimeout(ConfigManager.get("db.idleTimeout").toInt)
config.setConnectionTimeout(ConfigManager.get("db.connectionTimeout").toInt)
config.setAutoCommit(true)
config.addDataSourceProperty("sslMode", "DISABLED")
config.addDataSourceProperty("cachePrepStmts", "true")
config.addDataSourceProperty("prepStmtCacheSize", "250")
config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048")

private val config = new HikariConfig
config.setJdbcUrl(ConfigManager.get("db.url"))
config.setUsername(ConfigManager.get("db.user"))
config.setPassword(ConfigManager.get("db.password"))
config.setDriverClassName(ConfigManager.get("db.driver"))
config.setMaximumPoolSize(ConfigManager.get("db.maxPoolSize").toInt)
config.setIdleTimeout(ConfigManager.get("db.idleTimeout").toInt)
config.setConnectionTimeout(ConfigManager.get("db.connectionTimeout").toInt)
config.setAutoCommit(true)
config.addDataSourceProperty("sslMode", "DISABLED")
config.addDataSourceProperty("cachePrepStmts", "true")
config.addDataSourceProperty("prepStmtCacheSize", "250")
config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048")

private val config = new HikariConfig
config.setJdbcUrl(ConfigManager.get("db.url"))
config.setUsername(ConfigManager.get("db.user"))
config.setPassword(ConfigManager.get("db.password"))
config.setDriverClassName(ConfigManager.get("db.driver"))
config.setMaximumPoolSize(ConfigManager.get("db.maxPoolSize").toInt)
config.setIdleTimeout(ConfigManager.get("db.idleTimeout").toInt)
config.setConnectionTimeout(ConfigManager.get("db.connectionTimeout").toInt)
config.setAutoCommit(true)
config.addDataSourceProperty("sslMode", "DISABLED")
config.addDataSourceProperty("cachePrepStmts", "true")
config.addDataSourceProperty("prepStmtCacheSize", "250")
config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048")

private val config = new HikariConfig
config.setJdbcUrl(ConfigManager.get("db.url"))
config.setUsername(ConfigManager.get("db.user"))
config.setPassword(ConfigManager.get("db.password"))
config.setDriverClassName(ConfigManager.get("db.driver"))
config.setMaximumPoolSize(ConfigManager.get("db.maxPoolSize").toInt)
config.setIdleTimeout(ConfigManager.get("db.idleTimeout").toInt)
config.setConnectionTimeout(ConfigManager.get("db.connectionTimeout").toInt)
config.setAutoCommit(true)
config.addDataSourceProperty("sslMode", "DISABLED")
config.addDataSourceProperty("cachePrepStmts", "true")
config.addDataSourceProperty("prepStmtCacheSize", "250")
config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048")

When I run a SELECT query using JDBC, I get the following error:

java.lang.ExceptionInInitializerError
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: SSL error: Received fatal alert: insufficient_security
Caused by: org.postgresql.util.PSQLException: SSL error: Received fatal alert: insufficient_security
Caused by: javax.net.ssl.SSLHandshakeException: Received fatal alert: insufficient_security

java.lang.ExceptionInInitializerError
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: SSL error: Received fatal alert: insufficient_security
Caused by: org.postgresql.util.PSQLException: SSL error: Received fatal alert: insufficient_security
Caused by: javax.net.ssl.SSLHandshakeException: Received fatal alert: insufficient_security

java.lang.ExceptionInInitializerError
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: SSL error: Received fatal alert: insufficient_security
Caused by: org.postgresql.util.PSQLException: SSL error: Received fatal alert: insufficient_security
Caused by: javax.net.ssl.SSLHandshakeException: Received fatal alert: insufficient_security

java.lang.ExceptionInInitializerError
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: SSL error: Received fatal alert: insufficient_security
Caused by: org.postgresql.util.PSQLException: SSL error: Received fatal alert: insufficient_security
Caused by: javax.net.ssl.SSLHandshakeException: Received fatal alert: insufficient_security

I have tried searching for this error but have not made much progress. SSL is not being enforced.
Any pointers how I can get around this issue? Thanks!

SamikROP•12/31/24, 1:04 PM

Interestingly, I am able to write to the database using the same Hikari connection pool and same code. However, the select is erroring out

SamikROP•12/31/24, 1:06 PM

FWIW: I am using the session pooler port for the JDBC connection string:

jdbc:postgresql://aws-0-ap-south-1.pooler.supabase.com:6543/postgres

jdbc:postgresql://aws-0-ap-south-1.pooler.supabase.com:6543/postgres

Hikari pool (Java) with Supabase throws SSL error: Received fatal alert: insufficient_security

Similar Threads

Similar Threads

Similar Threads