IntelliJ IDEA Trick : how to detect and fix JPA / SQL defects using your IDE Inspection

By May 29, 2021
software software-technologies technologies article data design ide java management source sylvain-leroy tool

This article is taken from a discussion I had during the JUGL of Lausanne.  It describes how to enable the JPA/SQL inspections from the IDE (paid version) in order to detect database design or ORM issues.

Which IDE is supported?

This functionality is only available in the paid version of Intellij IDEA since you need the JPA Facet, its inspections, and the Datasource management.

What does this functionality offer?

How to enable the feature?

The first step, please configure a datasource for your project.

Add a datasource in IDEAJ Add a datasource in IDEAJ\

JPA/ORM in IDEA JPA/ORM in IDEA\

JPA/ORM in IDEA JPA/ORM in IDEA\

JPA/ORM in IDEA JPA/ORM in IDEA\

JPA/ORM in IDEA JPA/ORM in IDEA\

JPA/ORM in IDEA JPA/ORM in IDEA\

JPA/ORM in IDEA JPA/ORM in IDEA\

JPA Hint in Intellij IDEA JPA Hint in Intellij IDEA\