之前写了一个mysql事务管理的小框架,用的好好的,今天将mysql驱动更新到6.0之后(之前是5.0),发现之前跑的好好的代码出问题了
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.4</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>6.0.4</version>
</dependency>
向数据库增加记录的语句都报如下错误:
java.sql.SQLException: Generated keys not requested. You need to specify Statement.RETURN_GENERATED_KEYS to Statement.executeUpdate(), Statement.executeLargeUpdate() or Connection.prepareStatement().
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:569)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:537)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:527)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:512)
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:480)
at com.mysql.cj.jdbc.StatementImpl.getGeneratedKeys(StatementImpl.java:1729)
问题原因:
所有子增长主键的表,往里面插入数据后调用这句获取自增主键的值都会报错:
ResultSet rs = ps.getGeneratedKeys();
修复方式:
PreparedStatement ps = con.prepareStatement(sql,
Statement.RETURN_GENERATED_KEYS);
获取ps的时候,加上红色部分的参数就ok了;
这驱动升级不地道,竟然做了这样的改动;