Supabase•5h ago

Unable to obtain isolated JDBC connection [The connection attempt failed.]

I have created a spring boot application that uses supabase. I am using JB Intelji IDE. The error I am getting is the follow:

org.hibernate.exception.JDBCConnectionException: Unable to obtain isolated JDBC connection [The connection attempt failed.] [n/a]
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:80) ~[hibernate-core-7.1.1.Final.jar:7.1.1.Final]

org.hibernate.exception.JDBCConnectionException: Unable to obtain isolated JDBC connection [The connection attempt failed.] [n/a]
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:80) ~[hibernate-core-7.1.1.Final.jar:7.1.1.Final]

This is my application.yml file

spring:
  application:
    name: buddyrunner

  datasource:
     url: jdbc:postgresql://db.xxxxxxxxxxxxx.supabase.co:5432/postgres
     username: postgres
     password: ${POSTGRES_PASSWORD}
     driver-class-name: org.postgresql.Driver

     hikari:
       maximum-pool-size: 10
       minimum-idle: 5
       connection-timeout: 20000
       idle-timeout: 300000
       max-lifetime: 12000000
       validation-timeout: 5000
       pool-name: SpringBootHikariCP
       data-source-properties:
         prepareThreshold: 5
         preparedStatementCacheQueries: 256
         preparedStatementCacheSizeMiB: 5

         tcpKeepAlive: true
         socketTimeout: 30
         connectTimeout: 10
  jpa:
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
        format_sql: true
        show_sql: true

spring:
  application:
    name: buddyrunner

  datasource:
     url: jdbc:postgresql://db.xxxxxxxxxxxxx.supabase.co:5432/postgres
     username: postgres
     password: ${POSTGRES_PASSWORD}
     driver-class-name: org.postgresql.Driver

     hikari:
       maximum-pool-size: 10
       minimum-idle: 5
       connection-timeout: 20000
       idle-timeout: 300000
       max-lifetime: 12000000
       validation-timeout: 5000
       pool-name: SpringBootHikariCP
       data-source-properties:
         prepareThreshold: 5
         preparedStatementCacheQueries: 256
         preparedStatementCacheSizeMiB: 5

         tcpKeepAlive: true
         socketTimeout: 30
         connectTimeout: 10
  jpa:
    properties:
      hibernate:
        dialect: org.hibernate.dialect.PostgreSQLDialect
        format_sql: true
        show_sql: true

2 Replies

garyaustin•5h ago

That connection will not work for IPv4 only networks if that applies. You might try the session pooler connection to rule that out.

stevekitkatOP•4h ago

Thanks, that worked great

Gaming

Programming

Unable to obtain isolated JDBC connection [The connection attempt failed.]

Did you find this page helpful?