Обсуждение: mybatis 3 RETURNING id problem with insert.
Hello.
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 (mybatis-3.0.3.jar) (8.4.5 postgres, driver
version 8.4-702) return always - 1
Code iBatis xml
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 *
I need something to put in the code ?
Thank you very much for responding.
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 (mybatis-3.0.3.jar) (8.4.5 postgres, driver
version 8.4-702) return always - 1
Code iBatis xml
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 *
I need something to put in the code ?
Thank you very much for responding.