You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user-java@ibatis.apache.org by Niels Beekman <n....@wis.nl> on 2006/01/27 10:36:22 UTC

RE: Incorrrect syntax near '@PO'

Parameters are not supported by the kill-command, use kill $value$, this causes iBATIS to use the parameter directly.

________________________________________
From: Om Narayan [mailto:om5@hotmail.com] 
Sent: donderdag 26 januari 2006 22:34
To: user-java@ibatis.apache.org
Subject: Incorrrect syntax near '@PO'

Hi,
I have the following statement setup.

<statement id="killSqlProcessId" parameterClass="int">
kill #value#
</statement>

When I try to execute using, 

sqlMap.queryForObject( "killSqlProcessId", procId );

I get "Incorrrect syntax near '@PO'"  error although the sql log shows the prepared statement and the parameter to be correct. Any help is greatly appreciated.

Thanks.

RE: Incorrrect syntax near '@PO'

Posted by Om Narayan <om...@hotmail.com>.

Thank you. That's what I needed.


>From: "Niels Beekman" <n....@wis.nl>
>Reply-To: user-java@ibatis.apache.org
>To: <us...@ibatis.apache.org>
>Subject: RE: Incorrrect syntax near '@PO'
>Date: Fri, 27 Jan 2006 10:36:22 +0100
>
>Parameters are not supported by the kill-command, use kill $value$, this 
>causes iBATIS to use the parameter directly.
>
>________________________________________
>From: Om Narayan [mailto:om5@hotmail.com]
>Sent: donderdag 26 januari 2006 22:34
>To: user-java@ibatis.apache.org
>Subject: Incorrrect syntax near '@PO'
>
>Hi,
>I have the following statement setup.
> 
><statement id="killSqlProcessId" parameterClass="int">
>kill #value#
></statement>
> 
>When I try to execute using,
> 
>sqlMap.queryForObject( "killSqlProcessId", procId );
> 
>I get "Incorrrect syntax near '@PO'"  error although the sql log shows the 
>prepared statement and the parameter to be correct. Any help is greatly 
>appreciated.
> 
>Thanks.