👀 Views: 60 💬 Answers: 1 📅 Created: 2025-05-31

spring-boot oracle-cloud jdbc Java

I'm trying to connect my Spring Boot application to an Oracle Cloud Autonomous Database, but I'm running into a `java.sql.SQLException: IO behavior: The Network Adapter could not establish the connection` behavior. I've followed the Oracle documentation for setting up the datasource properties in my `application.properties` file. Here's what I currently have: ```properties spring.datasource.url=jdbc:oracle:thin:@//<db-hostname>:<port>/<service_name> spring.datasource.username=<your-username> spring.datasource.password=<your-password> spring.datasource.driver-class-name=oracle.jdbc.OracleDriver ``` I replaced `<db-hostname>`, `<port>`, and `<service_name>` with the appropriate values from my Oracle Cloud database instance, which should be in the format `your-db-name_high` for the service. My instance is accessible over the internet with the correct network security settings; I've confirmed that the firewall rules allow traffic on the specified port. I've also included the Oracle JDBC driver in my `pom.xml`: ```xml <dependency> <groupId>com.oracle.database.jdbc</groupId> <artifactId>ojdbc8</artifactId> <version>19.8.0.0</version> </dependency> ``` However, when I run the application, I still get the aforementioned behavior. I've tried using different versions of the JDBC driver as well as double-checking the service name and connection string format, but the question continues. Any ideas on what might be going wrong or additional steps I should take to diagnose the scenario?