请问下c3p0的connection为什么每次都是新的呢？

c3p0connection

解决方案 »

  1.   

    最大连接数是maxpoolsize吧？我现在设置为1了，但是打印出来还是全部不一样。12:52:41,383  INFO DBManager:33 - Max pool size: 1
    12:52:41,384  INFO DBManager:34 - Min pool size: 1
    12:52:41,788  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@25e0dee5
    12:52:41,804  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@44fb6e3e
    12:52:41,814  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@5b2ebb84
    12:52:41,816  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@5e4f1ec
    12:52:41,825  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6cf143b4
    12:52:41,827  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@194e65cf
    12:52:41,832  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@21428e24
    12:52:41,834  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@7563cf5d
    12:52:41,835  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@7342054
    12:52:41,838  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@22e2f0e2
    12:52:41,839  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@157bd8d0
    12:52:41,841  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@183ff528
    12:52:41,843  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@75be5b6
    12:52:41,844  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@2d0e39e6
    12:52:41,845  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@617ab612
    12:52:41,846  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@346e2756
    12:52:41,848  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@1c32e0ec
    12:52:41,849  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@52a41a80
    12:52:41,850  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@2173b35c
    12:52:41,852  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@321bc965
    12:52:41,853  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6903b425
    12:52:41,854  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@2d656f92
    12:52:41,856  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@13fc36d7
    12:52:41,857  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@8102ff4
    12:52:41,858  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@747c75e6
    12:52:41,859  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@7d741f2d
    12:52:41,861  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@64bb0423
    12:52:41,862  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@3e643af4
    12:52:41,864  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4c240de4
    12:52:41,865  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@8e74400
    12:52:41,867  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@50e4c821
    12:52:41,868  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@20772fd3
    12:52:41,869  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@26b90a40
    12:52:41,871  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@327e0875
    12:52:41,872  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@8488831
    12:52:41,874  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@14356788
    12:52:41,875  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@48008b9e
    12:52:41,876  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@1eaa492b
    12:52:41,878  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@458be695
    12:52:41,880  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6c69757a
    12:52:41,882  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@49df819
    12:52:41,883  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@79f46f78
    12:52:41,885  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@719444c9
    12:52:41,886  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@426f2ac6
    12:52:41,887  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4704f743
    12:52:41,889  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4c41a09
    12:52:41,890  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@72c56ea1
    12:52:41,891  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@2ab67140
    12:52:41,893  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@363e9f53
    12:52:41,894  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@11ce22ab
    12:52:41,896  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6acbc422
    12:52:41,897  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@46fbcc66
    12:52:41,898  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@1372948f
    12:52:41,900  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4e073534
    12:52:41,901  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@70821453
    12:52:41,902  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@1066cc83
    12:52:41,903  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6180ef93
    12:52:41,905  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@3909f81a
    12:52:41,906  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4397d6c7
    12:52:41,908  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@f1a0fad
    12:52:41,909  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@146a2afc
    12:52:41,910  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@26215e72
    12:52:41,911  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@634a5d3d
    12:52:41,913  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4a0848f6
    12:52:41,915  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@591913b3
    12:52:41,916  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@462e1da8
    12:52:41,918  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@67b8e498
    12:52:41,920  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@3bddf948
    12:52:41,921  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@a0d20b9
    12:52:41,923  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@617cc6cf
    12:52:41,925  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4023cecd
    12:52:41,926  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6cb83869
    12:52:41,927  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@5e7ef926
    12:52:41,928  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@1be1efa4
    12:52:41,929  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@243a3a1e
    12:52:41,930  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@273ea9d0
    12:52:41,931  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@5d91fa4
    12:52:41,932  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@593680e1
    12:52:41,934  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@a71094f
    12:52:41,935  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@3a3ca4ae
    12:52:41,936  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@55247653
    12:52:41,938  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@36622abb
    12:52:41,939  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@19193d1f
    12:52:41,941  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@71f599ef
    12:52:41,942  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@7e400fd9
    12:52:41,943  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6cf04d6b
    12:52:41,945  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@5d0f59a
    12:52:41,946  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@10aae61b
    12:52:41,947  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@7f1ee770
    12:52:41,949  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@3448cbd6
    12:52:41,950  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4d513b99
    12:52:41,951  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@7c0b7036
    12:52:41,952  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@52cee11e
    12:52:41,953  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@1b3a959a
    12:52:41,954  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@34a0ee3f
    12:52:41,956  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4c21e59a
    12:52:41,957  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@d2539a6
    12:52:41,958  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@3860910f
    12:52:41,959  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@479a3682
    12:52:41,960  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@15d26318
    12:52:41,961  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@4f82907d
    12:52:41,963  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@6e6abfe5
    12:52:41,964  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@2f77bebe
    12:52:41,965  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@62b3529b
    12:52:41,966  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@757b80d0
    12:52:41,967  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@51e2510c
    12:52:41,969  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@72b869a5
    12:52:41,970  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@9d14966
    12:52:41,972  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@74bd33f3
    12:52:41,973  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@642c189d
    12:52:41,975  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@770fd005
    12:52:41,976  INFO MysqlUtil:24 - com.mchange.v2.c3p0.impl.NewProxyConnection@434d3d4f
    ... ...
      

  2.   

    感觉是toString方法的问题，你可以用Connction.setClientInfo方法设置一下无关紧要的属性，在以后获得连接的地方取出来看看。你这些输出是在一个方法离得输出的吗？
      

  3.   


    应该是连接的一些属性被重新设置过，导致hashcode也改变了
      

  4.   

    你用==或者equals方法试一试，或者只是测试其中的某个属性的值是否是一样的，你可以去试一试，没有必要去弄这些东西
      

  5.   

    我尝试在取了connection并使用后就修改connection的部分内容，但是再次取并打印都不会是修改后的内容，也就是说这个connection是被重新初始化了的。
    我猜测，可能是close的时候把这个connection的所有值给清空了，还原成最初始状态并归还给连接池，当再次使用的时候，又根据这个connection重新实例化一个NewProxyConnection返回回来。如果比较connection，用==或equals肯定是不一样的，而connection都是基于同一个source取出来的，肯定属性都一样，打印了部分属性出来确认过。
      

  6.   

    源代码没有仔细度过，但是NewProxyConnection里面有个ROW_CONNECTION，你可以监控那个看看。还有你可以查看数据库的会话状态，连接存在了多久。这个其实不难。