Unknown name value [] for enum class having multiple enums

Question

Dao Class:

@Entity
@Table( name = "test" )
public class Test {


@ManyToOne
@JoinColumn( name = "college_id", referencedColumnName = "id" )
private College college;  

@Enumerated( EnumType.STRING )
@Column( name = "gender", length = 500 )
private Gender gender;

@Enumerated( EnumType.STRING )
@Column( name = "section", length = 500 )
private Section section;
...
} 

public enum Gender {
  Male, Female;
}
public enum Section {
  A(0), B(1), C(2);
}

RepositoryClass:

List<Test> findByGender( Gender gender );
List<Test> findBySection( Section section );

If I am calling findBySection(Section.A), it's working as expected.
But If I call findByGender(Gender.MALE), it's throwing error:

InvalidDataAccessAPIUsageException: Unknown name value [] for enum class [com. .. .constants.Section]

Strange part is If I am calling, findByCollegeAndGenderNot(College clg, Gender gender) its working.

Simon Martinelli · Accepted Answer · 2019-02-16 17:12:40Z

1

I assume that you have null values in the column section in the database.

A data base column that you want to map to a Java Enum may not be nullable.

So you should check this and add a default value.

Additionally you should alter your column annotations to:

@Enumerated( EnumType.STRING )
@Column( name = "gender", length = 500, nullable = false )
private Gender gender;

@Enumerated( EnumType.STRING )
@Column( name = "section", length = 500, nullable = false )
private Section section;

answered Feb 16, 2019 at 17:12

Simon Martinelli

36.6k6 gold badges62 silver badges92 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abhishek Over a year ago

Thanks much, yes there were a few nullable fields in both the columns

Collectives™ on Stack Overflow

Unknown name value [] for enum class having multiple enums

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related