/*
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();
}
}