Connect Oracle cloud Database using JDBC java

I have database username and password to access oracle db and also have service url like https://X-X.X.X.oraclecloudapps.com/apex/.

Can anybody know how to connect this db using JDBC connection.

I tried using oracle thin driver but somehow it failes. Sample java code:

Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@//X.X.X.X.oraclecloudapps.com:1521/sid", "username", "****");

It throws

Exception in thread "main" java.sql.SQLRecoverableException: Io exception: The Network Adapter could not establish the connection

I don't know SID here, it would be helpful if anybody give steps to find SID/ServiceName from Oracle Cloud dashboard.

Solution

There is only three way to connect Database Schema Service.

From an Oracle Application Express application running in Database Schema Service
From a Java application running in an Oracle Java Cloud Service
Through RESTful Web services