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

Re: RETURNING id problem with insert.

From: - <grandebuzon(at)gmail(dot)com>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: RETURNING id problem with insert.
Date: 2010-12-07 22:05:07
Message-ID: AANLkTikuipoBZ=iBw2XYn6u6bbM6HMT=-29m14Y2zCh=@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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 *



2010/12/7 Dave Cramer <pg(at)fastcrypt(dot)com>

> Have a look at the postgresql logs to see what ibatis is actually
> generating. There is no reason it should not work
>
> Dave
>
> On Tue, Dec 7, 2010 at 1:49 PM, - <grandebuzon(at)gmail(dot)com> wrote:
> > RETURNING id problem with insert.
> > Hello everyone.
> > Iam trying to do an insert for return generated id INSERT RETURNING id.
> In
> > postgres editor it work without problems, but in code execution - java
> 1.6
> > with iBatis 3 (8.4 postgres driver version 8.4-702) gives the error -
> Caused
> > by: org.postgresql.util.PSQLException: ERROR: syntax error at or near "
> > RETURNING. "
> > It this means Postgres does not support Returning to insert?
> > I found this online -
> >
> http://stackoverflow.com/questions/1769595/concurrency-issues-when-retriveing-ids-of-newly-inserted-rows-with-ibatis
> > but not how to do <statement ... Second answer, I get error iBatis xml
> > editor. I think it's for iBatis 2 version.
> > Thank you very much for responding.
> >
> > Español.
> > Problema con RETURNING id con insert.
> > Hola a todos.
> > Intento hacer un insert y que me devuelva id generada con  INSERT ....
> > RETURNING id. En editor de postgres funcciona sin problemas, pero en
> > ejecucion java 1.6 con iBatis 3 (version postgres 8.4 driver 8.4-702)  da
> el
> > error - Caused by: org.postgresql.util.PSQLException: ERROR: error de
> > sintaxis en o cerca de «RETURNING».
> > Postgres no soporta returning con insert ?
> > He encontrado esto en internet -
> >
> http://stackoverflow.com/questions/1769595/concurrency-issues-when-retriveing-ids-of-newly-inserted-rows-with-ibatis
> > pero no se como hacer <statement ... de segunda respuesta,  me da error
> > editor xml de iBatis. Pienso que es para version iBatis 2
> > Muchas gracias por responder.
> >
> >
> >
> >
>

In response to

Responses

pgsql-jdbc by date

Next:From: Dave CramerDate: 2010-12-07 22:12:41
Subject: Re: RETURNING id problem with insert.
Previous:From: Dave CramerDate: 2010-12-07 20:25:33
Subject: Re: RETURNING id problem with insert.

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