mybatis-spring-boot-starter mysql insert get id

[davaa...@gmail.com]

used xml mapper. mySql db.
not return value of column "id". return value is 1.

<insert id="insert" parameterType="User" keyColumn="id" keyProperty="id" parameterMap="parameters" useGeneratedKeys="true">

and tried

       <selectKey keyProperty="id" resultType="int" order="after">

        SELECT MAX(id) FROM lut_users;

       </selectKey>

how get id or value of last inserted data?

[Tim]

Why do you have both parameterMap and parameterType set? you can remove parameterMap for mybatis.

If that doesn't fix it then:

What version are you using?

Can you show the model and insert statement?

--
You received this message because you are subscribed to the Google Groups "mybatis-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Guy Rouillier]

According to https://stackoverflow.com/questions/6761403/how-to-get-the-next-auto-increment-id-in-mysql,

mysql_insert_id();

should retrieve the last auto-increment value used.  I don't have a lot of experience with MySQL, but make sure this all happens within a single transaction to ensure you get the correct value.  In general, using MAX() is not a reliable method in a multi-user database due to race conditions.  Someone else may insert a row immediately after you do, and MAX() would retrieve the id of *that* row, not yours.

--

Guy Rouillier

To unsubscribe from this group and stop receiving emails from it, send an email to mybatis-user...@googlegroups.com.