Using enum property value in query annotation

[mark smith]

hi

i use spring boot 2.3.2 with spring data and hibernate.

I have a Enum

public enum CharacterType{
    TROLL(1),
    MAGICIAN(2);
    
    private final int id;
    
    CharacterType(int id){
    this.id=id;
    
    public int getId(){
        return id;
    }
    
}

I have an enitty

public class Enemy{
    int id;
    int characterType;
}

In my repository i tried theses solutions without success

@Query(value="select e from Enemy e where e.characterType=com.oryx.constant.CharacterType.TROLL.id"
public List<Enemy> getEnemy();

@Query(value="select e from Enemy e where e.characterType=com.oryx.constant.CharacterType.TROLL.getId()"
public List<Enemy> getEnemy();

@Query(value="select e from Enemy e where e.characterType=:#{T(com.oryx.constant.CharacterType).TROLL.getId()}"
public List<Enemy> getEnemy();

@Query(value="select e from Enemy e where e.characterType=:#{T(com.oryx.constant.CharacterType).TROLL.id}"
public List<Enemy> getEnemy();

If I do like that that working

@Query(value="select e from Enemy e where e.characterType=1"
public List<Enemy> getEnemy();

I see some thread like this one: https://stackoverflow.com/questions/63060484/enum-in-query-get-invalid-expression who have similar issue.


thanks

[Tim Holloway]

Nothing to do with Spring Boot, and if you're using Hibernate JPA with Spring Data, even the "Hibernate" part doesn't really matter, because it's a JPA thing.

Look here: https://tomee.apache.org/examples-trunk/jpa-enumerated/

The big problem with enumerations is that most databases don't support enumerations as a basic field type. So the JPA layer has to bridge the difference, and that's what the above mechanism is for.