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
0 answers

spring-boot 1.5.2+.RELEASE: Use more than one datasource with the same connection string

We have a spring boot application using hikariCP as connection pooler and multiple datasources to handle long jobs processing (basically it uses the same connection string with longer timeouts and a reduced number of connections) Since 1.5.2.RELEASE…
A Hocevar
  • 726
  • 3
  • 17
0
votes
1 answer

unable to remove tomcat jdbc dependency

I am building a spring-boot application using an alternative to tomcat related stuff (jetty instead of tomcat and hikariCP instead of tomcat-jdbc) and want to exclude them from my dependencies written in pom.xml I did that for 2 of the packages as…
comiventor
  • 3,922
  • 5
  • 50
  • 77
0
votes
2 answers

Need to improve performance query a table with millions of rows - SQL Server

This query on an audit trail table starts slowing down once the load increases in performance testing (reads and inserts) and I've done what I can with indexing. With this query and these tables and indexes, what more can I do? CREATE TABLE…
Adam
  • 5,215
  • 5
  • 51
  • 90
0
votes
1 answer

HikariCP Pool makes Logback's insertFromJNDI configuration stop working

I have two Spring MVC applications that share a commons.jar library. This library includes logback logging library (logback 1.2.3 and slf4j 1.7.25) and the logback.xml file. Both wars include this line in their web.xml file:
Mike B
  • 101
  • 2
0
votes
1 answer

Using H2 and HikariCP - Table Not Found

I'm trying to set up a test with HikariCP and H2 along with rxjava-jdbc. My code works fine when connecting to a real database, but when switching to H2, I can't seem to get the table to stick, even though I'm not doing in-memory.…
Eric H
  • 1,323
  • 3
  • 14
  • 29
0
votes
3 answers

Configure two datasource in Spring boot in very clean way

Okay, I've read quite a lot of post around this and read spring boot documentation on this but never really got an answer which is cleaner approach. Here my use case: We have like 100-200 oracle entities and we're using JPARepository interface to…
User5817351
  • 989
  • 2
  • 16
  • 36
0
votes
1 answer

HikariCP is not found when running the jar

In a project, we are using Hibernate with HikariCP and it all works fine in Eclipse. But as soon as I generate a jar file (Maven), hikaricp cannot be found anymore. I have turned this in every possible angle, but I cannot figure out what is…
WarWolfen
  • 241
  • 1
  • 3
  • 11
0
votes
0 answers

How to log available datasources of HikariCP using javaee with no framework

i am trying to log my hikariCP but is failing so bad. its my first time trying to use log4j so i dont know where to put my log4j properties. i wanna log something like idle, waiting and used if possible. Im trying to log it to see whether i have a…
MadHatter
  • 19
  • 1
  • 7
0
votes
1 answer

Hikari pool for H2/Hibernate JPA on Jetty - SQL errors TABLE does not exist

I'm using Hikari for pooling H2 memory connections in a Jetty 9 server for a webapp. Works great, until I go away for a few hours and leave it idle. When I come back all of my database queries tell me the the table does not exist when I reload the…
mikeb
  • 10,578
  • 7
  • 62
  • 120
0
votes
0 answers

Very slow when inserting data into a MySQL 5.7 table using Java (Locks happened)

I recently migrated and upgraded my database from MySQL 5.5 to MySQL 5.7. Everything worked perfectly on the old server before. But now I found a glitch on my Java application that I use (on the old system) for inserting data into a table.…
0
votes
1 answer

Connection pool replacement for already implemented Spring Jdbctemplate project

I am a doing a mid size project with spring jdbc and MsSQL server , project is almost 50% done , now when every request doing lots of inserts and updates specially with those tables which contains lots of columns and large datasets is performing…
Chanky Mallick
  • 569
  • 8
  • 27
0
votes
3 answers

Cloud Foundry Bind services/cups datasource number of connections

I am using hikari with spring boot, local testing I can see 50 active connections. After I deployed to cloud foundry , I am only able to see 10 active connections. spring.datasource.hikari.maximum-pool-size=50 Seems like cloud foundry bind service…
王子1986
  • 3,019
  • 4
  • 31
  • 43
0
votes
0 answers

HeadlessException no X11 DISPLAY variable was set

I am trying to make connection with As400 database and getting below exception that X11 DISPLAY variable was set. In my local environment it is giving the sign-on pop from AS400 class which should not come as i have already specified the…
0
votes
1 answer

Create a bean depending on the property given to the factory bean

I have to create a datasource bean depending on the tenantIdentifier for multi-tenancy. I'm thinking out of the box solution where adding a new tenant is as simple as adding the configuration in context.xml and the tenant properties in the…
Pavanraotk
  • 1,097
  • 4
  • 15
  • 33
0
votes
2 answers

NoClassDefFoundException while trying to use HikariCP

I'm so noob at external stuff to Bukkit programming, so I'm sorry if it's so easy to solve :P I have a problem, and it's that when I try to use HikariCP in my project, it returns in an error (the title one). I'm using it in a BungeeCord plugin. The…
SrLegsini
  • 1
  • 1
  • 2