If you are using the JBOSS 3.x Version and trying to map at an existing DB-Table you have to specify the mapping at the 'jbosscmp-jdbc.xml'. Or you can change the mappingtypes at the standardjbosscmp-jdbc.xml'.
Thanks for the reply bjs. However, I am using JBoss 2.4.4 and soon we will be upgrading to 2.4.6 - Not sure when 3.0 will happen.
Anyhow, given that I have a NUMBER(2) field in the database, what java.lang.* type should I be reading this into? That's the crux of the question I think.
I have tried changing the DB field to a NUMBER(3) and then reading it into a java.lang.byte, but this does not work either!! Any help would be much appreciated....
Use java premitive int for your case, it would work. There is one more option , you can make use of the jaws.xml file where you can exactly specify the maping between jdbc type and the oracle data type..I am attching an working file ..i hope it helps you..