OCI Autonomous Database Connection implementing JDBC Driver on Spring Boot 2.5
This might be a silly question, but I need help solving I'm writing unit tests and I'm building a feature where I'm trying to configure I'm sure I'm missing something obvious here, but I'm sure I'm missing something obvious here, but I'm experiencing connection issues while trying to connect to an Oracle Cloud Infrastructure (OCI) Autonomous Database from my Spring Boot 2.5 application using the JDBC driver... I've configured the `application.properties` file as follows: ```properties spring.datasource.url=jdbc:oracle:thin:@//<db_host>:<db_port>/<db_service> spring.datasource.username=<username> spring.datasource.password=<password> spring.datasource.driver-class-name=oracle.jdbc.OracleDriver ``` However, when I run the application, I'm working with the following exception: ``` org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Io exception: The Network Adapter could not establish the connection ``` I've verified that the host and service name are correct and accessible from my local environment. Additionally, I am using the latest JDBC driver (19.10.0) and have included it in my dependencies: ```xml <dependency> <groupId>com.oracle.database.jdbc</groupId> <artifactId>ojdbc8</artifactId> <version>19.10.0.0</version> </dependency> ``` My local machine's firewall settings should allow outbound connections on the relevant port, yet I'm still working with this scenario. I've also tried configuring a VPN to see if it was related to network restrictions but to no avail. Is there something I might be overlooking regarding the connection string or any other configurations specific to OCI? Any suggestions on troubleshooting the connection question would be greatly appreciated! For context: I'm using Java on Linux. Is there a better approach? What's the best practice here? For reference, this is a production REST API. Any advice would be much appreciated. This is part of a larger application I'm building. What would be the recommended way to handle this?