ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Branislav Cavlin" <branislav.cav...@nucomm.net>
Subject RE: Exception when connecting to DB
Date Mon, 26 Feb 2007 14:48:33 GMT
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:jamesstansell@gmail.com] 
Sent: Friday, February 23, 2007 6:41 PM
To: user-java@ibatis.apache.org
Subject: Re: Exception when connecting to DB


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
> and SHOW VARIABLES statements, and not actual Query. I am not sure
> 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