java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.

最新推荐文章于 2022-06-30 15:38:37 发布
最新推荐文章于 2022-06-30 15:38:37 发布
阅读量2.6k 收藏
点赞数 2
分类专栏： bug积累
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43078114/article/details/103034960
版权
一：错误日志
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224)
	at com.sun.proxy.$Proxy28.prepareStatement(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
	at com.sun.proxy.$Proxy29.prepareStatement(Unknown Source)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:295)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:1)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)
	at com.shanda.sc.dao.impl.UserInfoDaoImpl.findUserInfoList(UserInfoDaoImpl.java:138)
	at com.shanda.sc.service.impl.UserInfoServiceImpl.findUserInfoList(UserInfoServiceImpl.java:455)
	at com.shanda.sc.crontab.UserMessageNoticeServiceImpl.invalidAddrMessageTask(UserMessageNoticeServiceImpl.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64)
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
	at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@5516f283 -- timeout at awaitAvailable()
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 39 more
11-12 17:46:28,227:WARN Timer-1 com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@37a331bc -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
11-12 17:46:28,229:WARN Timer-1 com.mchange.v2.async.ThreadPoolAsynchronousRunner - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@37a331bc -- APPARENT DEADLOCK!!! Complete Status: 
	Managed Threads: 3
	Active Threads: 3
	Active Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@56592365 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@49eb1d9f (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@2e01a354 (com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1)
	Pending Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@18763c4c
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@72b762c
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@163d94b3
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@35058e23
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@1c384093
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@40fedf2e
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask@3a9c538e
Pool thread stack traces:
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2,5,main]
		java.lang.Thread.sleep(Native Method)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0,5,main]
		java.lang.Thread.sleep(Native Method)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)
	Thread[com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1,5,main]
		java.lang.Thread.sleep(Native Method)
		com.mchange.v2.resourcepool.BasicResourcePool$AcquireTask.run(BasicResourcePool.java:1805)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:547)


11-12 17:46:28,342:WARN myscheduler-8 org.springframework.jdbc.support.SQLErrorCodesFactory - Error while extracting database product name - falling back to empty error codes
org.springframework.jdbc.support.MetaDataAccessException: Error while extracting DatabaseMetaData; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:296)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:320)
	at org.springframework.jdbc.support.SQLErrorCodesFactory.getErrorCodes(SQLErrorCodesFactory.java:214)
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.setDataSource(SQLErrorCodeSQLExceptionTranslator.java:141)
	at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.<init>(SQLErrorCodeSQLExceptionTranslator.java:104)
	at org.springframework.jdbc.support.JdbcAccessor.getExceptionTranslator(JdbcAccessor.java:99)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)
	at com.shanda.sc.dao.impl.UserInfoDaoImpl.findUserInfoList(UserInfoDaoImpl.java:138)
	at com.shanda.sc.service.impl.UserInfoServiceImpl.findUserInfoList(UserInfoServiceImpl.java:455)
	at com.shanda.sc.crontab.UserMessageNoticeServiceImpl.invalidAddrMessageTask(UserMessageNoticeServiceImpl.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64)
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
	at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224)
	at com.sun.proxy.$Proxy28.getMetaData(Unknown Source)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:285)
	... 24 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@5516f283 -- timeout at awaitAvailable()
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 29 more
11-12 17:46:28,345:ERROR myscheduler-8 org.springframework.scheduling.support.TaskUtils$LoggingErrorHandler - Unexpected error occurred in scheduled task.
org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [0];   
--- The error occurred in sqlmap/UserInfo-SqlMap.xml.  
--- The error occurred while executing query.  
--- Check the         select  t.user_id,t.user_name,t.passwd,t.account_type,t.user_type,t.parent_id,t.email_volumn,t.reputation,t.balance,t.billing_plan_id,t.flow_Billing_plan_id,t.sms_billing_plan_id, t.attachment_billing_plan_id,t.email_grade_billing_plan_id, t.type_time,t.first_deposit_time,t.gmt_created,t.pre_account_type,t.alert_balance,mark_status,t.is_verify,t.email,t.phone,t.first_send_time,t.sms_first_send_time,t.exmail,t.rest_num,t.flow_num      from user_info t where t.user_id is not null                  and       t.account_type IN       (                  ?      ,                  ?      )           and       t.user_type IN       (                  ?      ,                  ?      )                                                                                                                         .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/UserInfo-SqlMap.xml.  
--- The error occurred while executing query.  
--- Check the         select  t.user_id,t.user_name,t.passwd,t.account_type,t.user_type,t.parent_id,t.email_volumn,t.reputation,t.balance,t.billing_plan_id,t.flow_Billing_plan_id,t.sms_billing_plan_id, t.attachment_billing_plan_id,t.email_grade_billing_plan_id, t.type_time,t.first_deposit_time,t.gmt_created,t.pre_account_type,t.alert_balance,mark_status,t.is_verify,t.email,t.phone,t.first_send_time,t.sms_first_send_time,t.exmail,t.rest_num,t.flow_num      from user_info t where t.user_id is not null                  and       t.account_type IN       (                  ?      ,                  ?      )           and       t.user_type IN       (                  ?      ,                  ?      )                                                                                                                         .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:203)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:293)
	at com.shanda.sc.dao.impl.UserInfoDaoImpl.findUserInfoList(UserInfoDaoImpl.java:138)
	at com.shanda.sc.service.impl.UserInfoServiceImpl.findUserInfoList(UserInfoServiceImpl.java:455)
	at com.shanda.sc.crontab.UserMessageNoticeServiceImpl.invalidAddrMessageTask(UserMessageNoticeServiceImpl.java:141)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:64)
	at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)
	at org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.ibatis.common.jdbc.exception.NestedSQLException:   
--- The error occurred in sqlmap/UserInfo-SqlMap.xml.  
--- The error occurred while executing query.  
--- Check the         select  t.user_id,t.user_name,t.passwd,t.account_type,t.user_type,t.parent_id,t.email_volumn,t.reputation,t.balance,t.billing_plan_id,t.flow_Billing_plan_id,t.sms_billing_plan_id, t.attachment_billing_plan_id,t.email_grade_billing_plan_id, t.type_time,t.first_deposit_time,t.gmt_created,t.pre_account_type,t.alert_balance,mark_status,t.is_verify,t.email,t.phone,t.first_send_time,t.sms_first_send_time,t.exmail,t.rest_num,t.flow_num      from user_info t where t.user_id is not null                  and       t.account_type IN       (                  ?      ,                  ?      )           and       t.user_type IN       (                  ?      ,                  ?      )                                                                                                                         .  
--- Check the SQL Statement (preparation failed).  
--- Cause: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:201)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryForList(MappedStatement.java:139)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:567)
	at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:541)
	at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:295)
	at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:1)
	at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:200)
	... 18 more
Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:527)
	at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy$TransactionAwareInvocationHandler.invoke(TransactionAwareDataSourceProxy.java:224)
	at com.sun.proxy.$Proxy28.prepareStatement(Unknown Source)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.ibatis.common.jdbc.logging.ConnectionLogProxy.invoke(ConnectionLogProxy.java:53)
	at com.sun.proxy.$Proxy29.prepareStatement(Unknown Source)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.prepareStatement(SqlExecutor.java:497)
	at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:175)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.sqlExecuteQuery(MappedStatement.java:221)
	at com.ibatis.sqlmap.engine.mapping.statement.MappedStatement.executeQueryWithCallback(MappedStatement.java:189)
	... 25 more
Caused by: com.mchange.v2.resourcepool.TimeoutException: A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourcePool@5516f283 -- timeout at awaitAvailable()
	at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1317)
	at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
	at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	... 39 more
二.分析

错误报了一大堆，其实只用看第一行就可以了。
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
连接超时，错误信息就是数据库没有连上

三.解决

查看数据库配置文件，用户名和密码在数据库客户端连接测试
我的情况是配置文件用户名后多了一个空格，配置文件的key后面可以有空格，值后面一定不能有空格。是否有空格检查是把鼠标放上去才能发现。

在这里插入图片描述

deelless
关注
  • 2
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
java.sql.SQLException: 内部错误: Unable to construct a Datum from the specified input
01-21
Q: I am working with Oracle database 8.1.7 and I have written a JAVA code to update the table which contains one BLOB field . I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
java.sql.SQLException: 结果集已耗尽
08-02
NULL 博文链接：https://listen-raining.iteye.com/blog/1962065
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK
09-29
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
java.sql.SQLException: null,  message from server: “Host ‘%’ is not allowed to connect to
12-14
在阿里云 SUSE linux配置完mysql后，服务器端本身是可以访问数据库的如图： 但是在客户端不可以，服务启动时报错： java.sql.SQLException: null,  message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错： 解决方法： 1，登陆服务器 mysql> use mysql; //用mysql database 2，查询user表如下： 3，mysql> update user set host=’%’ where u
c3p0-config.xml文件
陈福国的博客
07-08 969
<c3p0-config> <!-- 使用默认的配置读取连接池对象--> <default-config> <!-- 连接参数 --> <property name="driverClass">com.mysql.jdbc.Driver</property> &...
java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
dengweitao的博客
06-30 873
学习java踩的坑
java.sql.SQLException: An attempt by a client to checkout a Connection has timed问题解决方法
这货净瞎扯的博客
06-10 1689
问题描述： 使用c3p0连接池创建Connection对象，然后进行测试时出现java.sql.SQLException: An attempt by a client to checkout a Connection has timed的异常抛出。 解决过程： 查阅资料，上网查找解决方案看到有很多说法： 1）有人说是c3p0配置文件中的<property name=“checkoutTimeout”>30000</property>配置项的时间太短； 2）还有人说是数据库连接池中最
MySQL存储表情时报错：java.sql.SQLException: Incorrect string value:‘\xF0\x9F\x92\xA9\x0D\x0A…’的解决方法
12-16
前言 本文主要介绍了关于MySQL存储表情报错：java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\xA9\x0D\x0A…’的相关解决方法，分享出供大家参考学习，下面话不多说了，来一起看看详细的介绍： 本项目是基于Spring MVC + MySQL + Druid DataSource。在往数据库插入表情Emoji字符时报错： java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\xA9\x0D\x0A…’ 普通字符最多占用3个字节，使用utf8足够
An attempt by a client to checkout a Connection has timed out
weixin_34214500的博客
11-03 3136
2019独角兽企业重金招聘Python工程师标准>>> ...
A client timed out while waiting to acquire a resource from com.mchange.v2.resourcepool.BasicResourc
qq_32473523的博客
03-25 2926
错误信息如下： Exception in thread "main" java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118) at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:7...
log报错： Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed o...
weixin_33755554的博客
10-16 269
报错： 解决方式： 1、登录数据库查看错误原因 结果发现账号无法正常登录出现账号被锁定的错误。 2、如何账号解锁？ 用sys系统管理员账号登录数据库 SQL> alter user 用户名 account unlock; (解锁) SQL>alteruserusernameidentifiedbypassword;(重置用户密码：其中username为用...
oracle报错：java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
网络
09-18 7297
问题描述：服务器在跑压力测试，测试的并发大约是3200，（每次数据上传需要两次数据库操作，更新1条记录，批处理插入10条记录，可认为并发为更新3200，插入32000），每10s执行一次，大约跑了两天（周五19点左右到周末凌晨46分出现问题）数据库连接出现异常：java.sql.SQLException: An attempt by a client to checkout a Connectio
Exception in thread "main" java.sql.SQLException: An attempt by a client to checkout a Connection ha
weixin_43656416的博客
03-05 1032
Exception in thread “main” java.sql.SQLException: An attempt by a client to checkout a Connection has timed out. 我的c3p0配置文件是跟着视频配置的，可能电脑当时开了太多东西跑起来有点慢所以报错。 <?xml version="1.0" encoding="UTF-8"?>...
提示超时 java.sql.SQLException: An attempt by a client to checkout a Connection has timed ......
qq_34204490的博客
07-23 945
问题描述： 最近在调试程序的时候出现java.sql.SQLException: An attempt by a client to checkout a Connection has timed ......异常，出现该异常的情况是因为我要上传稍微比较大的数据。当数据量较小的时候该异常则不存在。起初以为是数据较大影响的，后来发现是因为我的程序中有一次需要切换数据源进行短暂的查询，...
关于c3p0报错：An attempt by a client to checkout a Connection has timed out最直接的解决方法
weixin_43430074的博客
08-26 1297
八月 26, 2019 8:19:43 上午 com.mchange.v2.log.MLog <clinit> 信息: MLog clients using java 1.4+ standard logging. 八月 26, 2019 8:19:44 上午 com.mchange.v2.c3p0.C3P0Registry banner 信息: Initializing c3p0-0....
Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
最新发布
09-21
这个错误是由于在尝试获取JDBC连接时发生了SQLException，并且这个异常表示客户端尝试检出连接超时。这可能是由于数据库连接池耗尽导致的。常见的解决方法有以下几种： 1. 检查数据库连接池的配置，确保连接池的大小足够满足并发请求的需求。 2. 检查数据库连接池的最大空闲时间和最大连接数等参数的设置，确保参数的合理性。 3. 检查数据库服务器的负载情况，如果负载较高，可能需要增加数据库服务器的处理能力。 4. 检查数据库连接是否正确关闭，确保每次使用完连接后及时释放连接资源。

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值