Return-Path: 
 <user-java-return-17735-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 34948 invoked from network); 10 Sep 2009 11:41:13 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 10 Sep 2009 11:41:13 -0000
Received: (qmail 92612 invoked by uid 500); 10 Sep 2009 11:41:12 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 92531 invoked by uid 500); 10 Sep 2009 11:41:12 -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 92523 invoked by uid 99); 10 Sep 2009 11:41:12 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 Sep 2009 11:41:12 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of odelya@jpost.com designates
 192.115.189.13 as permitted sender)
Received: from [192.115.189.13] (HELO jpost.com) (192.115.189.13)
    by apache.org (qpsmtpd/0.29) with SMTP; Thu, 10 Sep 2009 11:41:02 +0000
Received: (qmail 1833 invoked by uid 453); 10 Sep 2009 11:41:10 -0000
Received: from [81.218.24.130] (HELO dx2300m) (81.218.24.130)
  (smtp-auth username odelya, mechanism login)
  by jpost.com (qpsmtpd/0.40) with ESMTPA; Thu, 10 Sep 2009 14:41:10 +0300
From: "Odelya YomTov" <odelya@jpost.com>
To: <user-java@ibatis.apache.org>
Subject: connecting to datebase
Date: Thu, 10 Sep 2009 14:39:06 +0300
Message-ID: <002501ca320b$4e95f540$ebc1dfc0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
X-Mailer: Microsoft Office Outlook 12.0
Thread-Index: AcoyC0wbEN0/+A3tRxS2u7gEdCEJiA==
Content-Language: en-us
x-cr-puzzleid: {1BB594C2-C7A3-422E-8BF8-A67CDE8D609B}
x-cr-hashedpuzzle: QkM= AbVO AnF7 BrKn BszP Cs2y C+ka DkMn D6uh ER3q FUQ0 HqUB
 JCwF JXdy Jvhm
 J6/S;1;dQBzAGUAcgAtAGoAYQB2AGEAQABpAGIAYQB0AGkAcwAuAGEAcABhAGMAaABlAC4AbwByAGcA;Sosha1_v1;7;{1BB594C2-C7A3-422E-8BF8-A67CDE8D609B};bwBkAGUAbAB5AGEAQABqAHAAbwBzAHQALgBjAG8AbQA=;Thu,
 10 Sep 2009 11:39:04
 GMT;YwBvAG4AbgBlAGMAdABpAG4AZwAgAHQAbwAgAGQAYQB0AGUAYgBhAHMAZQA=
X-Virus-Checked: Checked by ClamAV on apache.org

Hi!
I have a problem with connection to the database.
I get com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

I connect like this:
<transactionManager type="JDBC">
		<dataSource type="SIMPLE">
			<property value="${driver}" name="JDBC.Driver" />
			<property value="${url}" name="JDBC.ConnectionURL"
/>
			<property value="${username}" name="JDBC.Username"
/>
			<property value="${password}" name="JDBC.Password"
/>
			<property name="defaultAutoCommit" value="true" />
			<property name="defaultTransactionIsolation"
value="2" />
			<property name="maxActive" value="10" />
			<property name="removeAbandoned" value="true" />
			<property name="removeAbandonedTimeout" value="30"
/>
			<property name="logAbandoned" value="false" />
			<property name="validationQuery" value="select 1" />
		</dataSource>
	</transactionManager>

Is there another way to connect to DB (other than SIMPLE) that I can try to
avoid the error?
It happens every 24 hours more or less

Thanks



---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org