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

Setting HikariCP configuration by passing an XML file

Am currently using BoneCP in my application and we add our configurations to 'https://github.com/wwadge/bonecp/blob/master/bonecp/src/main/resources/bonecp-default-config.xml' XML file. This was being done to take advantage of comments in the XML,…
Anuj Balan
  • 7,629
  • 23
  • 58
  • 92
0
votes
1 answer

how to utilize HikariCP with Hibernate?

When I used Hibernate itself, I could've done something like Main.getSession().get(User.class, 1); where getSession() would call openSession() from the session factory. but how can I do the same with HikariDataSource? Wiki mentioned something about…
user1865027
  • 3,505
  • 6
  • 33
  • 71
0
votes
1 answer

HikariCP Address Specification and Documentation

So, after searching Google and Github for answers, I'm left confounded as to how most people know how to use HikariCP. I can't seem to find any straight up documentation on HikariCP. My question is: how do I specify the host address without a JDBC…
Andavin
  • 41
  • 6
0
votes
0 answers

Failed to initialize pool: DataSource router not initialized

I used Hikari and AbstractRoutingDataSource to have two datasources, but there are some issues when context started. Here are configrations:
Raw
  • 615
  • 1
  • 7
  • 22
0
votes
1 answer

issue on running Hikari connection pooling in server

I am trying to implement Hikari connection pooling with JAVA 7, spring and Hibernate 5 project. I am getting the below error message continuously on running the code. Added following code for Hikari set up in addition to already running Spring with…
Prithivi Raj
  • 2,658
  • 1
  • 19
  • 34
0
votes
0 answers

Setup HikariCP spring + hibernate java 7

I'm trying to use HikariCP with Spring on Java 7 Spring conifg:
Dekso
  • 541
  • 4
  • 23
0
votes
0 answers

org.springframework.jdbc.support.KeyHolder cannot be resolved. It is indirectly referenced from required .class files

I am using Hikari CP anf JDBC Template to insert incoming request parameters in a Controller to database. So I Do the following: @RestController public class HomeController { @Autowired private JdbcTemplate…
Ricky
  • 2,662
  • 5
  • 25
  • 57
0
votes
2 answers

Prepared statement execute query error (com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException)

I have written a simple method to get a string out of the database: public String getUserString(int id, String table, String column) { String output = null; try { String sql = "SELECT ? FROM ? WHERE id=?;"; …
0
votes
1 answer

HikariCP is loosing connection to MySQL after being idle for a while

I'm using HIkariCP, Hibernate and MySQL. The problem is: When application starts, everything works fine. But when I leave it idle for some time and then get back and try to get connection from Hikari, it throws exception: Caused by:…
Mariusz.v7
  • 2,322
  • 2
  • 16
  • 24
0
votes
1 answer

Send email when HikariCP warns on a leak

I'm using HikariCP with Tomact8.5 and Oracle. I want to send email everytime HikariCP warns on leak. HikariCP code: import org.slf4j.Logger; LOGGER.warn("{} - leakDetectionThreshold is less than 2000ms or more than maxLifetime, disabling it.",…
Ori Marko
  • 56,308
  • 23
  • 131
  • 233
0
votes
2 answers

Spring boot JPA application NOT working with HikariCP configuration

We have configured our spring boot(v1.5.1)-jpa application to point to HikariCP but still due to some weird reason the application is still pointing to tomcat-jdbc pool, the default used by spring-boot instead of Hikari-CP. I have mentioned the…
Gururaj Nayak
  • 636
  • 1
  • 9
  • 18
0
votes
1 answer

How to use HikariCP with WebSphere Liberty

we are using oracle database, this is how we configured JNDI against oracle on liberty profile, I want to use hikarui-cp instead if javax.sql.ConnectionPoolDataSource.
Praneeth
  • 559
  • 9
  • 19
0
votes
2 answers

SQLTransientConnectionException after upgrading MariaDB connector

I've upgraded the "org.mariadb.jdbc" % "mariadb-java-client" connector from 1.5.9 to 1.6.0 and I'd started to fail while connecting to the DB due to timeout exceptions. I'm using it with HikariCP 2.5.1 and Slick 3.2.0. If I rollback the change again…
JavierCane
  • 2,324
  • 2
  • 22
  • 19
0
votes
2 answers

Springboot with HikariDataSource

I'm trying to use Spring Boot with HikariDataSource, but I'm getting the error. Broken pipe how is it better to configure or is it better to use c3p0? I'm using this…
Fabio Ebner
  • 2,613
  • 16
  • 50
  • 77
0
votes
3 answers

Play Framework: DB Connection Pool Shut Down

I have a Play Application running using HikariCP jdbc connection pool. The application will run fine for a while but after a short period of time it will shut down the connection pool meaning I can no longer use the application. SBT build: name :=…
James Murphy
  • 800
  • 1
  • 15
  • 29