TestSSL.java Source code

Java tutorial

Introduction

Here is the source code for TestSSL.java

Source

/*
Java Programming with Oracle JDBC
by Donald Bales 
ISBN: 059600088X
Publisher: O'Reilly
*/

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class TestSSL {

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

        DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());

        Properties prop = new Properties();
        prop.setProperty("user", "scott");
        prop.setProperty("password", "tiger");
        // THIS DOES NOT WORK YET
        prop.setProperty("oracle.net.ssl_cipher_suites",
                "(ssl_rsa_export_with_rc4_40_md5, ssl_rsa_export_with_des40_cbc_sha)");
        prop.setProperty("oracle.net.ssl_client_authentication", "false");
        prop.setProperty("oracle.net.ssl_version", "3.0");
        prop.setProperty("oracle.net.encryption_client", "REJECTED");
        prop.setProperty("oracle.net.crypto_checksum_client", "REJECTED");
        Connection conn = DriverManager.getConnection(
                "jdbc:oracle:thin:@(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCPS)(HOST = dssw2k01)(PORT = 2484))) (CONNECT_DATA = (SERVICE_NAME = DSSW2K01)))",
                prop);
        Statement stmt = conn.createStatement();
        ResultSet rset = stmt
                .executeQuery("select 'Hello Thin driver SSL " + "tester '||USER||'!' result from dual");
        while (rset.next())
            System.out.println(rset.getString(1));
        rset.close();
        stmt.close();
        conn.close();
    }
}