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

How to configure HikariCP with PostgreSQL

I am trying to integrate HikariCP with PostgreSQL in my web application,I am using the postgresql driver and this DataSource class: org.postgresql.ds.PGSimpleDataSource and my hibernate configuration file is this:
0
votes
0 answers

Manage BBDD active sessions Spring MVC + Hibernate + Hikari

With a Web Service development in Java running in a JBoss 7, I experience a weird error managing pool sessions on BBDD. I am using a Hikari component linked to Hibernate 4 and Spring in order to manage BBDD connections, exactly in ORACLE. Here it…
DCA
  • 453
  • 1
  • 4
  • 5
0
votes
0 answers

What causes connection errors resulting in: message from server: "xxxx' is blocked because of many connection errors'

My application uses Hikari DB Pool. I run the application on one of my local machines (it's home network) but application uses remote database hosted by other company. The application inserts some records every 5 minutes to the DB so it is in…
Mariusz.v7
  • 2,322
  • 2
  • 16
  • 24
0
votes
0 answers

How to get db connection from HikariCP

I added HikariCP and Ebean to my Play Framework project. When the project starts, Play reporting that connection pool is created: [info] application - Creating Pool for datasource 'default' How can I retrieve this pool/connections for my own…
Nikolay Matkheev
  • 375
  • 1
  • 2
  • 10
0
votes
0 answers

Hikari and MySQL documentation inconsistency

I'm switching my Spring Boot+MySQL connection from Tomcat-based to HikariCP. I read the documentation and I got confused. Here they say: MysqlDataSource is known to be broken, use jdbcUrl configuration instead. At the same time, at recomended…
jarosik
  • 4,136
  • 10
  • 36
  • 53
0
votes
1 answer

What should the scope of a HikariDataSource object be?

I'm trying to use the HikariCP to pool my database connections. Reading through their documentations quickly, I'm not sure if I should keep my HikariDataSource object in memory and always ask from the exact same object for new connections or can I…
Mehran
  • 15,593
  • 27
  • 122
  • 221
0
votes
0 answers

Hikari + Grails (Hibernate)

After setting up Hikari to our Grails Application (as described here ), I had to find out by observation that the hibernate behavior changed suddenly when using onAfterSave in a Gorm Domain Object: …
user39950
  • 464
  • 3
  • 15
0
votes
0 answers

Why Play Framework does not start when a JDBC datasource cannot create?

I have a Play 2.5 (Java) project, my project depend on 3 JDBC datasources that defined in application.conf. Why Play Framework does not start when one of these JDBC datasources cannot create? My system can work without one of these JDBC datasources…
Saeed Zarinfam
  • 9,818
  • 7
  • 59
  • 72
0
votes
1 answer

Play Framework - No EntityManager found in the context

Hi I am getting an exception while doing db operations. java.lang.RuntimeException: No EntityManager found in the context. Try to annotate your action method with @play.db.jpa.Transactional Below is the code paymentResponse.onRedeem(response ->…
Sammy Pawar
  • 1,201
  • 3
  • 19
  • 38
0
votes
1 answer

Jenkins at deploy of a SpringMVC JPA webapp MySQL connections not freed HikariCP

Environment: Ubuntu 14.04.4 Application in development details: Spring 4.2.5.RELEASE MVC webapp, MySQL with 151 + 1 MAX_CONNECTIONS, Hibernate, HikariCP as datasource with 20 connections per pool, 1 pool. Automated deployment tool:…
XMight
  • 1,991
  • 2
  • 20
  • 36
0
votes
1 answer

Hikari configuration in xml for Master/Slave Datasources

Presently I have a datasource configured using Hikari in my applicationContext.xml. I want to configure in the same xml file for a master/slave kind of datasource. Also how do I establish a new entity manager factory in the same ? My…
The-Proton-Resurgence
  • 808
  • 1
  • 13
  • 28
0
votes
2 answers

ResultSetImpl error when implementing HIkariCP

I am trying to implement the HikariCP in my program. I have a main class: public class ServerMain { final static int nPort = 8888; private HikariDataSource DS = null; public static void main(String[] args) throws IOException { new…
user4559332
0
votes
1 answer

How do I know if my HikariCP pool is really exhausted when SQLTransientConnectionException is thrown?

The HikariCP documentation says: connectionTimeout: This property controls the maximum number of milliseconds that a client will wait for a connection from the pool. If this time is exceeded without a connection becoming available, a SQLException…
Gustavo
  • 1,332
  • 2
  • 16
  • 39
0
votes
1 answer

How to configure HikariCP with EclipseLink

I am migrating our application from Play Framework 2.3.x to 2.4.x. In 2.4.x, the Play Framework uses HikariCP as its connection provider. Any suggestions on how to use HikariCP with EclipseLink? On the HikariCP, there is only a configuration for…
Ben
  • 2,314
  • 1
  • 19
  • 36
0
votes
2 answers

How to configure EclipseLink to use HikariCP as its connection pool

I am using EclipseLink as a Persistence Provider for our application using the Play framework and Akka. With play framework 2.3.x, the application ran properly. Now I am migrating to 2.4.x and subsequently will migrate to 2.5.x, but I' getting…
Ben
  • 2,314
  • 1
  • 19
  • 36