IntelliJ cannot resolve symbol 'NULL' in JPA @Query

Question

In any @Query in a Spring Repository, IntelliJ inspection is highlighting NULL with a red underline, saying "Cannot resolve symbol 'NULL'". Note that changing the case to all lowercase doesn't to fix it. After checking similar posts I did ensure I have the JPA & Spring facets configured properly.

Note this isn't actually an issue at runtime or compile time; everything actually works fine. It's just annoying/distracting seeing the highlights in IntelliJ. Does anyone know how to resolve this, or why it is happening?

Below is a minimal example showing the issue.

I am using

IntelliJ Ultimate 2021.3.2
spring-data-jpa 2.3.4.RELEASE
openjdk 11

score 0 · Accepted Answer · answered Feb 07 '23 at 14:21

0

Seems to basically be a non-issue in newer versions of Intellij.

answered Feb 07 '23 at 14:21

kagof

522
2
12

score -3 · Answer 2 · edited Feb 12 '22 at 11:09

-3

Set the nativeQuery attribute to true, something like:

@Query(nativeQuery=true,value="")

edited Feb 12 '22 at 11:09

Tyler2P

2,324
26
22
31

answered Feb 11 '22 at 11:15

Shelton Shamuyarira

1
1

1

You cannot use nativeQuery there. The select is using JPA objects not database table names. – pringi Feb 11 '22 at 11:19
NULL keyword cannot be used when using JPA objects – Shelton Shamuyarira Feb 11 '22 at 11:28
1

Why can't NULL be used with JPA objects? The query works fine, IntellIiJ's inspection just highlights it (seemingly incorrectly) – kagof Feb 11 '22 at 11:38

IntelliJ cannot resolve symbol 'NULL' in JPA @Query

2 Answers2