Guest User

Untitled

a guest
Nov 21st, 2017
146
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.90 KB | None | 0 0
  1. Connection Failed! Check output console
  2. org.postgresql.util.PSQLException: The connection attempt failed.
  3. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:275)
  4. at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
  5. at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:194)
  6. at org.postgresql.Driver.makeConnection(Driver.java:450)
  7. at org.postgresql.Driver.connect(Driver.java:252)
  8. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  9. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  10. at JDBCExample.main(JDBCExample.java:31)
  11. Caused by: java.net.SocketTimeoutException: connect timed out
  12. at java.net.PlainSocketImpl.socketConnect(Native Method)
  13. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  14. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  15. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  16. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  17. at java.net.Socket.connect(Socket.java:589)
  18. at org.postgresql.core.PGStream.<init>(PGStream.java:68)
  19. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:144)
  20. ... 7 more
  21.  
  22. public class JDBCExample {
  23.  
  24. public static void main(String[] argv) {
  25.  
  26. System.out.println("-------- PostgreSQL "
  27. + "JDBC Connection Testing ------------");
  28.  
  29. try {
  30.  
  31. Class.forName("org.postgresql.Driver");
  32.  
  33. } catch (ClassNotFoundException e) {
  34.  
  35. System.out.println("Where is your PostgreSQL JDBC Driver? "
  36. + "Include in your library path!");
  37. e.printStackTrace();
  38. return;
  39.  
  40. }
  41.  
  42. System.out.println("PostgreSQL JDBC Driver Registered!");
  43.  
  44. Connection connection = null;
  45.  
  46. try {
  47.  
  48. connection = DriverManager.getConnection(
  49. "jdbc:postgresql://aaa.bbb.ccc.ddd:5432/test", "tom",
  50. "secret");
  51.  
  52. } catch (SQLException e) {
  53.  
  54. System.out.println("Connection Failed! Check output console");
  55. e.printStackTrace();
  56. return;
  57.  
  58. }
  59. catch (Exception e) {
  60. e.printStackTrace();
  61. }
  62.  
  63. if (connection != null) {
  64. System.out.println("You made it, take control your database now!");
  65. } else {
  66. System.out.println("Failed to make connection!");
  67. }
  68. }
  69. }
Add Comment
Please, Sign In to add comment