Re: Communications link failure due to underlying exception
Posted by: Harikrishnan K
Date: November 01, 2006 05:52AM

I got the Communication link failure message with a java.io.EOFException when executing this query.

select count(masterTab.responseId) from TAB_RESPONSE masterTab , TAB_RESPONSE_desc descTab0 where masterTab.surveyPk='xIUejiZEFcQJTk6FsLqnzA' and STR_TO_DATE(DATE_FORMAT(masterTab.responseTime, '%b %d, %Y'), '%b %d, %Y') >= STR_TO_DATE('Oct 25, 2006', '%b %d, %Y') and STR_TO_DATE(DATE_FORMAT(masterTab.responseTime, '%b %d, %Y'), '%b %d, %Y') <= STR_TO_DATE('Nov 01, 2006', '%b %d, %Y') and masterTab.responseId = descTab0.responseId and descTab0.questionId = 'QlbRDf7EPW4RDH7fYQ6ADw' and descTab0.key1 = 1


Now when I changed the date format to %m/%d/%Y it works fine.

I got the error when using
mysql - Ver 14.12 Distrib 5.0.16, for pc-linux-gnu (i686) using readline 5.0
connectorJ - mysql-connector-java-5.0.4-bin.jar


My dev box with mysql 5.0.26 seems to work fine with the old date format

is that a bug. (ended spending a lot of time on this one)

Thanks
Hari

Options: ReplyQuote


Subject
Written By
Posted
June 09, 2006 04:42AM
August 24, 2006 05:27PM
Re: Communications link failure due to underlying exception
November 01, 2006 05:52AM
July 15, 2007 04:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.