Spring Boot Hikari wrong connection url

Question

I'm making a web app using spring boot but I don't wanna set connection url, username and password in application.properties so I config DataSource programmatically via HikariCP.

Here is my code:

DBConfig.java:

@Configuration
public class DBConfig {
    @Bean
    public DataSource getDataSource() {

        DataSource ds = null;

        if (ds == null) {
            HikariConfig config = new HikariConfig();
            config.setJdbcUrl(System.getenv("WJ_URL"));
            config.setUsername(System.getenv("WJ_USER"));
            config.setPassword(System.getenv("WJ_PASS"));
            config.setDataSourceClassName("org.postgresql.ds.PGSimpleDataSource");

            ds = new HikariDataSource(config);
        }

        return ds;

    }

}

I pretty sure that I set correct URL and another credentials info but it still got exception:

org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Here is the connection url via system env:

WJ_URL=jdbc:postgresql://db.sakadream.me:5432/weebjournal

See https://stackoverflow.com/questions/50213381/how-do-i-configure-hikaricp-for-postgresql/50213758#50213758 — Ori Marko, Jul 01 '19 at 13:48
Or https://stackoverflow.com/questions/34741443/hikaricp-postgresql-driver-claims-to-not-accept-jdbc-url — Ori Marko, Jul 01 '19 at 13:53
Did you modify the environment variable after application is started? — LHCHIN, Jul 02 '19 at 03:29
You have to do provide connections for HIKARICP as well as SPRING.DATASOURCE . I was facing the same thing — Arpan Sharma, May 12 '20 at 04:22

Spring Boot Hikari wrong connection url

0 Answers0