Hi all,

The problem is this: Oracle tables with NUMBER datatype columns are migrated into DB2 as DECIMAL.

BUT

The Java application (Eclipse and Weblogic) processing the db data expects an integer value from DB2 but receives a decimal datatype instead, which causes the application malfunction.

Is there a way (if any) to workaround this problem, so that the Java application receives an integer from DB2 that can process the way it has been doing all along with Oracle?

EXAMPLE
=======

SELECT IN ORACLE
================================================
SQL> select id_parametro from gims.tm_parametro;

ID_PARAMETRO
1
2
3
4
6

SQL>

SAME SELECT IN DB2
================================================
$ db2 select id_parametro from gims.tm_parametro

ID_PARAMETRO
1.
2.
3.
4.
6.

But the java application expects integer values such as 1 2 3 4 5 not decimals like 1. or 1.0 etcetera

How can we fix this ?? Is there a configuration file in which we could map datatypes between DB2 and Java? I have thought of revenge.xml but need confirmation since I'm not a Java expert.

Thanks in advance,

Raul Baron

True, reveng.xml is your solution. Please have a look to https://www.hibernate.org/hib_docs/tool ... ering.html : the <type-mapping> tag is what you are looking for.

OK Jkronegg. Thank you very much. This gives me a precious reference.

Thanks again for your help

BRGDS,

Raul Baron