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:
This is my application.yml file
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: truespring:
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
