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

Using a connection per query via Slick and Hikari

I have a web application that runs some database queries to fulfil some request. I am using aka http along with Slick(with HikariCP). I have used for comprehension to make sure these queries run in parallel. However, when I run it I see that only 1…
user3294786
  • 177
  • 2
  • 10
0
votes
1 answer

Will HikariCP auto Shut Poll when Program Exit

Should I shut down the data source mannully when my program exits? If it is, then what is the best practice to close the source, for example, if the kill cmd is issued?
xuanzhui
  • 1,300
  • 4
  • 12
  • 30
0
votes
1 answer

Hikari CP Connection Error with Concurrent requests

We have a location service application, that provides location related info to our other applications from the MySQL Database. Due to some reason, the location service fails to connect to the MySQL database when receiving multiple requests.We…
user5096772
0
votes
0 answers

HikariCP connection broken/unavailable woes

I am unable to understand the reason behind intermittent HikariCP Connection is not available. From the logs, It doesn't look like a connection leak issue. A bigger problem is I am unable to predictably reproduce the error. Following is a sample log…
comiventor
  • 3,922
  • 5
  • 50
  • 77
0
votes
0 answers

Connection Leak with HikariCP + MySQL + Hibernate

I'm having a lot of troubles with a Java (tomcat) application using MySQL (Hibernate) and HikariCP as connection pool. I'm having troubles with connection leak, but I'm using Spring's @Transactional annotation in service's and DAO's layers, so I…
jNewbie
  • 334
  • 1
  • 15
0
votes
0 answers

Configure HikariCP for Eclipselink JPA

my recent a few projects are built on eclipselink/jpa/jsf structure. I wanted to use HikariCP as data source. So far I searched and found out that all examples/tutorials about HikariCP is based on Spring and Hibarnate. Is there any way to use…
Ali Yucel Akgul
  • 1,101
  • 8
  • 27
  • 53
0
votes
1 answer

Why my HikariCP springboot throw this exception?

this is my sapplication.yml spring: datasource: type: com.zaxxer.hikari.HikariDataSource primary: serverName: localhost portNumber: 3306 databaseName: ccoee username: root password: root dataSourceClassName:…
筱白to
  • 1
  • 1
0
votes
1 answer

How to add two databases in hikari properties?

I am using HikariCP and jdbc template to query from one database.The method i use is like below: My Hikari CP config…
joker21
  • 339
  • 2
  • 4
  • 14
0
votes
1 answer

SQLException: ResultSet closed

I'm trying to execute method which should create a new object with fields from database, and everytime i run this code im getting SQLException: ResultSet closed. public DatabasedClient getDatabaseClient(int clientDatabaseid){ …
xdev
  • 3
  • 4
0
votes
0 answers

Hikari CP JDBCConnectionException: Could not open connection

Environment HikariCP version : 2.4.2 JDK version : 1.7.0_141 Database : MySQL MySQL Driver version : 5.6.27 Hibernate : 4.3.4 We have successfully migrated Hikari from C3PO and everything was running smooth…
pinkb
  • 543
  • 2
  • 6
  • 15
0
votes
2 answers

Apache Tomcat 8 + MySQL performance issue

I have a Java (Tomcat) application that uses with MySQL (with Hibernate) as database. It's a simple Java JSF application and only three users use the system simultaneously. (There's two kind of big tables, with 20k lines - usually is there when it…
jNewbie
  • 334
  • 1
  • 15
0
votes
0 answers

what parameters to change on oracle database server to meet high (1000 requests/sec) load

I have a server running a stored procedure which returns the list of places nearest to a provided lat,long stored in oracle spatial. Currently below are the specs: on amazon ec2 (single vm) we have oracle 11g R2 enterprise with 400 connections, 500…
Ayub
  • 599
  • 3
  • 10
  • 24
0
votes
1 answer

Spring - How to get subset of properties file without enumerating all required properties

I am loading my properties file as following: @Configuration @PropertySource("classpath:app.properties") class MyApp { @Bean public PropertySourcesPlaceholderConfigurer PropertySourcesPlaceholderConfigurer() { return new…
Jessy56
  • 63
  • 1
  • 10
0
votes
1 answer

Non-atomic behaviour Eclipselink- DB transactions half committed

We are seeing strange behaviour in our DB transactions- they are not behaving atomically. We use MySQL 5.6.25 Innodb, Eclipselink 2.5.2 as JPA provider and HikariCP 2.6.2 as the connection pool. This problem surfaces when Eclipselink fails to…
user20507
  • 93
  • 1
  • 1
  • 6
0
votes
1 answer

Apache Karaf - How to define XA data source for MariaDB?

We're trying to setup MariaDB data source with HikariCP as conn. pool in Apache Karaf 4.1.2. These are the features installed: karaf@root()> feature:install jndi transaction pax-jdbc-pool-hikaricp pax-jdbc-mariadb jasypt-encryption If we use only…
emrekgn
  • 624
  • 9
  • 25
1 2 3
…
91 92