麦嘉琪:c3p0连接错误 An attempt by a client to checkout a...

来源：百度文库 编辑：九乡新闻网 时间：2024/04/30 17:55:04
c3p0作为连接池，报：java.sql.SQLException: An attempt by a client to checkout a Connection has timed out.
网上查了很久，有人说是checkoutTimeout太短的原因，（Default: 0）于是由原来的1000改为2000,问题还是未解决。
然后找了份没有问题的配置作了些对比，发现我的maxPoolSize＝100显得有些大，于是改为默认的15.再测试，居然没有问题了。后来再试了大一点的60,也没有问题。
下面是我的配置：
Xml代码  
  2.         class="com.mchange.v2.c3p0.ComboPooledDataSource"  
  3.         destroy-method="close">  
  4.           
  5.         
  6.             value="jdbc:mysql://localhost:3306/gjp" />  
  7.           
  8.           
  9.           
  10.           
  11.           
  12.           
  13.           
  14.           
  15.           
  16.           
  17.           
  18.           
  19.           
  20.           
  21.           
  22.           
  23.           
  24.           
  25.           
  26.           
  27.           
  28.           
  29.       
c3p0连接错误 An attempt by a client to checkout a... Client-side Locking, a confuse way fail to lock To Be an Individual Or to Be in a Body? How To Make a Youtube Video Into an Animated GIF How To Export Data from a DLL or an Application Beijing to become a globalized metropolis by ... a,an,the navicat连接oracle的错误：ora-12737：instant client l... "How to Read a Book" by Mortimer J. Adler & C... SVN错误：Attempted to lock an already-locked dir... To name a shoe To find a girlfriend A-Z to woman A blow to Sino a letter to Franktian 定冠词the和不定冠词a/an a与an的用法区别 a psalm of life words to live by（背诵经典） 宽带连接错误代码大全A How to complicate a deal How to Write a Rebuttal Whats time to a pig? ASEAN rises to a challenge To build a better nation