Hibernate version: 2.0
Middlegen-Hibernate version: R-5
Name and version of the database you are using:Oracle 9i
The generated SQL (show_sql=true):True

Hi,.. I Just got some problem from XBM Generated by Middlegen,

In the oracle table description look like this :

SQL> desc systlogin;
Name Null? Type
----------------------------------------- -------- ---------------------------
SYSTLOGIN_PK NOT NULL NUMBER(38)
SYSTROLE_FK NUMBER(38)
CUSTOMER_FK NUMBER(38)
LOGINID NOT NULL VARCHAR2(10)
NAMA VARCHAR2(50)
ATASAN NUMBER(38)
PASSWORD VARCHAR2(20)
LANGUAGE VARCHAR2(2)

Look at this,..
SYSTLOGIN_PK NOT NULL NUMBER(38) <--- its was Integer in Oracle PL/SQL


The Question is : WHY everytime i try to generate XBM from this table its produce UNEXPECTED type of Data, Middelegen will produce XBM type data to BIGDECIMAL..In this case i want Middlegen to produce SYSTLOGIN_PK type data to INTEGER

Systlogin.xbm.xml similar look like this :

<class
name="com.latih.db.Systlogin"
table="SYSTLOGIN"
>

<id
name="systloginPk"
type="java.math.BigDecimal"
column="SYSTLOGIN_PK"
>
<generator class="native" />
</id>

Anyone can figure me out ? Thanks,..

Middlegen is deciding that you need to use a BigDecimal to reliably store the (potentially large) integer value. You can tell it what type you want to use by selecting it in the GUI and you can supply your own custom type mapper so that defaults are how you expect them to be mapped.