Advertisement
Guest User

Untitled

a guest
Apr 5th, 2017
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.33 KB | None | 0 0
  1. public static void main(String args[]) throws ClassNotFoundException, SQLException {
  2. Connection conn = null;
  3. Statement stmt = null;
  4. Class.forName("org.postgresql.Driver");
  5.  
  6. conn = DriverManager.getConnection("jdbc:postgresql://localhost:5400/database", "root", "123");
  7. conn.setAutoCommit(false);
  8. System.out.println("open database successfully");
  9.  
  10. stmt = conn.createStatement();
  11. String sql = "select * from table";
  12.  
  13. stmt.execute(sql);
  14. stmt.close();
  15. conn.commit();
  16. conn.close();
  17. }
  18.  
  19. Exception in thread "main" org.postgresql.util.PSQLException: Connection Failed
  20. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
  21. at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
  22. at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
  23. at org.postgresql.Driver.makeConnection(Driver.java:431)
  24. at org.postgresql.Driver.connect(Driver.java:247)
  25. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  26. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  27. at ConnectDB.main(FindFeature.java:15)
  28. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  29. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  30. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  31. at java.lang.reflect.Method.invoke(Method.java:498)
  32. at com.intellij.rt.execution.application.AppMain.main(AppMain.java:147)
  33. Caused by: java.net.SocketException: Software caused connection abort: recv failed
  34. at java.net.SocketInputStream.socketRead0(Native Method)
  35. at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
  36. at java.net.SocketInputStream.read(SocketInputStream.java:170)
  37. at java.net.SocketInputStream.read(SocketInputStream.java:141)
  38. at org.postgresql.core.VisibleBufferedInputStream.readMore(VisibleBufferedInputStream.java:140)
  39. at org.postgresql.core.VisibleBufferedInputStream.ensureBytes(VisibleBufferedInputStream.java:109)
  40. at org.postgresql.core.VisibleBufferedInputStream.read(VisibleBufferedInputStream.java:67)
  41. at org.postgresql.core.PGStream.receiveChar(PGStream.java:282)
  42. at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:418)
  43. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:222)
  44. ... 12 more
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement