ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Graeme J Sweeney <ibatis.u...@gjsweeney.com>
Subject Re: MySQL query problem
Date Fri, 20 Oct 2006 09:40:24 GMT
On Fri, 20 Oct 2006, Javier Leyba wrote:

> I've the following code defined:
>
> ----------------
> <select id="insertTopic" parameterClass="topic"
>               resultClass="genericResult">
>               <![CDATA[
>                       INSERT INTO topic (
>                       topic.topic_id,
>                       topic.topic_description
>                       ) VALUES (#id#, #description#);
>                SELECT ROW_COUNT() AS result;
>        ]]>
>       </select>
> ----------------------

<snip/>

> Log show me that parameters arrives to query without problems. If I
> put those querys in a MySQL it works ok, so..... I' ve no idea about
> the origin of the error and how to fix it.
>
> Could somebody give me a clue ?

Create separate <insert/> and <select/> statements and run them as 
a transaction?

-- 
Graeme -

Mime
View raw message