Mega Code Archive

 

Categories / Java / Database SQL JDBC

 

Test SSL

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