I like to persist a enum list type to a String. For example,

public enum Color {
BLACK,
WHITE,
YELLOW
}

public class MyEntity {

public List<Color> getColors();

}

For colors of BLACK and WHITE, it is persisted as string "BLACK,WHITE".

public class ColorListUserType implements UserType {
....
}

I have two questions:

1. how to tell Hibernate to use the ColorListUserType for the property "colors"?

2. how to write a query to search entities that has BLACK color?

From MyEntity e where Color.BLACK in e.colors
make sense?

Thanks very much for help.
Dave

I found the answer to the Q1.
Use @Type(type="ColorListUserType").

But I still can not figure out Q2: how to query if a Enum List contains a enum value.

Thanks.

2 is not really possible I think, except if you use like %BLACK% of if you use Hibernate Search to achieve the same result