Advertisement
Guest User

Untitled

a guest
Jun 2nd, 2016
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.79 KB | None | 0 0
  1. try {
  2. Class.forName("oracle.jdbc.driver.OracleDriver");
  3. } catch (ClassNotFoundException e) {
  4. System.out.println("ERROR: Oracle JDBC Driver not found");
  5. e.printStackTrace();
  6. return;
  7. }
  8.  
  9. System.out.println("Oracle JDBC Driver Registered!");
  10. Connection connection = null;
  11. String oracleURL = "jdbc:oracle:thin:@(DESCRIPTION(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCPS)(HOST=<hostname>)(PORT=2484)))(CONNECT_DATA=(SERVICE_NAME=<service>)))";
  12.  
  13. // Provide user ID, password for schema
  14. Properties props = new Properties();
  15. props.setProperty("user", "<user id>");
  16. props.setProperty("password", "<password>");
  17.  
  18. // Setting properties for SSL
  19. 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)");
  20. props.setProperty("oracle.net.ssl_client_authentication", "false");
  21. props.setProperty("oracle.net.ssl_version", "3.0");
  22. props.setProperty("oracle.net.encryption_client", "REJECTED");
  23. props.setProperty("oracle.net.crypto_checksum_client", "REJECTED");
  24. props.setProperty("javax.net.ssl.keyStore", "C:\APP\ORACLE\product\11.2.0\client_1\ewallet.p12");
  25. props.setProperty("javax.net.ssl.keyStoreType","PKCS12");
  26. props.setProperty("javax.net.ssl.keyStorePassword","Password1");
  27.  
  28. try {
  29. connection = DriverManager.getConnection(oracleURL, props);
  30. } catch (SQLException e) {
  31. System.out.println("Connection Failed! Check output console");
  32. System.out.println("Error code: " + e.getErrorCode());
  33. System.out.println("SQL State: " + e.getSQLState());
  34. e.printStackTrace();
  35. return;
  36. }
  37.  
  38. java -cp z:jdk1.7.0_13binojdbc14.jar;z:jdk1.7.0_13bin OracleConnCheck
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement