Skip site navigation (1) Skip section navigation (2)

Re: RETURNING id problem with insert.

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: - <grandebuzon(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: RETURNING id problem with insert.
Date: 2010-12-07 22:12:41
Message-ID: AANLkTimx874MjzqQD5aXnUTTYSZvNsN_K-ODL7erHdQE@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
On Tue, Dec 7, 2010 at 5:05 PM, - <grandebuzon(at)gmail(dot)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

In response to

Responses

pgsql-jdbc by date

Next:From: -Date: 2010-12-07 22:57:18
Subject: Re: RETURNING id problem with insert.
Previous:From: -Date: 2010-12-07 22:05:07
Subject: Re: RETURNING id problem with insert.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group