org.hibernate.exception.JDBCConnectionException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

This might be cause due to an overload in your database accesses. Try to implement a queue or using an Executor to access the database server.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • GitHub comment 729#249481722
    via GitHub by njovy
    ,
  • GitHub comment 729#250366236
    via GitHub by njovy
    ,
  • GitHub comment 418#141114687
    via GitHub by Shredder121
    ,
  • HikariCP - connection is not available
    via Stack Overflow by dfche
    ,
    • org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC Connection at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:87)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:109)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:47)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:146)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:148)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1927)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1874)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.doQuery(Loader.java:919)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:336)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.doList(Loader.java:2610)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.doList(Loader.java:2593)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2422)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.Loader.list(Loader.java:2417)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:109)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1787)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:363)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.internal.CriteriaImpl.uniqueResult(CriteriaImpl.java:385)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at modules.rpc.handler.AuthorizedRancamImpl.lambda$getStatus$3(AuthorizedRancamImpl.java:258)[rancam-api.rancam-api-0.1.0.jar:0.1.0] at utils.JPA.transaction(JPA.java:39)[rancam-api.rancam-api-0.1.0.jar:0.1.0] at utils.JPA.transaction(JPA.java:82)[rancam-api.rancam-api-0.1.0.jar:0.1.0] at modules.rpc.handler.AuthorizedRancamImpl.getStatus(AuthorizedRancamImpl.java:250)[rancam-api.rancam-api-0.1.0.jar:0.1.0] at com.rancam.models.rpc.AuthorizedRancamGrpc$MethodHandlers.invoke(AuthorizedRancamGrpc.java:2249)[rancam-api.rancam-api-0.1.0.jar:0.1.0] at io.grpc.stub.ServerCalls$1$1.onHalfClose(ServerCalls.java:150)[io.grpc.grpc-stub-1.0.0.jar:1.0.0] at io.grpc.PartialForwardingServerCallListener.onHalfClose(PartialForwardingServerCallListener.java:48)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.ForwardingServerCallListener.onHalfClose(ForwardingServerCallListener.java:38)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.ForwardingServerCallListener$SimpleForwardingServerCallListener.onHalfClose(ForwardingServerCallListener.java:55)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.Contexts$ContextualizedServerCallListener.onHalfClose(Contexts.java:102)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.ServerCallImpl$ServerStreamListenerImpl.halfClosed(ServerCallImpl.java:260)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.ServerImpl$JumpToApplicationThreadServerStreamListener$2.runInContext(ServerImpl.java:503)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.ContextRunnable.run(ContextRunnable.java:52)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at io.grpc.internal.SerializingExecutor$TaskRunner.run(SerializingExecutor.java:154)[io.grpc.grpc-core-1.0.0.jar:1.0.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_74] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_74] at java.lang.Thread.run(Thread.java:745)[na:1.8.0_74] Caused by: java.sql.SQLTransientConnectionException: db-pool - Connection is not available, request timed out after 30602ms. at com.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:555)[com.zaxxer.HikariCP-2.4.7.jar:na] at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:188)[com.zaxxer.HikariCP-2.4.7.jar:na] at com.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:147)[com.zaxxer.HikariCP-2.4.7.jar:na] at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:83)[com.zaxxer.HikariCP-2.4.7.jar:na] at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:386)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:84)[org.hibernate.hibernate-core-5.1.0.Final.jar:5.1.0.Final] ... 35 more

    Users with the same issue

    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    13 more bugmates