oracle报错:java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
来源:互联网 发布:shell和python 编辑:程序博客网 时间:2024/06/05 02:21
查看oracle数据库情况,发现300个连接数已全部用光,且连接池中的连接没有被释放掉INITIALPOOLSIZE = 30
#连接池中保留的最大连接数。Default: 15 maxPoolSize
MAXPOOLSIZE = 300
#当连接池中的连接耗尽的时候c3p0一次同时获取的连接数。Default: 3 acquireIncrement
ACQUIREINCREMENT = 10
#每60秒检查所有连接池中的空闲连接。Default: 0
IDLECONNECTIONTESTPERIOD = 60
#连接关闭时默认将所有未提交的操作回滚。Default: false
AUTOCOMMITONCLOSE = true
#定义所有连接测试都执行的测试语句。在使用连接测试的情况下这个一显著提高测试速度
PREFERREDTESTQUERY = select 1 from dual
#因性能消耗大请只在需要的时候使用它。
#如果设为true那么在每个connection提交的时候都将校验其有效性。
#Default fault
TESTCONNECTIONONCHECKOUT = false
#如果设为true那么在取得连接的同时将校验连接的有效性。Default: false
TESTCONNECTIONONCHECKIN = false
#定义在从数据库获取新连接失败后重复尝试的次数。Default: 30
ACQUIRERETRYATTEMPTS = 30
#两次连接中间隔时间,单位毫秒
ACQUIRERETRYDELAY = 1000
#获取连接失败将会引起所有等待连接池来获取连接的线程抛出异常。但是数据源仍有效
#保留,并在下次调用getConnection()的时候继续尝试获取连接。如果设为true,那么在尝试
#获取连接失败后该数据源将申明已断开并永久关闭。Default: false
BREAKAFTERACQUIREFAILURE = true
#最大空闲时间,25000秒内未使用则连接被丢弃。若为0则永不丢弃。Default: 0
MAXIDLETIME = 25000
#c3p0是异步操作的,缓慢的JDBC操作通过帮助进程完成。扩展这些操作可以有效的提升性能
#通过多线程实现多个操作同时被执行。Default: 3
NUMHELPERTHREADS = 6
MAXSTATEMENTS = 0
MAXSTATEMENTSPERCONNECTION = 0
CHECKOUTTIMEOUT = 60000
1、以dba身份登录
sqlplus username/password as sysdba
2、show parameter resource
3、alter system set resource_limit=true;
4、 create profile [profile文件名] limit connect_time unlimited idle_time unlimited;
如:create profile test_profile limit connect_time unlimited idle_time unlimited;
5、
如:alter user comm profile test_profile;
此种方法还未试过,先记下来,周一尝试
-------------------------------------------------
周一经过测试,发现不是此处的问题,严重怀疑为表的联机空间将满导致,由于其他工作,此处未在处理,
在该库中重新建立了一个新的表空间以及用户,重新测试没有该问题出现。
- oracle报错:java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
- java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
- java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
- Caused by: java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
- c3p0 SQLException: An attempt by a client to checkout a Connection has timed out异常
- An attempt by a client to checkout a Connection has timed out.
- 关于 数据库连接 An attempt by a client to checkout a Connection has timed out 问题解决
- c3p0出现 An attempt by a client to checkout a Connection has timed out
- An attempt by a client to checkout a Connection has timed out.问题处理
- An attempt by a client to checkout a Connection has timed out.
- c3p0连接错误 An attempt by a client to checkout a Connection has timed out.
- spring+mybatis出现 An attempt by a client to checkout a Connection has timed out
- c3p0数据库连接池不能取到连接An attempt by a client to checkout a Connection has timed out
- c3p0数据库连接池不能取到连接An attempt by a client to checkout a Connection has timed out
- 【c3p0】 java.sql.SQLException: An attempt by a client to checkout a Connection...
- jqgjava.sql.SQLException: An attempt by a client to checkout a Connection ha
- paip.提升稳定性---c3p0数据库连接池不能取到连接An attempt by a client to checkout a Connection has timed out
- paip.提升稳定性---c3p0数据库连接池不能取到连接An attempt by a client to checkout a Connection has timed out .
- 协同过滤算法:在线推荐系统如何工作?
- Linux Top 命令解析
- JVM调优总结 -Xms -Xmx -Xmn -Xss
- JVM(Java虚拟机)优化大全和案例实战
- Linux时间类型、函数和休眠函数
- oracle报错:java.sql.SQLException: An attempt by a client to checkout a Connection has timed out
- netty4.0之TCP的server与client初探(与3.X版本变化)DEMO
- 关于UDP数据传输中出现的分包问题的一点解释
- droools学习入门
- itpub索引树,都是精华
- 基于netty4的TCP短连接测试
- 执行安装redis报错undefined reference to `__sync_add_and_fetch_4\'
- json-lib 与Jackson性能对比
- 有关NoSQL的一点理论知识