How do I configure HikariCP for postgresql?

Question

I'm trying to use HikariCP in postgresql and I can't find anywhere the configuration for postgresql.

Please point me to any example for postgresql with HikariCP or any configurations tutorial for the same.

I tried to use it like below but it didn't work and then I realized it was meant for MySQL

public static DataSource getDataSource()

    {

            if(datasource == null)

            {

                    HikariConfig config = new HikariConfig();


            config.setJdbcUrl("jdbc:mysql://localhost/test");

            config.setUsername("root");

            config.setPassword("password");



            config.setMaximumPoolSize(10);

            config.setAutoCommit(false);

            config.addDataSourceProperty("cachePrepStmts", "true");

            config.addDataSourceProperty("prepStmtCacheSize", "250");
            config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");



            datasource = new HikariDataSource(config);

            }

           return datasource;

    }

Ori Marko · Accepted Answer · 2018-05-07 12:01:16Z

10

You have example in HikariCP configuration wiki page

 Properties props = new Properties();

props.setProperty("dataSourceClassName", "org.postgresql.ds.PGSimpleDataSource");
props.setProperty("dataSource.user", "test");
props.setProperty("dataSource.password", "test");
props.setProperty("dataSource.databaseName", "mydb");
props.put("dataSource.logWriter", new PrintWriter(System.out));

HikariConfig config = new HikariConfig(props);
HikariDataSource ds = new HikariDataSource(config);

answered May 7, 2018 at 12:01

Ori Marko

59.3k26 gold badges157 silver badges259 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

mancini0 Over a year ago

where is the hostname specified?

dpelisek Over a year ago

what about the schema, please? neither property datasource.hikari.schema nor DataSource::setSchema has any effect. PostgreSQL seems to use "current schema". Is there a way to set it in HikariDataSource?

Ori Marko Over a year ago

@dpelisek see stackoverflow.com/questions/4168689/…

Quinn Mercer · Accepted Answer · 2022-05-23 19:37:09Z

This worked for me:

    HikariConfig config = new HikariConfig();

    config.setDataSourceClassName("org.postgresql.ds.PGSimpleDataSource");
    config.addDataSourceProperty("serverName", "xxxxxxxxxxxxxxxxxx");
    config.addDataSourceProperty("portNumber", "xxxx");
    config.addDataSourceProperty("databaseName", "xxxxxxxxxx");
    config.addDataSourceProperty("user", "xxxxxxxxxxxxxxxxxxxxxxxxxx");
    config.addDataSourceProperty("password", "xxxxxxxxxxxxx");

    // postgress configuration for Hikari
    HikariDataSource ds = new HikariDataSource(config);

    return ds;

Also make sure you have the Maven dependency

<!-- Postgress JDBC Driver -->
        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>42.2.10</version>
        </dependency>

SebastianH · Accepted Answer · 2021-04-14 15:43:54Z

-1

It worked for me with these setting in the application.yaml:

javax:
  sql:
    DataSource:
      postgresDataSource:
        dataSourceClassName: org.postgresql.ds.PGSimpleDataSource
        dataSource:
          #url: jdbc:postgresql://localhost:5432/test
          serverName: localhost
          portNumber: 5432
          databaseName: test
          user: ...
          password: ...

answered Apr 14, 2021 at 15:43

SebastianH

2,1821 gold badge19 silver badges29 bronze badges

1 Comment

Emiter Over a year ago

And what mechanism reads this password? Why there is url commented out ?

Collectives™ on Stack Overflow

How do I configure HikariCP for postgresql?

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related