`
skyxiewanting
  • 浏览: 12066 次
  • 性别: Icon_minigender_2
  • 来自: 济南
社区版块
存档分类
最新评论

Connection is invalid

阅读更多
    在项目的运行过程中时不时的在控制台打印出的错误信息,错误信息出现后未影响到程序的运行,所以一直都未此过多关注,现在,项目接近尾声,想把此问题解决,控制台打印的具体信息如下:
   java.sql.SQLException: Connection is invalid
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(C3P0PooledConnectionPool.java:196)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:136)
at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1394)
at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)

    在网上搜索了一些解决方案,说这不是问题,仅仅是一个定时的测试连接是否正常的程序,可以在连接池的配置文件中禁掉。
    所以我在spring的配置文件中加入了一下信息:
    <property name="testConnectionOnCheckout">   
       <value>true</value>   
    </property>
    但问题貌似没有解决,程序运行的时候还是会时不时的在控制台打印上面的错误信息,而且有一次tomcat服务器无故自动关闭了,甚是不解,呃……不知道还有没有其他的解决方案,在此请教了…………
分享到:
评论
1 楼 风花雪月饼 2010-11-30  
这个不是问题。。。

你把这个checkout配置注释掉或是改为false看看

相关推荐

    VMware Workstation Pro 14导入ova报错问题解决方法(Invalid target disk adapter type pvscsi)

    &lt;Connection&gt;SCSI controller 0:0&lt;/Connection&gt; &lt;ResourceType&gt;17 &lt;Address&gt;0 &lt;HostResource&gt;ovf:/disk/vmdisk1 &lt;InstanceID&gt;1000 &lt;Parent&gt;3 &lt;PresentationPosition&gt;0 &lt;ResourceSubType&gt;sparsedisk ...

    unidac5.3.8src

    Bug with invalid client library when using connection pooling is fixed Bug with refreshing a detail dataset in Master-Detail is fixed PostgreSQL data provider Bug with parsing dollar-quoted strings ...

    Devart UniDAC v5.3.8 Source

    -Bug with invalid client library when using connection pooling is fixed -Bug with refreshing a detail dataset in Master-Detail is fixed PostgreSQL data provider -Bug with parsing dollar-quoted strings...

    moxa-mxview-plugin-for-mgate-series-software-package-v2.5.zip

    Ready Green Steady on: Power is on, and the unit is functioning normally Blinking: The unit is responding to the software’s Locate function Red Steady on: Power is on, and the unit is booting up ...

    Devart UniDAC v5.3.10 Full Source

    -Bug with "Invalid field size" in TVirtualTable is fixed -Bug with AV failure on freeing objects on mobile platforms is fixed -Several bugs in the SmartFetch mode are fixed Oracle data provider -Data...

    UniDAC 7.1.4

    Bug with the "Invalid column name" error when editing a query with the JOIN statement is fixed InterBase data provider Bug with memory leak when using the SQLMonitor component is fixed PostgreSQL ...

    SMTP错误码建议解决方法

    442. The Connection Was Dropped During Transmission 这个错误码表示传送邮件的过程中联机中断。解决方法是检查邮件是否带有病毒附件,并检查邮件服务器是否正常作业。 446. The Maximum Hop Count Was Exceeded...

    微软内部资料-SQL性能优化3

    Another type of table lock is a schema stability lock (Sch-S) and is compatible with all table locks except the schema modification lock (Sch-M). The schema modification lock (Sch-M) is incompatible ...

    teraterm-4.93

    When the real time mode is off while using broadcast command, invalid character would be added to the end of string. MACRO: When closesbox command is executed, the memory leak of Macro core(ttpmacro....

    UPnP_Programming_Guide

    - **4.1.2** `UPNP_E_INVALID_HANDLE [-100]`: Occurs when an invalid handle is passed to a function. - **4.1.3** `UPNP_E_INVALID_PARAM [-101]`: Signals that one or more parameters passed to a function ...

    解决Jave在linux下转为MP3时为0字节或其他异常或转码后只有1分钟时长

    jave-1.0.2.3.jar完全解决如下问题: 1、报错:it.sauronsoftware.jave.EncoderException: Metadata: 2、可以转换,可以播放,但是有个异常:it.sauronsoftware.jave.EncoderException: video:0kB audio:1301kB ...

    dx修复工具

    You can enable "C++ enhanced repairing" from "Tool" -&gt; "Option" -&gt; "Lab" if normal repairing is invalid. Please be aware that this function is experimental and should only be used when normal ...

    socket网络编程

    printf("Accept connection from %s\n",inet_ntoa(clientAddress.sin_addr)); } } if(i&gt;5) { printf("超过最大客户端数"); exit(-1); } } else { int bytes...

    kettle集成应用之---java调用执行transformation和job

    为配置Repository,需要先配置Database Connection(数据库连接),填写Name和Description,点击“Create or Upgrade”按钮,就可以将kettle的元数据表创建到指定的数据库中。 二、kettle设计界面 在Repository...

    springframework.5.0.12.RELEASE

    WebClient logs "Only one connection receive subscriber allowed" when response status is an error [SPR-17564] #22096 Potential resource leak in DataSourceUtils.doGetConnection [SPR-17559] #22091 ...

    aiohttp-socks:用于aiohttp的代理(HTTP,SOCKS)连接器

    aiohttp-袜子 aiohttp-socks软件包为提供了代理连接器。... 它使用实现核心代理功能。 要求 Python&gt; = 3.6 aiohttp&gt; = 2.3.2 python-socks [asyncio]&gt; = 1.0.1 安装 pip install aiohttp_socks ...

    S7A驱动720版本

    Note: If the connection to the NetLink is disturbed, the driver starts in demo mode, because it can't read out the licence code. If afterwards the connection to the Netlink can be established, the ...

    kettle连接sqlserver连不上-jtds.jar包

    在IT领域,Kettle(又称Pentaho Data Integration或PDI)是一款强大的数据集成工具,它允许用户通过图形化界面来处理和转换数据。在尝试使用Kettle连接SQL Server数据库时,可能会遇到一些问题,特别是在Kettle的...

    NBU mysql备份管理

    DISCLAIMERS ARE HELD TO BE LEGALLY INVALID. VERITAS TECHNOLOGIES LLC SHALL NOT BE LIABLE FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES IN CONNECTION WITH THE FURNISHING, PERFORMANCE, OR USE OF THIS ...

    PLSQL.Developer v11.0.0.1762 主程序+ v10中文包+keygen

    Compile Invalid Objects no longer implicitly refreshes the object list when the main connection is changed Copy function added to the Search List popup menu Refresh function added to the File Browser ...

Global site tag (gtag.js) - Google Analytics