Guest User

Untitled

a guest
Jul 28th, 2018
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.58 KB | None | 0 0
  1. import java.sql.Connection;
  2. import java.sql.DriverManager;
  3. import java.sql.SQLException;
  4.  
  5.  
  6.  
  7. public class MainConfig {
  8.  
  9. public static void main(String[] args) {
  10.  
  11. try{
  12. dataSource();
  13. System.out.println("conected");
  14. }
  15. catch(Exception ex){
  16. ex.printStackTrace();
  17. }
  18. }
  19.  
  20. public static Connection dataSource() throws URISyntaxException, SQLException {
  21.  
  22. String ConnectionString ="jdbc:postgresql://l********n:cPd7VRjIhNVWOrZ4uWEeZWKYqV@ec2-184-73-251-115.compute-1.amazonaws.com:5432/dac36a93ohuvsd";
  23. String username = "****";
  24. String password = "***";
  25.  
  26. return DriverManager.getConnection(ConnectionString, username, password);
  27. }
  28.  
  29. }
  30.  
  31. > org.postgresql.util.PSQLException: The connection attempt failed.
  32. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:233)
  33. at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
  34. at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:144)
  35. at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
  36. at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
  37. at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
  38. at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
  39. at org.postgresql.Driver.makeConnection(Driver.java:410)
  40. at org.postgresql.Driver.connect(Driver.java:280)
  41. at java.sql.DriverManager.getConnection(Unknown Source)
  42. at java.sql.DriverManager.getConnection(Unknown Source)
  43. at MainConfig.dataSource(MainConfig.java:34)
  44. at MainConfig.main(MainConfig.java:14)
  45. Caused by: java.net.UnknownHostException: lxlrnhejlzmyun:cPd7VRjIhNVWOrZ4uWEeZWKYqV@ec2-184-73-251-115.compute-1.amazonaws.com
  46. at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
  47. at java.net.PlainSocketImpl.connect(Unknown Source)
  48. at java.net.SocksSocketImpl.connect(Unknown Source)
  49. at java.net.Socket.connect(Unknown Source)
  50. at org.postgresql.core.PGStream.<init>(PGStream.java:61)
  51. at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:109)
  52. ... 12 more
  53.  
  54. import java.net.URI;
  55. import java.net.URISyntaxException;
  56. import java.sql.Connection;
  57. import java.sql.DriverManager;
  58. import java.sql.SQLException;
  59.  
  60.  
  61.  
  62. public class MainConfig {
  63.  
  64. public static void main(String[] args) {
  65.  
  66. try{
  67. dataSource();
  68. System.out.println("conected");
  69. }
  70. catch(Exception ex){
  71. ex.printStackTrace();
  72. }
  73. }
  74.  
  75. public static Connection dataSource() throws URISyntaxException, SQLException {
  76. URI dbUri = new URI(System.getenv("postgres://l**********n:cPd7VRjIhNVWOrZ4uWEeZWKYqV@ec2-184-73-251-115.compute-1.amazonaws.com:5432/dac36a93ohuvsd"));
  77.  
  78. String username = dbUri.getUserInfo().split(":")[0];
  79. String password = dbUri.getUserInfo().split(":")[1];
  80. String ConnectionString = "jdbc:postgresql://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath();
  81.  
  82.  
  83.  
  84. return DriverManager.getConnection(ConnectionString, username, password);
  85. }
  86.  
  87. }
  88.  
  89. > java.lang.NullPointerException
  90. at java.net.URI$Parser.parse(Unknown Source)
  91. at java.net.URI.<init>(Unknown Source)
  92. at MainConfig.dataSource(MainConfig.java:23)
  93. at MainConfig.main(MainConfig.java:14)
  94.  
  95. ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
  96.  
  97. jdbc:postgresql://host:port/database?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
  98.  
  99. error: no pg_hba.conf entry for host
Add Comment
Please, Sign In to add comment