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

Add zeroDateTimeBehavior variable to the Datasource without URL in jetty.xml

I'm trying to connect to multiple data sources by a grails application. What I tried worked in a development environment correctly. Initially there was a timestamp error which got resolved with 'zeroDateTimeBehavior=convertToNull' adding to a url.…
user3853055
  • 227
  • 1
  • 3
  • 17
0
votes
1 answer

Does HikariCP support a soft maximumPoolSize?

Is it possible to set HikariCP a maximum pool size as a soft limit? What I mean by that is that I want HikariCP to use max 5 connections. However when a 6th connection should be requested, I want HikariCP to create a 6th connection that will be…
mvieghofer
  • 2,846
  • 4
  • 22
  • 51
0
votes
1 answer

hikaricp get number of busy connection

Like we can get the number of busy connection in c3p0 by using method like dataSource.getNumBusyConnections(), the same way how can we do that in case of hikaricp? Can anyone provide all the related methods between c3p0 and hikaricp? Also what is…
dks551
  • 1,113
  • 1
  • 15
  • 39
0
votes
2 answers

How are JDBC connections implemented?

I have a project in which I used HikariCP for JDBC connection pooling. And HikariCP works just great for my needs. It also logs the stats of the pool like below. 2014-12-03 10:16:08 DEBUG HikariPool:559 - Before cleanup pool stats loginPool…
phoenix
  • 985
  • 3
  • 17
  • 38
0
votes
1 answer

Unable to configure Hikaricp 2.2.5 with Java 6

I have a Spring java web application. I am trying to use Hikaricp 2.2.5 for connection pooling with the following configuration. Maven: com.zaxxer HikariCP-java6 …
phoenix
  • 985
  • 3
  • 17
  • 38
0
votes
1 answer

Behaviour of Hikari setConnectionTimeout

Just looking for an explanation of rationale for this bit of code (PoolUtiltites:293 in version 2.2.4): dataSource.setLoginTimeout((int) TimeUnit.MILLISECONDS.toSeconds(Math.min(1000L, connectionTimeout))); This code and the setConnectionTimeout…
Theo
  • 89
  • 2
  • 11
0
votes
1 answer

Managing MySQL connections using HikariCP and Slick

I'm running a Scala application on this software stack: Mac OS X 10.6.8 Snow Leopard MySQL 5.1.46 Java 1.6.0_65 Scala 2.11.2 ConnectorJ 5.1.33 HikariCP 2.1.0 Slick 2.1.0 I cannot get why open connections to MySQL keep staying open even after…
Max
  • 2,508
  • 3
  • 26
  • 44
0
votes
1 answer

hikaricp HikariConnectionProvider exception

When I trying to start tomcat I get this :"Cannot unwrap to requested type". I disabled hibernate properties but it does not impact for this. What I did wrong? Persistance config from annotation configuration begin here …
user3093030
  • 5
  • 3
0
votes
3 answers

Configuration HikariCP + Spring4 + Hibernate

I want to configure HinkariCP data source with Spring4 Java config. My config looks like: @Configuration @EnableJpaRepositories("com.app.dao.repository") @EnableTransactionManagement public class DataAccessConfig { private static final String…
Ivan Kuzminov
  • 35
  • 1
  • 6
0
votes
2 answers

SQL Server randomly 200x slower than normal for simple query

Sometimes queries that normally take almost no time to run at all suddenly start to take as much as 2 seconds to run. (The query is select count(*) from calendars, which returns the number 10). This only happens when running queries through our…
Matt Sgarlata
  • 1,761
  • 1
  • 16
  • 13
0
votes
1 answer

play framework 2.3 classnotfound using play-hikaricp

I keep getting the following stack trace when I try to configure my Play 2.3 application to use hikaricp java.lang.RuntimeException: java.lang.ClassNotFoundException: "com.mysql.jdbc.jdbc2.optional.MysqlDataSource" …
Nick Pisani
  • 1
0
votes
2 answers

Spring 4 with JPA2: Delay for reconnection

Sorry for my english. Using Spring 4 for the first time, I began to doubt whether it really helps or is just disturbing. When the session expires, this reconnect between 36 and 60 seconds. Using: Spring-boot with Hibernate4 + JPA2 + HikariCP (pool)…
luisdemarchi
  • 1,402
  • 19
  • 29
0
votes
1 answer

HikariConnectionProvider ClassNotFoundException when deploying to JBoss Application Server 7.1

I built a DAL jar library which uses HikariCP as the connection provider. This jar is then included (as a Maven dependency) in a web application. I tested this web application onto a Wildfly 8.0.0 application server and all works as expected: the…
gvdm
  • 3,006
  • 5
  • 35
  • 73
0
votes
1 answer

Determining the right database connection pool size for an application hosted on Cloudfoundry

I am in reference to this excellent article regarding sizing a database connection pool by brettwooldridge author of HikariCP. Amongst other, the article provide a formula for determining the size of one's database connection pool: connections =…
balteo
  • 23,602
  • 63
  • 219
  • 412
0
votes
1 answer

Hibernate 4.3.5 ignores v$session.program configuration property

I previously used hibernate 3.2 and boneCP but I just upgraded to hibernate 4.3.5 and the Hikari connection pool to connect my java application to my oracle database. I set v$session.program to the program name I want and add it to the hibernate…
mvieghofer
  • 2,846
  • 4
  • 22
  • 51
1 2 3
…
91 92