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

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,367
  • 10
  • 48
  • 86
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
  • 636
  • 1
  • 6
  • 22
-1
votes
1 answer

Sending a DM with hikari-lightbulb

i'm really new to hikari and i don't really understand the docs, but how would i send a dm to a user? this idea might not be very smart, but i've got a password generating bot and i want to send a dm to the user with the password once i've generated…
Hobospider132
  • 3
  • 2
-1
votes
2 answers

Try-with-resources - Does it automatically close the connection? Java

I've been working on a SQL utility and I am trying to set the parameters inside a prepared statement in multiple functions. To lessen the code, I have a function that returns a prepared statement where all the params are set. My question is: Does…
user12055552
-1
votes
1 answer

How i can fix a 'max_user_connections' reached problem in MySQL?

I use a deployment platform named Mochahost, and I usually put my war file on the server to deploy my Spring Boot App, like I always do. But recently, I got this error during the deployment : [mysqluser] already has more than 'max_user_connections'…
jozinho22
  • 459
  • 2
  • 7
  • 24
-1
votes
2 answers

How to set the ReadTimeout for JPA connections

How can i set the read timeout (socket#sotimeout) on a jpa connection. Do i have to set javax.persistence.query.timeout or is it spring.datasource.socketTimeout? Any hint how i could test that the value is really set? I'm using jdbc-postgresql with…
sge
  • 391
  • 2
  • 16
-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
  • 51
  • 2
  • 7
-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
  • 2
  • 8
-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
  • 576
  • 1
  • 12
  • 27
-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

Facing Too many connection issue on HIkariCP

I have a Java JDBC application, after 100 queries of Select Jetty server crashed and return below error: ERROR com.zaxxer.hikari.pool.HikariPool - dev-server - Exception during pool initialization. java.sql.SQLNonTransientConnectionException:…
Irfan Nasim
  • 1,952
  • 2
  • 19
  • 29
-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
  • 145
  • 2
  • 20
-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 2 3
…
91
92