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
6
votes
3 answers

Send application name when connecting to an Oracle DB using HikariCP in Spring

I have a Spring Boot 1.4.7 application that I am currently updating to version 2.0.5. The application connects to an Oracle DB using JDBC using the following configuration: spring: jpa: database-platform:…
Joba
  • 777
  • 7
  • 24
6
votes
2 answers

Transactions are not getting rollbacked with HikariCP

I am using HikariCP for connection pooling. I have tried setting autoCommit to both true and false. Still my transactions are not getting rollbacked when an exception occur. I have tried the same with org.apache.commons.dbcp.BasicDataSource.…
Abhishek Ramachandran
  • 1,160
  • 1
  • 13
  • 34
6
votes
2 answers

Are there benefits to using a JDBC connection pool with embedded databases?

Are there any advantages to use something like HikariCP with embedded databases like SQLite, H2 or HSQLDB? (the last two can also run in server mode but I'm not interested in that) Apart from the performance benefit (that I suppose would be…
Karl S.
  • 345
  • 1
  • 9
6
votes
1 answer

Hibernate: default transaction timeout with respect to custom @Transactional(timeout)

In my project, which is built on Spring Boot, Hibernate and PostgreSQL (with HikariCP), I would like to set up transaction timeout for the entire app -> I simply want all the transactions that take too long to be terminated because these…
Suchac
  • 91
  • 5
6
votes
2 answers

Cluster wide connection resources management in Ignite, using Hikari

How can I manage resources on ignite. Given the application i am developing, i have a few connections that i used to keep, (JDBC/SAP/others). I used to keep all the connections in a pool and manage them using HIKARI. Now given that now I can have…
frewper
  • 1,385
  • 6
  • 18
  • 44
6
votes
1 answer

HikariCP prepared statement cache

I was looking into HikariCP for using it in one of my projects. The statement cache section of the project page in github says that it doesn't support prepared statement cache at the connection pool level. But the initialization section has the…
sivaguru perumal
  • 103
  • 1
  • 8
6
votes
1 answer

HikariCP auto reconnect

I use jpa+hibernate+hikariCP. Today I got connection closed error. I setted connectionTimeout and ideleTimeout properties(hikari). If in meantime use does not do any operition hikari close the pool connections auto. So that I got closed connection…
sancho
  • 598
  • 2
  • 8
  • 22
6
votes
1 answer

Returning db connection to HikariCP pool with Slick 3.1.x

I'm setting up a slick Database object from typesafe config like so: import com.typesafe.config.Config class DatabaseService(configKey: String, config: Config) { val driver = slick.driver.MySQLDriver import driver.api._ val db =…
novon
  • 973
  • 3
  • 15
  • 30
6
votes
4 answers

Configuration of JTDS for use with HikariCP + Spring + MS SQL Server

I kept googling for configuration of JTDS (1.3.1) for use with HikariCP (2.4.3), Spring (4.1.2), and MS SQL Server (2008), but unable to find a complete and working example. Here is what I have:
curious1
  • 14,155
  • 37
  • 130
  • 231
6
votes
2 answers

What to do when hitting the queue size of slick?

I am using Slick 3.0 with HikariCP 2.3.8 (also play 2.4) I do a lot of database IO and constantly hit the queue limit. Is there a way to get the current queue size and how can it be increased? Or is it even advised to do that or would a wrapper…
Pius Friesch
  • 351
  • 1
  • 6
  • 14
6
votes
2 answers

Why is 'SHOW WARNINGS' query issued here? (JPA/Hibernate/MySQL)

We are refactoring the persistence layer of a Java application from JDBC Template to JPA/Hibernate. I am profiling the SQL statements being issued to the database and I see "SHOW WARNINGS" is issued many, many times. According to JProfiler the…
Justin
  • 6,031
  • 11
  • 48
  • 82
6
votes
1 answer

Configure HikariCP + Hibernate + GuicePersist(JPA) at Runtime

I have a java8 desktop app using GuicePersist, Hibernate, and HikariCP to communicate with a Postgres DB. I've had success getting my app to send/receive data to the DB using this META-INF/persistence.xml:
Ten_Ten_Steve
  • 331
  • 2
  • 6
  • 16
6
votes
3 answers

How to get logging info for HikariCP

Using Hibernate 4.3.1, Hikari 2.3.2. I have configured this in the hibernate persistence xml ...
user2046211
  • 356
  • 1
  • 4
  • 20
6
votes
1 answer

How to configure JNDI datasource in Jboss using HikariCP?

How to configure a JNDI datasource in jboss configuration file using HikariCP I can't find aything in the help contents of Hikari there is only Tomcat configuration . I have a Spring webb app, I have a datasource defined inside the application and I…
Gerson Sosa
  • 366
  • 1
  • 4
  • 12
5
votes
1 answer

Spring Data JPA with Hikari: Why is hikari auto-commit property set to 'true'?

Spring Data JPA or Hibernate have by default auto-commit set to false. This sounds reasonable as these frameworks work with entities and an update to an entity could involve updates to multiple tables through multiple SQL queries. So by setting…
samshers
  • 1
  • 6
  • 37
  • 84
1 2 3
…
91 92