Re: RETURNING id problem with insert. - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: RETURNING id problem with insert.
Date
Msg-id AANLkTimx874MjzqQD5aXnUTTYSZvNsN_K-ODL7erHdQE@mail.gmail.com
Whole thread Raw
In response to Re: RETURNING id problem with insert.  (- <grandebuzon@gmail.com>)
Responses Re: RETURNING id problem with insert.
List pgsql-jdbc
On Tue, Dec 7, 2010 at 5:05 PM, - <grandebuzon@gmail.com> wrote:
> With this code, always returns 1 instead of new generated ID
>  <insert id="insertNewItem" parameterType="itemAlias"
> useGeneratedKeys="true" keyProperty="item_id">
> INSERT INTO items (
> category_id,
> description,
> ...)
> VALUES(
> #{category_id},
> #{description},
> ...)
>   </insert>
> and if I put RETURNING item_id at the end of insert,
> ......
> VALUES(
> #{category_id},
> #{description},
> ...) RETURNING item_id
>
>   </insert>
>
>  fails with error in the postgres log - syntax error at or near "RETURNING"
> ........$12,
> $13,
> $14)
> RETURNING item_id RETURNING *

It appears that Ibatis added RETURNING * after your RETURNING item_id.
I'd speak to them to see how to do it properly.

Dave

pgsql-jdbc by date:

Previous
From: -
Date:
Subject: Re: RETURNING id problem with insert.
Next
From: -
Date:
Subject: Re: RETURNING id problem with insert.