数据源管理中,删除mysql正常,删除sqlserver报错

bug反馈 未结 1 179
英雄本色
英雄本色 VIP3 2019-02-14 17:40:02
收藏
产品:微服务 版本:1.5
500错误 {success=false, errorMessage= ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`)) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: DELETE FROM plugin_datasource_model WHERE id = ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`)) ; ]; Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`)), message=org.springframework.dao.DataIntegrityViolationException: ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`)) ### The error may involve defaultParameterMap ### The error occurred while setting parameters ### SQL: DELETE FROM plugin_datasource_model WHERE id = ? ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`)) ; ]; Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`)); nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jeeplus-boot`.`plugin_datasource_model_meta`, CONSTRAINT `FK_bi_datasource$bi_datasource_meta` FOREIGN KEY (`dsId`) REFERENCES `plugin_datasource_model` (`id`))} img[/userfiles/fly/11cb887695fb462b84fe8bea220e9288/files/1550137198880.]
回帖