RETURNING id problem with insert.

From: - <grandebuzon(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: RETURNING id problem with insert.
Date: 2010-12-07 18:49:12
Message-ID: AANLkTin5WvhHbi0rN4BZDhuc1i9_8yNnoKMObfkzXDrK@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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.

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Oliver Jowett 2010-12-07 19:52:53 Re: Connection Problem
Previous Message Werner Donné 2010-12-07 14:08:04 Re: DatabaseMetaData.getStringFunctions() reports "concat"