idea的mybatis的xml文件总是报警告SQL dialect is not configured

以你之姓@ 2023-07-05 10:24 1阅读 0赞

警告：

No data sources are configured to run this SQL and provide advanced code assistance. Disable this inspection via problem menu (Alt+Enter). more... (Ctrl+F1)

SQL dialect is not configured. PostgreSQL, SQL Server match best. more... (Ctrl+F1)

![format_png][]

这是两个警告，首先我们解决一个警告：

File -> setting 搜索inspections,再搜索sql，找到SQL dialect detection去掉勾，然后apply ->ok

![format_png 1][]

这个时候我们发现只有一个警告了

![format_png 2][]

现在我们解决最后一个警告:,点开右上角的Database,我这里用的是mysql示例，这里不用填写mysql的数据库，用户名，密码什么的，直接apply，然后ok，并不影响启动项目时的mysql连接，mysql的连接该在application.properties或application.yml中怎么配就怎么配：

![format_png 3][]

这样就没有警告了：

![format_png 4][]

把项目关掉再开启也还是没有警告了，写完收工

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvMTExNzY4Mi8yMDE3MDYvMTExNzY4Mi0yMDE3MDYyMDIwNDY1NzIyNi0yMDYzODA1OTA0LnBuZw?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvMTExNzY4Mi8yMDE3MDYvMTExNzY4Mi0yMDE3MDYyMDIwNTAzMjMwNC0xNzI2NTM4MzY5LnBuZw?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvMTExNzY4Mi8yMDE3MDYvMTExNzY4Mi0yMDE3MDYyMDIwNTIxNDcxMC02NzQ1ODU3NDAucG5n?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvMTExNzY4Mi8yMDE3MDYvMTExNzY4Mi0yMDE3MDYyMDIwNTQ0MjExNi03MTUxNjk5NTMucG5n?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9pbWFnZXMyMDE1LmNuYmxvZ3MuY29tL2Jsb2cvMTExNzY4Mi8yMDE3MDYvMTExNzY4Mi0yMDE3MDYyMDIwNTkzNDUzOC0xNzE0NzA5MTQ4LnBuZw?x-oss-process=image/format,png