Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- } catch (ClassNotFoundException e) {
- System.out.println("ERROR: Oracle JDBC Driver not found");
- e.printStackTrace();
- return;
- }
- System.out.println("Oracle JDBC Driver Registered!");
- Connection connection = null;
- String oracleURL = "jdbc:oracle:thin:@(DESCRIPTION(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=<hostname>)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=<service>)))";
- // Provide user ID, password for schema
- Properties props = new Properties();
- props.setProperty("user", "<user id>");
- props.setProperty("password", "<password>");
- // Setting properties for SSL
- props.setProperty("oracle.net.ssl_cipher_suites", "(ssl_rsa_export_with_rc4_40_md5, ssl_rsa_export_with_des40_cbc_sha, SSL_DH_anon_WITH_3DES_EDE_CBC_SHA, SSL_DH_anon_WITH_RC4_128_MD5,SSL_DH_anon_WITH_DES_CBC_SHA)");
- props.setProperty("oracle.net.ssl_client_authentication", "false");
- props.setProperty("oracle.net.ssl_version", "3.0");
- props.setProperty("oracle.net.encryption_client", "REJECTED");
- props.setProperty("oracle.net.crypto_checksum_client", "REJECTED");
- props.setProperty("javax.net.ssl.keyStore", "C:\APP\ORACLE\product\11.2.0\client_1\ewallet.p12");
- props.setProperty("javax.net.ssl.keyStoreType","PKCS12");
- props.setProperty("javax.net.ssl.keyStorePassword","Password1");
- try {
- connection = DriverManager.getConnection(oracleURL, props);
- } catch (SQLException e) {
- System.out.println("Connection Failed! Check output console");
- System.out.println("Error code: " + e.getErrorCode());
- System.out.println("SQL State: " + e.getSQLState());
- e.printStackTrace();
- return;
- }
- java -cp z:jdk1.7.0_13binojdbc14.jar;z:jdk1.7.0_13bin OracleConnCheck
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement