Stack Overflow
Stack Overflow

Questions tagged [hikaricp]

HikariCP is a high-performance JDBC connection pool library.

HikariCP is a "zero-overhead" production-ready JDBC connection pool. Hikari (光) is Japanese and means "light" or "ray".

Resources:

Spring prefers HikariCP as a connection pool to production databases:

We prefer HikariCP for its performance and concurrency. If HikariCP is available, we always choose it.

1370 questions
26
votes
4 answers

Disable HikariPool logging

This is perhaps a very simple question. How do i disable Hikari-CP debug logs? In my log file i have lots of these messages DEBUG [.zaxxer.hikari.pool.HikariPool:] - Before cleanup pool stats HikariPool-0 (total=10, inUse=0, avail=10,…
siphiuel
  • 3,480
  • 4
  • 31
  • 34
25
votes
1 answer

Hikari CP maxLifetime / idleTimeout

Hikari CP Version : 2.7.4 This is actually not an issue but some doubts. a) maxLifetime : retires the connection after 30 mins. Will it also create a new connection automatically at the time of killing it or it waits for a new request and then…
Ankit Bansal
  • 2,162
  • 8
  • 42
  • 79
25
votes
2 answers

Play application dies in idle state, restart on new request?

I am using HikariCp, Hibernate with my playframework application in java. After few mins of idle state, it seems play application dies, and when it gets new request it starts again. Sometime I have also seen Db persistence error with message that…
Ankit Jain
  • 798
  • 8
  • 20
24
votes
1 answer

HikariCP Idle connections staying in connection pool as active

I am using Spring Boot (1.5.6), Hibernate, Postgres, Hikari (2.7.8) . My configuration is…
Saif
  • 6,804
  • 8
  • 40
  • 61
23
votes
2 answers

Spring retry connection until datasource is available

I have a docker-compose setup to start my SpringBoot application and a MySQL database. If the database starts first, then my application can connect successfully. But if my application starts first, no database exists yet, so the application throws…
Leonardo Nahra
  • 333
  • 1
  • 2
  • 6
23
votes
2 answers

How do I configure HikariCP and Dropwizard/Coda-Hale metrics in Spring Boot application

Reading the instructions on the HikariCP wiki about how to enable the Dropwizard metrics, it says to just configure a MetricsRegistry instance in HikariConfig or HikariDatasource. Problem is, in Spring Boot, all the configuration is handled by…
Kevin M
  • 2,717
  • 4
  • 26
  • 31
21
votes
1 answer

How does HikariCP handle incomplete JDBC transactions?

Yesterday I came across HikariCP and spent the whole night studying it. I'm really impressed with the amount of detail and effort put into fine tuning its implementation and design. Straight to the point, I could not determine how it actually deals…
Hamid Nazari
  • 506
  • 1
  • 6
  • 18
20
votes
7 answers

The web application appears to have started a thread named [HikariPool-1 housekeeper] but has failed to stop it

I am trying use HikariCP JNDI DataSource Factory within Tomcat 8.5 but when it shutdown I'm getting these warning: o.a.c.loader.WebappClassLoaderBase : The web application [ROOT] appears to have started a thread named [HikariPool-1…
Lucas Oliveira
  • 833
  • 1
  • 10
  • 24
19
votes
1 answer

Why 'Quarkus' chose 'Agroal' instead of 'HikariCP' as the preferred datasource and connection pooling implementation?

As per the Quarkus documentation : In Quarkus, the preferred datasource and connection pooling implementation is Agroal. But, I don't see any review or comparison of 'Agroal' with the well known JDBC Connection Pooling implementation…
RafiAlhamd
  • 341
  • 2
  • 13
19
votes
1 answer

Scala / Slick, "Timeout after 20000ms of waiting for a connection" error

The block of code below has been throwing an error. Timeout after 20000ms of waiting for a connection.","stackTrace":[{"file":"BaseHikariPool.java","line":228,"className":"com.zaxxer.hikari.pool.BaseHikariPool","method":"getConnection" Also, my…
user2827214
  • 1,191
  • 1
  • 13
  • 32
18
votes
0 answers

Postgresql connection marked as broken by Hikari

I have Spring application that regularly inserts records in a PostgreSQL-DB. Now, after a scheduled set of imports is done it takes a few seconds until I get the following warning: com.zaxxer.hikari.pool.ProxyConnection : HikariPool-1 - Connection…
fhueser
  • 599
  • 3
  • 16
18
votes
4 answers

how to check HikariCP connection pooling is working or not in Java?

I have written following properties in my configuration files I am using Log4j in my application When I am running a project. I am getting following message.does that mean connection pooling is configured in my project? if not then how it will…
Tejal
  • 764
  • 1
  • 10
  • 39
17
votes
3 answers

HikariPool-1 - Connection marked as broken because of SQLSTATE(08006), ErrorCode(0)

After we setup PostgreSQL server with SSL certificates we get this error very often. This happens on the flows with a lot of interaction with the database(update a lot of entries/insert) HikariPool-1 - Connection marked as broken because of…
Cristina
  • 341
  • 2
  • 3
  • 11
17
votes
1 answer

HikariPool-1 - Connection marked as broken because of SQLSTATE(08S01), ErrorCode(-99999)

HikariPool-1 - Connection marked as broken because of SQLSTATE(08S01), ErrorCode(-99999) java.sql.SQLNonTransientConnectionException: Communication link failure. (Read timed out) I kept getting this problem, when creating a table with data, which…
Anders Metnik
  • 6,096
  • 7
  • 40
  • 79
17
votes
2 answers

HikariCP and maxLifetime

I moved my project to HikariCP. Everything is going fine so far, but with one setting I'm having trouble. It's the .setMaxLifetime(30*1000) setting in HikariConfig object. I get this warning WARN com.zaxxer.hikari.HikariConfig - maxLifetime is less…
Gabriel
  • 1,820
  • 2
  • 23
  • 31
1
2
3
…
91 92