druid v1.1.21搭配mybatis-spring-boot v2.1.1 使用mysql 自增 id 失败

[yansheng723]

相关版本

\<dependency> \<groupId>org.mybatis.spring.boot\</groupId> \<artifactId>mybatis-spring-boot-starter\</artifactId> \<version>2.1.1\</version> \</dependency> \<dependency> \<groupId>com.alibaba\</groupId> \<artifactId>druid\</artifactId> \<version>1.1.21\</version> \</dependency> \<dependency> \<groupId>mysql\</groupId> \<artifactId>mysql-connector-java\</artifactId> \<version>8.0.18\</version> \</dependency>

相关代码

@Options(useGeneratedKeys = true) @Insert("insert into project (name, description, author_id) " + "values(#{name}, #{description}, #{authorId})") int insert(Project project);

[yansheng723]

更新问题, @Options(useGeneratedKeys = true, keyProperty = "id")需要强制写入, keyProperty = "id", 否则自增失效

[lizongbo]

druid连接池不会影响sql的生成，应该是mybatis的问题