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
5
votes
1 answer

HikariCP Maximum Pool Size with SSDs

I've implemented HikariCP for a few apps. So far, in the "simpliest" one it's working pretty good, even boosting performance and showing where we should try to optimize. Anyway, that app is in a server with 4 HDD on RAID and it's an 8-core machine.…
Jetto Martínez
  • 917
  • 7
  • 17
5
votes
1 answer

Spring Boot application performs extremely high number of SET application_name queries to postgres

I have a Spring Boot application (v2.1.5) that uses JPA (Hibernate) to connect to a Postgres DB. Spring Boot uses HikariCP for connection pooling. In my production environment, I see the following query executed every few seconds regardless of DB…
edoDev
  • 551
  • 1
  • 4
  • 20
5
votes
4 answers

Spring Boot 2 with pgBouncer pooling

I have a PostgreSQL 11 server with pgBouncer pooling set up and enabled. I'd like to use its pooling mechanism rather than default Hikari and Tomcat pooling that come with the Spring Boot's spring-boot-starter-data-jpa. I've disabled HikariCP and…
curiousdev
  • 626
  • 8
  • 24
5
votes
1 answer

Unable to obtain isolated JDBC connection: org.hibernate.exception.JDBCConnectionException

I am facing this problem for 2 hours. The problem is I have other classes that are working well. I don't know why this error is happening for the current class. org.hibernate.exception.JDBCConnectionException: unable to obtain isolated JDBC…
Ahmet Aziz Beşli
  • 1,280
  • 3
  • 19
  • 38
5
votes
1 answer

HikariCP vs. JDBC Metrics Spring Boot2

What is the difference between "hikaricp.connections." and "jdbc.connections." meter names? I have a Spring Boot 2 application that is defaulting to the Hikari connection pool mechanism and I am tring to understand how to best monitor the database…
Nick Marchessault
  • 53
  • 1
  • 5
5
votes
2 answers

How to close SQL connections of old Cloud Run revisions?

Context I am running a SpringBoot application on Cloud Run which connects to a postgres11 CloudSQL database using a Hikari connection pool. I am using the smallest PSQL instance (1vcpu/614mb/25connection limit). For the setup, I have followed these…
Bastian Stein
  • 2,147
  • 1
  • 13
  • 28
5
votes
3 answers

How to specify database specific properties while using HikariCP in Java?

I need to add Oracle database properties likes below while initiating database connection by HikariCP library, but did not found any example online. oracle.jdbc.timezoneAsRegion=true oracle.jdbc.timestampTzInGmt=true
changed
  • 2,103
  • 8
  • 36
  • 56
5
votes
1 answer

Does max connection pool also limits max connections to database?

I am using hikari cp with spring boot app which has more that 1000 concurrent users. I have set the max pool size- spring.datasource.hikari.maximum-pool-size=300 When i look at the processlist of mysql using show processlist; It shows max 300…
megamind
  • 424
  • 1
  • 4
  • 19
5
votes
4 answers

Spring Boot 2 disable Autocommit Hikari with multiple datasources

I am attempting to turn off auto-commit on Hikari with multiple data sources, but I'm not having any luck. I'm using Spring Boot 2 (2.0.3.RELEASE). Here is my…
csyperski
  • 992
  • 3
  • 15
  • 33
5
votes
3 answers

How to restrict initial pool size in hikaricp?

I used to have a tomcat connection pool configuration restricting the initial pool size: spring.datasource.tomcat.initial-size=2 Now switching to hikaricp: what is the equivalent to restrict the initially started connections? Sidenote:…
membersound
  • 81,582
  • 193
  • 585
  • 1,120
5
votes
1 answer

java 9 third party modules works with IDE but not with jlink

The program based on JDK 9(JPMS), using some third party jars like Apache (poi-3.17.jar, commons-io-2.6.jar ) & HikariCP (HikariCP-3.1.0.jar) , when using the IDE(Intellij) I "requires" them and the program works fine . When I try get my customeized…
Mohd
  • 191
  • 3
  • 14
5
votes
2 answers

How to configure HikariCP via Tomee.xml?

I want to test out hikaricp in TomEE. I have added the jar-file into my lib folder, and have tried defining the resources like this:
Runar Halse
  • 3,528
  • 10
  • 39
  • 59
5
votes
2 answers

PreparedStatement won't ever timeout even if explicitly set

I am trying to simulate an scenario where my service loses connection to a database and cannot do an INSERT by blocking the connection with iptables, but I can't make the executeQuery() method to timeout. What I did is setting a timeout for the…
fcasanova
  • 197
  • 1
  • 4
  • 15
5
votes
1 answer

2 Hikari CPs with different datasource configurations?

Has anyone successfully configured two hikari connection pools with different datasources in a spring boot application? How do I do it using application.properties?
gcpdev-guy
  • 460
  • 1
  • 10
  • 23
5
votes
1 answer

HikariCP for Grails 3

I have a hard time setting up HikariCP in Grails 3. The only thing I could realize by myself is that application.yml/dataSource.pooled must be false. The rest is kinda mystery: This gist seems like configuration for Grails 2 Other SO questions are…
Amio.io
  • 20,677
  • 15
  • 82
  • 117
1 2 3
…
91 92