OCI Autonomous Database Connection Pooling guide with Spring Boot and Hibernate
I'm having trouble with I'm migrating some code and I'm currently working on a Spring Boot application that connects to an OCI Autonomous Database using Hibernate... I implemented connection pooling with HikariCP, but I'm working with an scenario where after a few hours of running, my application starts throwing `org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection` errors. I suspect this might be related to idle connections being closed by OCI. Here’s my current HikariCP configuration in `application.properties`: ```properties spring.datasource.url=jdbc:oracle:thin:@//<your_db_hostname>:1522/<your_service_name> spring.datasource.username=<your_username> spring.datasource.password=<your_password> spring.datasource.driver-class-name=oracle.jdbc.OracleDriver spring.datasource.hikari.maximum-pool-size=10 spring.datasource.hikari.minimum-idle=5 spring.datasource.hikari.idle-timeout=600000 spring.datasource.hikari.connection-timeout=30000 spring.datasource.hikari.validation-timeout=5000 spring.datasource.hikari.connection-test-query=SELECT 1 FROM DUAL ``` I verified that the database is correctly configured and the credentials are valid. To troubleshoot, I’ve tried the following: 1. Increased the `idle-timeout` from 300000 to 600000 to see if it helps. 2. Added the `connection-test-query` to keep the connections alive, but I still experience the same scenario after some time. 3. Checked the OCI console for any unusual activity or logs, but nothing stands out. Does anyone have experience with connection pooling issues in OCI with Spring Boot? What other settings or best practices should I consider to maintain a stable connection pool? Any insights would be greatly appreciated! This is for a desktop app running on Windows 10. Could this be a known issue?