ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "James Stansell" <jamesstans...@gmail.com>
Subject Re: Exception when connecting to DB
Date Fri, 23 Feb 2007 23:40:35 GMT
On 2/23/07, Branislav Cavlin <branislav.cavlin@nucomm.net> 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.



View raw message