导入本地EXCEL保存报错

2016-07-05 00:30:06.710 ERROR — [nio-8100-exec-1] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed: org.springframework.dao.DataIntegrityViolationException:

Error updating database. Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column ‘id’ at row 1

The error may exist in io/dataease/datasource/dao/auto/mapper/CoreDatasourceMapper.java (best guess)

The error may involve io.dataease.datasource.dao.auto.mapper.CoreDatasourceMapper.insert-Inline

The error occurred while setting parameters

SQL: INSERT INTO core_datasource ( id, name, type, pid, configuration, create_time, update_time, update_by, create_by, task_status ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column ‘id’ at row 1

; Data truncation: Out of range value for column ‘id’ at row 1] with root cause
com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Out of range value for column ‘id’ at row 1
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)

用简单的excel验证一下看看服务有没有问题。

方便提供下原始Excel吗?我这边测试一下