Return-Path: 
 <user-java-return-15799-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 90345 invoked from network); 21 Dec 2008 19:00:46 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 21 Dec 2008 19:00:46 -0000
Received: (qmail 69383 invoked by uid 500); 21 Dec 2008 19:00:44 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 68916 invoked by uid 500); 21 Dec 2008 19:00:43 -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 68907 invoked by uid 99); 21 Dec 2008 19:00:43 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Dec 2008 11:00:43 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of prabha_pady@comcast.net
 designates 76.96.62.56 as permitted sender)
Received: from [76.96.62.56] (HELO QMTA06.westchester.pa.mail.comcast.net)
 (76.96.62.56)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 21 Dec 2008 19:00:34 +0000
Received: from OMTA04.westchester.pa.mail.comcast.net ([76.96.62.35])
	by QMTA06.westchester.pa.mail.comcast.net with comcast
	id ts6M1a0060ldTLk56v0DaY; Sun, 21 Dec 2008 19:00:13 +0000
Received: from PADYLAPTOP ([71.232.206.75])
	by OMTA04.westchester.pa.mail.comcast.net with comcast
	id tv0D1a0061e8Bxz3Qv0D01; Sun, 21 Dec 2008 19:00:13 +0000
Message-ID: <980AECF7EABB4D9F88783C01174D1C69@PADYLAPTOP>
From: "pady" <prabha_pady@comcast.net>
To: <user-java@ibatis.apache.org>
Subject: mysql issue...
Date: Sun, 21 Dec 2008 13:59:17 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-Virus-Checked: Checked by ClamAV on apache.org



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