Set Intellij IDEA JPA Console naming strategy

Question

I have an all-default (excepts Lombok) Spring Boot 2.5.6 + PostgreSQL project with a very basic JPA mapping open in Intellij IDEA 2021.2.3. JPA configuration is implemented with annotations (no XML). The app itself works fine, records get saved and retrieved from the DB. In "Persistence" window I can see my JPA structure correctly, datasource is assigned. Here is the entity code:

@Entity
@Data
...
public class Cover {
...
private String ageRestriction;
}

But when I try to execute a query with e.g. select c from Cover c I get an error:

jpa-ql> select c from Cover c
[2021-11-01 16:14:03] [42703] ERROR: column cover0_.agerestriction does not exist
[2021-11-01 16:14:03] Hint: Perhaps you meant to reference the column "cover0_.age_restriction".

I tried to add the naming strategy configuration to my settings but this had no effect:

spring:
  jpa:
    hibernate:
      naming:
        physical-strategy: org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy
        implicit-strategy: org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy

I don't see "Assign naming strategy" in the persistence unit context menu as well (see screenshot). Is there a way to force JPA Console to use the same naming strategy my app does?

PS: I've managed to make the console work after specifying @Column for all multi-word field names and adding @Table annotation with schema and name properties. But I would prefer to be able to sync console and app JPA/Hibernate configurations somehow.

Set Intellij IDEA JPA Console naming strategy

0 Answers