On 2/26/07, Branislav Cavlin <[EMAIL PROTECTED]> wrote:
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.
OK - that's good to know. I think the SHOW VARIABLES is probably related to JDBC metadata. Since your plain JDBC query doesn't trigger the error I'm wondering if it's some feature that Spring and/or iBATIS has turned on. HTH, -james.
