ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "meindert" <meind...@eduflex.com>
Subject RE: Error calling Connection.setAutoCommit:
Date Wed, 18 Nov 2009 10:58:38 GMT
Not sure what the difference is, but I'm using the validationQuery property
to check the connection;
<property name="validationQuery" value=" select top 1 'niks' from DUAL "/>

The second thing I noticed is that 'select 1 from DUAL' will return all rows
in DUAL, shouldn't you use 'select top 1 * from DUAL'

-----Original Message-----
From: Ron H [mailto:be.special@gmail.com] 
Sent: 18 November 2009 11:48 AM
To: user-java@ibatis.apache.org
Subject: Error calling Connection.setAutoCommit:


hi
randomly, i get the following exception:
18/11/2009 03:18:49 ERROR Connection:19 - Error calling
Connection.setAutoCommit:
com.mysql.jdbc.CommunicationsException: Communications link failure due to
underlying exception:

** BEGIN NESTED EXCEPTION **

java.io.EOFException

STACKTRACE:

java.io.EOFException
       at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1934)

my configuration file is:
<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="${driver}" />
				<property name="url" value="${url}" />
				<property name="username"
value="${username}" />
				<property name="password"
value="${password}" />
				<property name="poolPingQuery" value="select
1 from DUAL" />
				<property name="poolPingEnabled"
value="true" />
			</dataSource>
		</environment>
	</environments>
it reopen the connection and things are working. i am just wondering how
does it happen? how can i prevent it from happening?
-- 
View this message in context:
http://old.nabble.com/Error-calling-Connection.setAutoCommit%3A-tp26405013p2
6405013.html
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.


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


No virus found in this incoming message.
Checked by AVG - www.avg.com 
Version: 9.0.707 / Virus Database: 270.14.67/2505 - Release Date: 11/17/09
21:26:00


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


Mime
View raw message