Pessoal preciso de um help, não estou conseguindo fazer uma conexão simples com o banco, no java pelo o Postgres, localhost eu consigo normal somente hospedado não, qual a alternativa para resolver o problema?
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conexao {
public static void main (String[] args){
String url = "jdbc:postgresql://"hospedagem"/"Database"";
String user = "Usuario";
String senha = "Senha";
try {
DriverManager.getConnection(url,user,senha);
System.out.println(“Conexao realizada com sucesso”);
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println(“Falha de Conexao”);
throw new RuntimeException(e);
}
}
}
Conexao realizada com sucesso
Falha de Conexao
Exception in thread “main” java.lang.RuntimeException: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “IP”, user “usuario”, database “database”, SSL on
at gerador.Conexao.main(Conexao.java:27)
Caused by: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “IP”, user “postgres”, database “ciaar”, SSL on
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:192)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:49)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:195)
at org.postgresql.Driver.makeConnection(Driver.java:454)
at org.postgresql.Driver.connect(Driver.java:256)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at gerador.Conexao.main(Conexao.java:23)
Suppressed: org.postgresql.util.PSQLException: FATAL: no pg_hba.conf entry for host “177.94.228.131”, user “postgres”, database “ciaar”, SSL off
at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:514)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:141)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:201)
… 7 more