The insert operation must provide keyColumn, but no need before

[snyang]

The following content worked when use mybatis, but failed when use mybatis_r2dbc,

<insert id="insert" parameterType="SysUser" useGeneratedKeys="true" keyProperty="userId">

To get the mybatis_r2dbc working, I have to provide values for keyColumn elements

<insert id="insert" parameterType="SysUser" useGeneratedKeys="true" keyProperty="userId" keyColumn="user_id">

[chenggangpro]

Could your provide a specific description , or demo project？

I checked my own used case and test suite about that,It works properly. Test case about insert return generated keys

FYI , The test running with mysql and mariadb-driver

[chenggangpro]

Sorry, I misunderstood, I will try to fix the problem later

[chenggangpro]

Hi~,
I have checked the source code ,the problem you mentioned is actually caused by the inconsistency between JDBC driver and R2DBC driver definition.

• 1 . the JDBC driver'sConnection provides a PreparedStatement prepareStatement(String sql, int autoGeneratedKeys) throws SQLException; method, the second parameter of this method indicates whether auto returns generatedKeys
• 2 . The R2DBC driver's Statement does not provide any method to return generatedKeys automatically, the Statement only has a Statement returnGeneratedValues(String... columns) method to return generatedKeys, the columns is not nullable ,so there column name must be specific.

Reference:

• 1 . JDBC's Connection
• 2 . R2DBC's Statement

[snyang]

Thanks. better to throw an exception for the case.

[chenggangpro]

Thanks. better to throw an exception for the case.

Sounds appropriate.I'll work on this.Thanks for your suggestion

[chenggangpro]

FYI: fixed in #56
I haven't released , this will be released in 1.0.10 later