Hi, I’m using a render PostgreSQL for my java spring-boot app.
After running the app, after several minutes I’m getting the following errors:
HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@6841a9bc (This connection has been closed.). Possibly consider using a shorter maxLifetime value.
Probably the problem is that Hikari has 30 minutes for maxLifetime property by default.
Do you know what a connection timeout for the render PostgreSQL is? What value should I set for maxLifetime property to avoid these errors?
Thanks in advance.