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

PostgresQL stored procedure called from JDBC does not work

I have a postgresql database with some table and a stored procedure which write on this table. Everything goes fine, when I call this stored procedure from psql: I see my records inserted in my table. Although, when I call this stored procedure…
rog
  • 3
  • 2
0
votes
0 answers

HikariCP and Derby

I use the following properties file content: driverClassName=org.apache.derby.jdbc.EmbeddedDriver jdbcUrl=jdbc:derby:D:\\development\\databases\\test;create=true connectionTimeout=3000 and HikariConfig config = new…
coder
  • 1,415
  • 2
  • 12
  • 15
0
votes
1 answer

How to configure and monitor HikariCP with Hibernate and Spring Boot

I have a simple Spring Boot project with Hibernate, I want to know if my configuration class of HikariCP and the application.properties are correct, and how can I check and monitor the connection pools ? My configuration class : @Configuration class…
Dwix
  • 1,139
  • 3
  • 20
  • 45
0
votes
1 answer

hibernate hikaricp datasource

I tried changing the connection pool of my webapp from c3p0 to hikaricp. here is my configuration.
pat3ck029
  • 263
  • 1
  • 7
  • 19
0
votes
1 answer

Sequential test suite error with Scalatest in Play 2.2, Slick 3 and HikariCP pool db

Now I update my application to Play 2.4 and Slick 3. To test Application I use Scalatest and several test suites. The issue in next. First test suite is performed correctly, but the second one crash with next error: Testing started at 6:29…
0
votes
3 answers

Java: Concurency with HikariDataSource Object

I have a class which looks like that: import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.zaxxer.hikari.HikariConfig; import com.zaxxer.hikari.HikariDataSource; public…
stonar96
  • 1,359
  • 2
  • 11
  • 39
0
votes
1 answer

HIkariCP: connection leaks and usage time

I was wondering whether connection leaks and usage time are correlating. A connection leak is identified if a connection is out of the pool for an amount of time over the configured leakDetectionThreshold. Is this amount of time the same as the…
mike
  • 133
  • 1
  • 1
  • 2
0
votes
1 answer

Configuration date_string_format of SQLite in HikariCP

We are migrating C3P0 to HikarCP \o/, everything is going fine except the configuration of a property that we want to override which is date_string_format. Here is a bit of our old C3P0 configuration:
Marouane Gazanayi
  • 5,063
  • 6
  • 39
  • 58
0
votes
1 answer

How to set HikariCP pool name with Play

We have some issues from database connection thus attemp to find a way monitor pool status and performance, but play default configuration seems doesn't offering pool name set up function. slick.dbs.default.driver =…
ans76
  • 1
  • 1
  • 1
0
votes
2 answers

JdbcDataSource x JdbcConnectionPool

I'm trying to understand the purpose and the diference between JdbcDataSource and JdbcConnectionPool. Based in code either JdbcDataSource or JdbcConnectionPool implement javax.sql.DataSource. My mains question is: When should I use one or other? I…
josivan
  • 1,963
  • 1
  • 15
  • 26
0
votes
2 answers

Hikaricp log messages in tomcat 8

I have installed JNDI Hikaricp 2.4.1 oracle pool connection in tomcat 8.0.28. It works well, but I want to see all log level messages from Hikaricp. Now I only see INFO messages. How can I configure this in tomcat. I don't know a lot how tomcat and…
user1151816
  • 187
  • 4
  • 13
0
votes
1 answer

HikariCP: Postgres timestamptz column timezone disappears in resultset of PreparedStatement after 5 queries

my slick mapping in play2.4 wasn't working, and I boiled down the problem to this: If I do a simple select from a table with a timestamp with time zone column, the timezone disappears from the results after a while. The example at the end of this…
Giovanni Caporaletti
  • 5,426
  • 2
  • 26
  • 39
0
votes
1 answer

MySQL MissingResourceException when running .jar from memory HikariCP

I've created an client program which uses Netty in order to download a .jar through a TCP socket and creates a new instance of JarInputStream When I'm initializing the program everything loads up find untill connecting the database when it throws an…
Wesley
  • 855
  • 1
  • 9
  • 23
0
votes
1 answer

What is wrong with this class for getting connection from database pool

I wrote a class to get connections from a database pool (HikariCP). I searched for error and it means that connection is closed. But, I am not able to figure out the problem. I am certain I did something wrong in the code, may be not closing the…
user3275095
  • 1,605
  • 4
  • 24
  • 36
0
votes
0 answers

adding prepare statement before calling getconnection () function from the connection pool

I want to add a prepare statement before calling the getconnection() from my hibernate hikariCP connection pool. the statement is dbms_session.set_identifier("Current User"); I've been trying to do so with spring AOP without any success. Then i…
vovi
  • 3
  • 3