hibernate中连续插入数据出现的SQLTimeoutException

最新推荐文章于 2023-11-12 00:01:23 发布

「已注销」

最新推荐文章于 2023-11-12 00:01:23 发布

阅读量1.4k

点赞数

文章标签： hibernate 异常

本文链接：https://blog.csdn.net/Nullfwd/article/details/53351962

版权

在使用Hibernate进行连续数据插入时遇到了java.sql.SQLTimeoutException，具体错误为'Timeout after 30001ms of waiting for a connection.'。问题源于HikariCP连接池无法及时获取数据库连接。解决方案可能包括增加连接池大小、优化数据库配置或检查并发操作。

摘要由CSDN通过智能技术生成

java.sql.SQLTimeoutException: Timeout after 30001ms of waiting for a connection.
	com.zaxxer.hikari.pool.BaseHikariPool.getConnection(BaseHikariPool.java:233)
	com.zaxxer.hikari.pool.BaseHikariPool.getConnection(BaseHikariPool.java:183)
	com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:110)
	org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141)
	org.hibernate.internal.AbstractSessionImpl$NonContextualJdbcConnectionAccess.obtainConnection(AbstractSessionImpl.java:301)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.obtainConnection(LogicalConnectionImpl.java:214)
	org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.getConnection(LogicalConnectionImpl.java:157)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:56)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:96)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:183)
	org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:89)
	org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.buildBatchStatement(AbstractBatchImpl.java:150)
	org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.getBatchStatement(AbstractBatchImpl.java:139)
	org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3057)
	org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)
	org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)
	org