### Error updating database. Cause: java.sql.SQLException: Incorrect integer value: ‘cbde2b5043

### Error updating database. Cause: java.sql.SQLException: Incorrect integer value: 'cbde2b5043b54d7cb5b8a42b78adba61' for column 'id' at row 1 ### The error may exist in class path resource [mapper/bortal/ProspecMapper.xml] ### The error may involve bortal.mapper.ProspecMapper.insertGeoProspec-Inline ### The error occurred while setting parameters ### SQL: insert into rospec ( id, file_name, prepared, prepared_time, detection, location, create_by, create_time, prepared_staff ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ? ) ### Cause: java.sql.SQLException: Incorrect integer value: 'cbde2b5043b54d7cb5b8a42b78adba61' for column 'id' at row 1 ; uncategorized SQLException; SQL state [HY000]; error code [1366]; Incorrect integer value: 'cbde2b5043b54d7cb5b8a42b78adba61' for column 'id' at row 1; nested exception is java.sql.SQLException: Incorrect integer value: 'cbde2b5043b54d7cb5b8a42b78adba61' for column 'id' at row 1
相信很多人可能会遇到这样的问题，如果遇到这样的问题将id的自增方式去掉，并修改这个id字段的类型，稍加尝试应该 就能成功。