Thanks for the response,
I already viewed that thread but it does not help me much as I already corrected the query and added space before AND, and still have the exception. The problem is that the query is executed correctly in MySQL browser and it returns correct result when executed from java. I am getting the exception after SHOW VARIABLES statement. Thanks, anyway, I'll try to post this in the MySQL Forum. _____ From: James Stansell [mailto:[EMAIL PROTECTED] Sent: Friday, February 23, 2007 6:41 PM To: [email protected] Subject: Re: Exception when connecting to DB On 2/23/07, Branislav Cavlin <[EMAIL PROTECTED]> wrote: > We are using Spring framework in our configuration, and we use it in > about 15 application, but this is the only one that gives us this > message. The problem is that this exception is raised on SHOW COLLATION > and SHOW VARIABLES statements, and not actual Query. I am not sure what > can cause this. > select * from Empathica.tbl_MnTB_200510 > where ExportedAt = '0000-00-00 00:00:00'AND >StatusID IN ('C', 'T') http://bugs.mysql.com/bug.php?id=9831 includes the same "SHOW VARIABLES" message, but it turned out the real problem was a SQL syntax error. Try adding a space before "AND StatusID" in your SQL statement. Regards, -james.
