For example,

public Integer getValue() {
}

the value range is from 0 to 10.

public enum Color {
RED,
BLUE,
YELLOW
}

@Enumerated(EnumType.ORDINAL)
public Color getColor() {
}

For mysql, it is mapped to int(11).
I can use columnDefinition="smallint(2)". But it is not portable to other databases.

How to map it to a small integer type in database?

Thanks,
Dave

You should define your own type and store the value as short instead of int.
Hope this link can help you.
https://www.hibernate.org/172.html

I am wondering if the annotation "length" should apply to Integer type.
@Column(length=2)

The length is currently for string.

Thanks,
Dave