HikariCP – connection is not available

I managed to fix it finally. The problem is not related to HikariCP. The problem persisted because of some complex methods in REST controllers executing multiple changes in DB through JPA repositories. For some reasons calls to these interfaces resulted in a growing number of “freezed” active connections, exhausting the pool. Either annotating these methods … Read more

How do I configure HikariCP in my Spring Boot app in my application.properties files?

@Configuration @ConfigurationProperties(prefix = “params.datasource”) public class JpaConfig extends HikariConfig { @Bean public DataSource dataSource() throws SQLException { return new HikariDataSource(this); } } application.yml params: datasource: driverClassName: com.mysql.jdbc.Driver jdbcUrl: jdbc:mysql://localhost:3306/myDb username: login password: password maximumPoolSize: 5 UPDATED! Since version Spring Boot 1.3.0 : Just add HikariCP to dependencies Configure application.yml application.yml spring: datasource: type: com.zaxxer.hikari.HikariDataSource url: … Read more

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)