SQL validation in IntelliJ IDEA: how to disable it?

Question

Does anyone know how to disable SQL validation in Intellij IDEA 9?

We often have multiple connections to another type of database in the same class. IntelliJ only allows one SQL dialect for each class, which causes IntelliJ to consider errors, so it puts my code with red lines.

Ideally, I would just like to completely disable errors, as they are distracting, not real errors.

Answer 1

Settings> Inspections. Deselect "SQL". Alternatively, you can place the cursor on the error and press alt + enter. One option: "Turn off verification."

Answer 2

= , i.E.

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

. https://www.jetbrains.com/idea/help/using-language-injections.html

Answer 3

Usually I just put the cursor to the right of the error so that a light appears. They press alt-enter, and then the right arrow. Another menu appears that provides various suppression options.

I'm not quite sure that this will allow you to suppress all warnings around the world, but you usually get rid of those that worry you pretty quickly.