JDBC Connection strings to connect to Oracle DB

OTG-467455

What are the various acceptable JDBC connection strings that can be used to connect to an Oracle database?

Which connection string is commonly used?

Please explain what the purpose of each different connection string is.

The reason for my asking this is I have seen some connection string incarnations I did not think could work.

mNem

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/[email protected]//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();

        }

    }

}

mNem

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/[email protected]//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();

        }

    }

}