Return-Path: 
 <user-java-return-15800-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 36188 invoked from network); 21 Dec 2008 22:10:56 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 21 Dec 2008 22:10:56 -0000
Received: (qmail 44457 invoked by uid 500); 21 Dec 2008 22:10:50 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 44443 invoked by uid 500); 21 Dec 2008 22:10:50 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 44434 invoked by uid 99); 21 Dec 2008 22:10:50 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Dec 2008 14:10:50 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of nospam@kinokai.de designates
 72.14.220.155 as permitted sender)
Received: from [72.14.220.155] (HELO fg-out-1718.google.com) (72.14.220.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Dec 2008 22:10:40 +0000
Received: by fg-out-1718.google.com with SMTP id d23so673698fga.32
        for <user-java@ibatis.apache.org>;
 Sun, 21 Dec 2008 14:10:20 -0800 (PST)
Received: by 10.86.29.8 with SMTP id c8mr3250972fgc.67.1229897420265;
        Sun, 21 Dec 2008 14:10:20 -0800 (PST)
Received: from ?192.168.2.26? (pD9E954E8.dip.t-dialin.net [217.233.84.232])
        by mx.google.com with ESMTPS id 3sm7445915fge.57.2008.12.21.14.10.18
        (version=SSLv3 cipher=RC4-MD5);
        Sun, 21 Dec 2008 14:10:19 -0800 (PST)
Message-ID: <494EBEC9.5030207@kinokai.de>
Date: Sun, 21 Dec 2008 23:10:17 +0100
From: Kai Grabfelder <nospam@kinokai.de>
User-Agent: Thunderbird 2.0.0.18 (Windows/20081105)
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: mysql issue...
References: <980AECF7EABB4D9F88783C01174D1C69@PADYLAPTOP>
In-Reply-To: <980AECF7EABB4D9F88783C01174D1C69@PADYLAPTOP>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Hi,

this is kind of a mysql "feature". Connections that are not used for some time are automatically closed. If
you are using spring you can workaround this with the following datasource configuration:

<bean id="nativeDataSource" class="org.apache.commons.dbcp.BasicDataSource">
  <property name="driverClassName" value="${jdbc.driverClassName}" />
  <property name="url" value="jdbc:mysql://localhost/wemwannwas" />
  <property name="username" value="${jdbc.username}" />
  <property name="password" value="${jdbc.password}" />
  <property name="maxActive" value="15"></property>
  <property name="testWhileIdle" value="true"></property>
  <property name="validationQuery" value="select 1 from dual"/>
 </bean>

Regards

Kai

--- Original Nachricht ---
Absender: pady
Datum: 21.12.2008 19:59
> 
> Hi,
> 
> ibatis 2.3
> mysql 5.0.29
> mysql-connector 5.0.4
> 
> After a few hours of my web app being idle, when I try to connect I get this
> exception, when i try to connect through ibatis:
> 
> com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException:
> Connection.close() has already been called. Invalid operation in this state.
> 
> I have googled, checked the mysql archives etc and all I find is to make
> sure the ibatis transactionmanager as external...
> 
> My transaction manager is setup as
> 
> <transactionManager type="JDBC" commitRequired="true">
> 
> <property name="SetAutoCommitAllowed" value="true"/>
> 
> <property name="DefaultAutoCommit" value="false"/>
> 
> <dataSource type="SIMPLE">
> 
> <property name="JDBC.Driver" value="com.mysql.jdbc.Driver"/>
> 
> <property name="JDBC.ConnectionURL" value="jdbc:mysql://localhost/***"/>
> 
> <property name="JDBC.Username" value="***"/>
> 
> <property name="JDBC.Password" value="***"/>
> 
> </dataSource>
> 
> </transactionManager>
> 
> 
> 
> I want to know whether users here have seen the error above and how they
> solved it.
> 
> 
> 
> Thx
> 
> -- pady
> 
> 
> 
>