Guest User

Untitled

a guest
Jul 11th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.50 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.ResultSet;
  4. import java.sql.Statement;
  5.  
  6. public class JdbcDemo {
  7. public static void main(String[] args){
  8. try{
  9.  
  10. Class.forName("oracle.jdbc.driver.OracleDriver");
  11. System.out.println("COnnection started");
  12. Connection con = DriverManager.getConnection("jdbc:oracle:thin:@"+"db_ip"+":"+"1521"+"/"+"db_name","db_user","password");
  13. System.out.println("COnnection Established");
  14. //Statement st=con.createStatement();
  15. System.out.println("connection name"+con);
  16. //ResultSet rs=st.executeQuery("");
  17.  
  18. }
  19. catch(Exception e){
  20.  
  21. e.printStackTrace();
  22. }
  23. }
  24.  
  25. root@app_server_ip # java -cp .:ojdbc7.jar JdbcDemo
  26. COnnection started
  27. java.sql.SQLRecoverableException: IO Error: Connection reset
  28. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:841)
  29. at oracle.jdbc.driver.PhysicalConnection.connect(PhysicalConnection.java:755)
  30. at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:38)
  31. at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:599)
  32. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  33. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  34. at JdbcDemo.main(JdbcDemo.java:13)
  35. Caused by: java.net.SocketException: Connection reset
  36. at java.net.SocketInputStream.read(SocketInputStream.java:209)
  37. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  38. at oracle.net.ns.Packet.receive(Packet.java:317)
  39. at oracle.net.ns.DataPacket.receive(DataPacket.java:101)
  40. at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:301)
  41. at oracle.net.ns.NetInputStream.read(NetInputStream.java:245)
  42. at oracle.net.ns.NetInputStream.read(NetInputStream.java:167)
  43. at oracle.net.ns.NetInputStream.read(NetInputStream.java:85)
  44. at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:119)
  45. at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:75)
  46. at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:447)
  47. at oracle.jdbc.driver.T4C8TTIdty.receive(T4C8TTIdty.java:706)
  48. at oracle.jdbc.driver.T4C8TTIdty.doRPC(T4C8TTIdty.java:611)
  49. at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:2161)
  50. at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:564)
  51. ... 6 more
Add Comment
Please, Sign In to add comment