blocks|key|2214958|text|设置>检查。取消选择'SQL‘。或者，您可以将光标放在错误上，然后按alt%2Benter键。其中一个选项是“禁用检查”。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2214959|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Settings > Inspections. Unselect 'SQL'. Alternatively you can place your cursor on the error and press alt+enter. One of the options will be 'Disable Inspection'.

blocks|key|3201521|text|您可以在语句前使用注释language=，即。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3201522|//language=MySQL
String+stmt1+=+"INSERT+INTO+a+(b)+values(?)";
//language=Oracle
String+stmt2+=+"SELECT+SYSDATE+FROM+dual";|code-block|syntax|javascript|3201523|请参阅https://www.jetbrains.com/idea/help/using-language-injections.html|offset|length|3201524|entityMap|0|LINK|mutability|MUTABLE|url|https://www.jetbrains.com/idea/help/using-language-injections.html^0|0|0|3|1U|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

You could use a comment language= before the statement, i.E.

<pre><code>//language=MySQL
String stmt1 = "INSERT INTO a (b) values(?)";
//language=Oracle
String stmt2 = "SELECT SYSDATE FROM dual";
</code></pre>

See <a href="https://www.jetbrains.com/idea/help/using-language-injections.html" rel="noreferrer">https://www.jetbrains.com/idea/help/using-language-injections.html</a>

blocks|key|2215018|text|您也可以关闭困扰您的特定检查。无需关闭所有SQL支持(例如，自动完成提示很好)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2215019|为此，您可以转到Settings+-->+Editor+-->+Inspections+-->+SQL并取消选中不需要的选项。例如，我刚刚禁用了“未配置数据源”和“未解析引用”。|2215020|在IntelliJ旗舰版2019.2中，如下所示：|2215021|​|2215022|📷|atomic|offset|length|2215023|2215024|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/b8043493cb14c260a488822c2c540c0e.png|imageAlt^0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|J|7|10|8|@]|9|@$K|11|L|12|1|13]]|A|$]]|$1|M|3|G|5|6|7|14|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|O|$P|$5|Q|R|S|A|$T|U|V|-4]]]]

You can alternatively turn off the specific inspection that is bothering you. No need to turn off all SQL support (e.g. auto-complete hints are nice).

To do this, you can go to Settings --> Editor --> Inspections --> SQL and uncheck the ones you don't want. For instance, I just disabled "No data sources configured" and "Unresolved reference".

In IntelliJ Ultimate 2019.2, this looks like this:

<a href="https://i.stack.imgur.com/oBGCH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oBGCH.png" alt="IntelliJ SQL Inspections"></a>

blocks|key|5312640|text|对于IntelliJ+IDEA+2017.3，可以禁用sql检查:文件%7C设置%7C检查%7C+SQL|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5312641|​|5312642|📷|atomic|offset|length|5312643|5312644|5312645|5312646|5312647|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/cede17540db169db123e5d1b3cc3121d.png|imageAlt|1|https://ask.qcloudimg.com/http-save/yehe-900000/56e2e916e799d2dfa1daf506dda1af28.png^0|0|0|0|1|0|0|0|0|0|1|1|0|0^^$0|@$1|2|3|4|5|6|7|X|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Y|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|Z|8|@]|9|@$G|10|H|11|1|12]]|A|$]]|$1|I|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|J|3|C|5|6|7|14|8|@]|9|@]|A|$]]|$1|K|3|E|5|F|7|15|8|@]|9|@$G|16|H|17|1|18]]|A|$]]|$1|L|3|C|5|6|7|19|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T|U|-4]]|V|$5|P|Q|R|A|$S|W|U|-4]]]]

for IntelliJ IDEA 2017.3 you can disable sql inspections:
File | Settings | Inspections | SQL

<a href="https://i.stack.imgur.com/sCnh7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sCnh7.png" alt="enter image description here"></a>

<a href="https://i.stack.imgur.com/sRoE5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/sRoE5.png" alt="turn off sql inspections"></a>

blocks|key|307204|text|通常我只是把我的光标放在错误的右边，这样灯泡就会出现。他们按下alt-enter，然后按向右箭头。弹出的另一个菜单提供了各种抑制选项。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|307205|我不完全确定这会让你在全球范围内抑制所有的警告，但你通常会相当快地摆脱那些困扰你的警告。|307206|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Usually I just put my cursor to the right of the error so the lightbulb appears. Them press alt-enter and then arrow-right. Another menu pops up that provides various supression options. 

I'm not totally sure this will let you supress all the warnings globally, but you usually get rid of the ones that are troubling you fairly quickly.

blocks|key|2215001|text|在2018.2社区版中不再存在。“检验”部分下没有SQL。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2215002|在这里找到一张罚单：|2215003|https://intellij-support.jetbrains.com/hc/en-us/community/posts/206751355-Database-navigator-plugin-generates-errors|offset|length|2215004|似乎还没有解决方案。我使用的是DB+navigator+3.1。|2215005|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|38|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@$F|T|G|U|1|V]]|A|$]]|$1|H|3|I|5|6|7|W|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|E]]]]

No longer exists in 2018.2 Community Edition. No SQL under "Inspection" part. 

Found a ticket here:

<a href="https://intellij-support.jetbrains.com/hc/en-us/community/posts/206751355-Database-navigator-plugin-generates-errors" rel="nofollow noreferrer">https://intellij-support.jetbrains.com/hc/en-us/community/posts/206751355-Database-navigator-plugin-generates-errors</a>

Seems no solution yet. I am with DB navigator 3.1.

Does anyone know how I turn off the SQL validation in Intellij IDEA 9?

We often have more than one connection to a different type of database within one class. IntelliJ only allows one SQL dialect per class, resulting in what IntelliJ thinks are errors, so litters my code with red lines. 

Ideally I'd just like to turn the errors off completely, as they are distracting and not actually real errors.

SQL validation in IntelliJ IDEA: How to turn it off?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋 

腾讯云代码助手

CODING DevOps

Cloud Studio

SDK中心

API中心

命令行工具

有人知道我是如何关闭Intellij IDEA 9中的SQL验证的吗？我们通常在一个类中有多个到不同类型数据库的连接。IntelliJ只允许每个类使用一种SQL方言，这导致了IntelliJ认为是错误的结果，因此我的代码中到处都是红线。理想情况下，我只想完全关闭错误，因为它们会分散注意力，而不是真正的错误。

问IntelliJ IDEA中的SQL验证:如何关闭它？
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问IntelliJ IDEA中的SQL验证:如何关闭它？EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问IntelliJ IDEA中的SQL验证:如何关闭它？
EN