I am usig Oracle9i Release 2 database and latest jdbc driver for that, ojdbc14.jar. I am using Middlegen to generate the Mapping files.

Problem is, Middlegen map all the columns of type NUMBER to java.math.BigDecimal. I want to map some columns to Integer.
I know you can change the java type manually in the GUI. But I have lot of tables with lot of columns in it which I want to be Integer. Is there any way for Middlegen to generate the mapping for NUMBER column type to Integer automatically? I have tried changing the precision and scale to (10,0) etc. but it still generate the java type to BigDecimal.

Thanks

I have added this type of facility to the TODO list. For the moment, I suggest you edit the preferences file Middlegen creates. It stores the types etc there ready for the next time it is run.