When I use the tool to create pojo files for my table it sugest the type short for any field that I have number(3) for.

But when i run that query it crashes because if the field is null, short can not be null.

Here is the exact error I get. Is this a bug? Should Number(3) in oracle 9i really be something else besides short in Java?

org.hibernate.PropertyAccessException: exception setting property value with CGLIB (set hibernate.cglib.use_reflection_o
ptimizer=false for more info) setter of org.usiis.hibernate.PatientContra.setLastUpdateSource
at org.hibernate.tuple.PojoEntityTuplizer.setPropertyValuesWithOptimizer(PojoEntityTuplizer.java:215)

did you try the wrapper class java.lang.Short?

simon