Query language checks

Last modified: 03 December 2024

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

Inspection Details

By default bundled with:

IntelliJ IDEA 2024.3, Qodana for JVM 2024.3,

Can be installed with plugin:

Jakarta EE: Persistence (JPA), 243.23126