Query language checks

Reports the following errors inside Persistence QL queries:

Mismatching expression types
Incorrect parameters
Empty or constant conditions
Unresolved symbols

Example queries:

SELECT OBJECT(e) FROM JavaEntity e WHERE TRUE // Warning: constant condition

SELECT OBJECT(e) FROM JavaEntity e WHERE e.id BETWEEN 0 AND '2' // Error: expected a numeric value but got a string

SELECT e from JavaEntity e where e.id=?1 and e.name=?3 // Error: there are only 2 actual query parameters

Locating this inspection

By ID

Can be used to locate inspection in e.g. Qodana configuration files, where you can quickly enable or disable it, or adjust its settings.

JpaQlInspection

Via Settings dialog

Path to the inspection settings via IntelliJ Platform IDE Settings dialog, when you need to adjust inspection settings directly from your IDE.

Settings or Preferences | Editor | Inspections | JPA

Availability

By default bundled with: IntelliJ IDEA 2024.1, Qodana for JVM 2024.1,
Can be installed with plugin: Jakarta EE: Persistence (JPA), 241.18072

Last modified: 18 June 2024