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.spec...@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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@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-unsubscr...@ibatis.apache.org For additional commands, e-mail: user-java-h...@ibatis.apache.org
