Hi all,

What is hibernate mapping type for SQLServer's field type of tinyint?

Thanks,
/bernard

-From MS SQL documentation.

And the Java types that you can use (generally):

Byte: -128 to 127
Short: -32768 to 32767
Integer: -2147483648 to 2147483647

So, since SQLServer's tinyint is 0-255 (An unsigned byte), you'll have to use Short since it's the smallest Java number type that'll match.

You'll find the Hibernate type as: net.sf.hibernate.type.ShortType

Hope that helps. This isn't really a Hibernate issue, but rather a Java type vs SQL (MS) Type.

-G

Many thanks Brannor!