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.