Advertisement
Guest User

Untitled

a guest
Aug 14th, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.01 KB | None | 0 0
  1. public static void main(String args[])
  2. throws ClassNotFoundException,SQLException,
  3. ConnectException
  4. {
  5. Class.forName("oracle.jdbc.driver.OracleDriver");
  6. Connection con=DriverManager.getConnection
  7. ("jdbc:oracle:thin:@hostname:1521/
  8. servicename", "uname", "passwd");
  9. con.close();
  10. }
  11.  
  12. SQLState(08006) vendor code(17002)
  13. java.sql.SQLRecoverableException: IO Error:
  14. The Network Adapter could not establish the connection
  15. at oracle.jdbc.driver.SQLStateMapping.newSQLException
  16. (SQLStateMapping.java:100)
  17. at
  18. oracle.jdbc.driver.DatabaseError.newSQLException
  19. (DatabaseError.java:144)
  20. at oracle.jdbc.driver.DatabaseError.createSqlException
  21. (DatabaseError.java:191)
  22. at oracle.jdbc.driver.DatabaseError.createSqlException
  23. (DatabaseError.java:258)
  24. at oracle.jdbc.driver.DatabaseError.createSqlException
  25. (DatabaseError.java:482)
  26. at
  27. oracle.jdbc.driver.T4CConnection.logon
  28. (T4CConnection.java:488)
  29. at
  30. oracle.jdbc.driver.PhysicalConnection.<init>
  31. (PhysicalConnection.java:553)
  32. at
  33. oracle.jdbc.driver.T4CConnection.<init>
  34. (T4CConnection.java:254)
  35. at oracle.jdbc.driver.T4CDriverExtension.getConnection
  36. (T4CDriverExtension.java:32)
  37. at oracle.jdbc.driver.OracleDriver.connect
  38. (OracleDriver.java:528)
  39. at java.sql.DriverManager.getConnection(Unknown Source)
  40. at java.sql.DriverManager.getConnection(Unknown Source)
  41. at webdriver.TlgDB.main(TlgDB.java:20)
  42. SQLState(99999) vendor code(17430)
  43. java.sql.SQLException: Must be logged on to server
  44. at oracle.jdbc.driver.SQLStateMapping.newSQLException
  45. (SQLStateMapping.java:71)
  46. at oracle.jdbc.driver.DatabaseError.newSQLException
  47. (DatabaseError.java:144)
  48. at oracle.jdbc.driver.DatabaseError.createSqlException
  49. (DatabaseError.java:191)
  50. at oracle.jdbc.driver.DatabaseError.createSqlException
  51. (DatabaseError.java:258)
  52. at oracle.jdbc.driver.DatabaseError.createSqlException
  53. (DatabaseError.java:266)
  54. at oracle.jdbc.driver.DatabaseError.createSqlException
  55. (DatabaseError.java:413)
  56. at oracle.jdbc.driver.T4CConnection.assertLoggedOn
  57. (T4CConnection.java:3828)
  58. at oracle.jdbc.driver.T4CConnection.logoff
  59. (T4CConnection.java:569)
  60. at oracle.jdbc.driver.PhysicalConnection.<init>
  61. (PhysicalConnection.java:662)
  62. at oracle.jdbc.driver.T4CConnection.<init>
  63. (T4CConnection.java:254)
  64. at oracle.jdbc.driver.T4CDriverExtension.getConnection
  65. (T4CDriverExtension.java:32)
  66. at oracle.jdbc.driver.OracleDriver.connect
  67. (OracleDriver.java:528)at java.sql.DriverManager.getConnection
  68. (Unknown Source)at java.sql.DriverManager.getConnection
  69. (Unknown Source)at webdriver.TlgDB.main(TlgDB.java:20)
  70. getConnection failed: java.sql.SQLRecoverableException:
  71. IO Error: The Network Adapter could not establish the connection
  72. Exception in thread "main" java.sql.SQLRecoverableException:
  73. IO Error: The Network Adapter could not establish the connection
  74. at oracle.jdbc.driver.T4CConnection.logon
  75. (T4CConnection.java:489)
  76. at oracle.jdbc.driver.PhysicalConnection.<init>
  77. (PhysicalConnection.java:553)
  78. at oracle.jdbc.driver.T4CConnection.<init>
  79. (T4CConnection.java:254)
  80. at oracle.jdbc.driver.T4CDriverExtension.getConnection
  81. (T4CDriverExtension.java:32)
  82. at oracle.jdbc.driver.OracleDriver.connect
  83. (OracleDriver.java:528)at java.sql.DriverManager.getConnection
  84. (Unknown Source)at java.sql.DriverManager.getConnection
  85. (Unknown Source)
  86. at webdriver.TlgDB.main(TlgDB.java:20)
  87. Caused by: oracle.net.ns.NetException: The Network Adapter could
  88. not establish the connection
  89. at oracle.net.nt.ConnStrategy.execute
  90. (ConnStrategy.java:439)
  91. at oracle.net.resolver.AddrResolution.resolveAndExecute
  92. (AddrResolution.java:454)
  93. at oracle.net.ns.NSProtocol.establishConnection
  94. (NSProtocol.java:693)
  95. at oracle.net.ns.NSProtocol.connect(NSProtocol.java:347)
  96. at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1140)
  97. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:340)
  98. ... 7 more
  99. Caused by: java.net.ConnectException: Connection timed out: connect
  100. at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
  101. at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
  102. at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
  103. at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
  104. at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
  105. at java.net.PlainSocketImpl.connect(Unknown Source)
  106. at java.net.SocksSocketImpl.connect(Unknown Source)
  107. at java.net.Socket.connect(Unknown Source)
  108. at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:149)
  109. at oracle.net.nt.ConnOption.connect(ConnOption.java:133)
  110. at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:405)
  111. ... 12 more
  112.  
  113. String url = "jdbc:oracle:thin:@
  114. (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
  115. (HOST=l1tlg1c28.hydc.sbc.com)(PORT=1521))"+
  116. "(CONNECT_DATA=(SERVER=DEDICATED)
  117. (SERVICE_NAME=LE2EX5_DB.DB.ATT.COM)))";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement