On Tue, Dec 7, 2010 at 5:05 PM, - <grandebuzon@gmail.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.