Advertisement
Guest User

Untitled

a guest
Aug 5th, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.36 KB | None | 0 0
  1. package test;
  2.  
  3.  
  4. import java.sql.*;
  5. import oracle.jdbc.pool.*;
  6.  
  7. public class ThinTnsnames {
  8. // private static OracleConnection connection = null;
  9. static String sql = null;
  10.  
  11. public static void main(String[] args) {
  12. String entry_name = "LITPUB_RO"; //args [0];
  13. String userId = "cdb_reader"; // args [1];
  14. String password = "reader"; //args [2];
  15. test (entry_name, userId, password);
  16. }
  17.  
  18. public static void test (String entry_name, String userId, String password) {
  19. Connection pconnection = null;
  20. try {
  21. System.setProperty("oracle.net.tns_admin", "/sw/common/oracle");
  22. // String url = "jdbc:oracle:thin:@mytns_alias";
  23. // Connection conn = DataSource.getConnection (url, userName, password);
  24. String l_url = "jdbc:oracle:thin:@" + entry_name;
  25. System.out.println( " Connection string = " + l_url );
  26.  
  27. OracleDataSource ods = new OracleDataSource();
  28. ods.setUser(userId);
  29. ods.setPassword(password);
  30. ods.setURL(l_url);
  31. pconnection = ods.getConnection ();
  32. version (pconnection );
  33. }
  34. catch(SQLException e) {
  35. e.printStackTrace();
  36. }
  37. finally {
  38. try {
  39. if (pconnection != null )pconnection .close();
  40. }
  41. catch(Exception e) {
  42. e.printStackTrace();
  43. }
  44. }
  45. }
  46.  
  47. public static void version (Connection pconnection) {
  48. try {
  49. DatabaseMetaData dmd = pconnection.getMetaData();
  50. System.out.println("DriverVersion: ["+dmd.getDriverVersion()+"]");
  51. System.out.println("DriverMajorVersion: ["+dmd.getDriverMajorVersion()+"]");
  52. System.out.println("DriverMinorVersion: ["+dmd.getDriverMinorVersion()+"]");
  53. System.out.println("DriverName: ["+dmd.getDriverName()+"]");
  54. System.out.println("URL: ["+dmd.getURL()+"]");
  55. System.out.println("UserName: ["+dmd.getUserName()+"]");
  56. System.out.println(dmd.getDatabaseProductName() );
  57. System.out.println(dmd.getDatabaseProductVersion() );
  58.  
  59. String ver;
  60. ver = System.getProperty("java.version");
  61. System.out.println("The JDK version is " + ver);
  62. }
  63. catch(SQLException e) {
  64. e.printStackTrace();
  65. }
  66.  
  67. }
  68. }
  69.  
  70.  
  71.  
  72. note this is the MOS example with the cmd line params embedded (System.setProperty...)
  73.  
  74. throws this
  75.  
  76. Connection string = jdbc:oracle:thin:@LITPUB_RO
  77. java.sql.SQLException: Io exception: SO Exception was generated
  78. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:158)
  79. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
  80. at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:382)
  81. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:336)
  82. at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:374)
  83. at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:150)
  84. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  85. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:576)
  86. at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:253)
  87. at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:180)
  88. at test.ThinTnsnames.test(ThinTnsnames.java:31)
  89. at test.ThinTnsnames.main(ThinTnsnames.java:15)
  90.  
  91.  
  92.  
  93. if I try to connect with the host:port:service name syntax it works fine
  94.  
  95. jdbc:oracle:thin:@//ora-clu2b-vip:1541/TESTLIT
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement