Java Mailing List Archive

Home » user-java.ibatis »

useGeneratedKeys, data not inserted, ibatis 3.0 trunk and sql 2005

Thanh PHAM


Replies: Find Java Web Hosting

Author LoginPost Reply

I tried to use useGeneratedKeys for mssql 2005, latest driver version.
The identity is incremented and everything seem OK but the data is not present in the table.

Here is my xml and log.

<insert id="insertXtp" parameterType="map" keyProperty="id" useGeneratedKeys="true">
    insert into xtp_selectkey (label) values (#{label})

setting : <setting name="useGeneratedKeys" value="true"/>

Driver version 2.0.1803.100 sqljdbc.jar
ibatis version : 3.0-beta4 7 Oct 2009

log :
Connection (26) - ooo Connection Opened
PreparedStatement (26) - ==>  Executing: insert into xtp_selectkey (label) values (?)
PreparedStatement (26) - ==> Parameters: title(String)
Connection (26) - xxx Connection Closed
©2008 - Jax Systems, LLC, U.S.A.