Java Programming

You may find the answers from

Tutorial:

https://docs.oracle.com/database/121/TDPJD/getconn.htm#TDPJD144

Documentation:

https://docs.oracle.com/database/121/JJDBC/urls.htm#JJDBC28267

If you need a minimal class to test things out (copied from net and modified):

Play around with the variations of url and see the messages when it fails....

import java.sql.*;

public class Test1 {

    public static void main(String[] args) throws Exception {

        Connection conn = null;

        try {

            Class.forName("oracle.jdbc.driver.OracleDriver");

            conn = DriverManager.getConnection(

                    "jdbc:oracle:thin:ora1/ora1@//localhost:1521/pdborcl", null, null);

            Statement stmt = conn.createStatement();

            ResultSet rset = stmt.executeQuery("select sysdate from dual");

            if (rset.next()) {

                System.out.println(String.format(">>>>> Server time : [%s]", rset.getString(1)));

            }

        } catch (Exception e) {

            e.printStackTrace();

            System.out.println(e.getMessage());

        } finally {

            System.out.println(String.format("Using connect url : [%s]", conn.getMetaData().getURL()));

            if (conn != null) conn.close();

        }

    }

}