i have a DB2 database with the following types in it

CHAR, SMALLINT, DATE, DEC(11,0)

what do i need to use in the mapping file for type="" and what java types should i use, right now i have most of the java variables as strings or calendar objects...

??????

I would use

String for CHAR
int for SMALLINT
java.util.Date from DATE
and BigDecimal for DEC


I'd have a try of not defining type in the mappings since hibernate is pretty good at guessing the right type.

I cant try it right here since I don't have DB2 on my Mac.