- **DataEase的V2.10.10版本,前期安装和使用都很正常,但完成仪表盘设计以后,点击发布是报错,具体错误如下:
Request processing failed: org.springframework.jdbc.BadSqlGrammarException: ### Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dvi WHERE dvi.id IN ( ’ at line 4 ### The error may exist in class path resource [mybatis/ExtDataVisualizationMapper.xml] ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: DELETE FROM data_visualization_info dvi WHERE dvi.id IN ( ? ) ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'dvi WHERE dvi.id IN ( ’ at line 4 ; bad SQL grammar []
** - 请高手帮忙指点一下,谢谢
数据库需要使用 MySQL 8.0.16 版本以上数据库
官方文档有说明: