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.

1096 questions
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
  • 20,469
  • 52
  • 196
  • 362
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,616
  • 4
  • 19
  • 49
0
votes
1 answer

jhipster om.zaxxer.hikari.proxy.ConnectionProxy warnings

There seems to be some timeout issue going on here, the jhipster gui works fine and the database gets updated, but these warnings are cluttering up the logs. Hibernate: insert into T_PERSISTENT_TOKEN (ip_address, token_date, token_value, user_login,…
SteveL
  • 71
  • 1
  • 5
0
votes
1 answer

HikariCp lots of database connections

I recently switched my Spring RESTful API data source from DriverManagerDataSource to HikariCp, but my database connections went from 20 connections to 600 connections. Is this suppose to happen? My settings are as follows:
Hank
  • 3,157
  • 7
  • 43
  • 82
0
votes
0 answers

HikariCP freezes on addConnection()

I am using Hikari connection pool and i notice that HikariCP freezes. I took the thread dump and realize that it freezes on addConnection() method. Here is my stack trace of the thread where HikariPool is being intiliazed "main" prio=10…
snegi
  • 606
  • 6
  • 20
-1
votes
1 answer

How does changing the password of the connected database affect the application while operating the spring boot application?

I would like to know if changing the password of the DB associated with the Spring boot application affects the existing connections. If Hikari tries to connect by reading the properties at regular intervals when managing the connection, I think…
dudu
  • 3
  • 1
-1
votes
1 answer

connection leakage with hikari CP

I have jdbs template for sql for sql statements, and use hikari connection pool, after after several calls i took exception, i used try-with-resources, where is my mistake?(Servlet Container -Tomcat) public class SimpleJdbcTemplate { private…
handsome16
  • 1
  • 1
  • 1
-1
votes
1 answer

setting connectionTimedOut to 1 sec is throwing Socket Timed Out error

I am working on a web application which runs in pcf environment and it has approximately 100 users. I am using Hikari CP library to manage databae connections and customized connectionTimedout property by setting it to 1 sec in the application code.…
Mohanrao Kolisetti
  • 19
  • 1
  • 7
-1
votes
2 answers

java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; Mysql

I am struggling with HikariCP + with Direct SQL query execution. I am getting below error for creating the table. If I copy SQL query and execute in MYSQL COMMAND it works but not from java. Error: java.sql.SQLSyntaxErrorException: You have an…
Slok
  • 490
  • 1
  • 6
  • 21
-1
votes
1 answer

How to use hikaricp in Java application

Please could anyone guide me on how I can switch to HikariCP connection Pooling Framework in my Java/Servlet application? I am currently using c3p0 but I am having performance issues with it. I have seen a couple of examples as regards using…
Ernie
  • 1
  • 1
-1
votes
1 answer

How to close current connection at hikariCP pool?

I need your help. I use hikariCP for pool connection and i get someone throuble when i create a query to DB. Connection is established and at DB occur process but response timeline is long about two hours and i want close connection manually. I set…
Porty
  • 19
  • 6
-1
votes
1 answer

is HikariCP be useful for MongoDB?

i am trying to use HikariCP for mongodb to get best for db connections. but HikariCP doesn't have driver for mongodb. Let me know is that true? is there any possible way to integrate HikariCP with mongodb?
User12377777
  • 135
  • 17
-1
votes
1 answer

Properties file on HikariCP

I tried unsuccessfully configure hikaricp and I don't see error in the code please help. public class DatabaseManager { private DatabaseClient[] databaseClients; private HikariDataSource hikariDataSource; public DatabaseManager(String…
KrozT
  • 99
  • 1
  • 2
-1
votes
1 answer

HikariCP connection error

Im trying to use HikariCP with a mariaDB database but i getting the next error when im trying to initialize. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server. at…
Alberto
  • 23
  • 5
-1
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,511
  • 14
  • 12
1 2 3
…
73
74