Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class MainConfig {
- public static void main(String[] args) {
- try{
- dataSource();
- System.out.println("conected");
- }
- catch(Exception ex){
- ex.printStackTrace();
- }
- }
- public static Connection dataSource() throws URISyntaxException, SQLException {
- String ConnectionString ="jdbc:postgresql://l********n:cPd7VRjIhNVWOrZ4uWEeZWKYqV@ec2-184-73-251-115.compute-1.amazonaws.com:5432/dac36a93ohuvsd";
- String username = "****";
- String password = "***";
- return DriverManager.getConnection(ConnectionString, username, password);
- }
- }
- > org.postgresql.util.PSQLException: The connection attempt failed.
- at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:233)
- at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64)
- at org.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:144)
- at org.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29)
- at org.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21)
- at org.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31)
- at org.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24)
- at org.postgresql.Driver.makeConnection(Driver.java:410)
- at org.postgresql.Driver.connect(Driver.java:280)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at java.sql.DriverManager.getConnection(Unknown Source)
- at MainConfig.dataSource(MainConfig.java:34)
- at MainConfig.main(MainConfig.java:14)
- Caused by: java.net.UnknownHostException: lxlrnhejlzmyun:cPd7VRjIhNVWOrZ4uWEeZWKYqV@ec2-184-73-251-115.compute-1.amazonaws.com
- at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
- at java.net.PlainSocketImpl.connect(Unknown Source)
- at java.net.SocksSocketImpl.connect(Unknown Source)
- at java.net.Socket.connect(Unknown Source)
- at org.postgresql.core.PGStream.<init>(PGStream.java:61)
- at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:109)
- ... 12 more
- import java.net.URI;
- import java.net.URISyntaxException;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- public class MainConfig {
- public static void main(String[] args) {
- try{
- dataSource();
- System.out.println("conected");
- }
- catch(Exception ex){
- ex.printStackTrace();
- }
- }
- public static Connection dataSource() throws URISyntaxException, SQLException {
- URI dbUri = new URI(System.getenv("postgres://l**********n:cPd7VRjIhNVWOrZ4uWEeZWKYqV@ec2-184-73-251-115.compute-1.amazonaws.com:5432/dac36a93ohuvsd"));
- String username = dbUri.getUserInfo().split(":")[0];
- String password = dbUri.getUserInfo().split(":")[1];
- String ConnectionString = "jdbc:postgresql://" + dbUri.getHost() + ':' + dbUri.getPort() + dbUri.getPath();
- return DriverManager.getConnection(ConnectionString, username, password);
- }
- }
- > java.lang.NullPointerException
- at java.net.URI$Parser.parse(Unknown Source)
- at java.net.URI.<init>(Unknown Source)
- at MainConfig.dataSource(MainConfig.java:23)
- at MainConfig.main(MainConfig.java:14)
- ?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
- jdbc:postgresql://host:port/database?ssl=true&sslfactory=org.postgresql.ssl.NonValidatingFactory
- error: no pg_hba.conf entry for host
Add Comment
Please, Sign In to add comment