Hi all.. I'm new with hibernate..
I have this problem..
I have a table with composite primary key, which one of them has type of integer. it's something like this:

<class name="com.test.Budget" table="Budget">
<composite-id name="compId" class="com.test.PKBudget">
<key-property name="budgetType_" column="budget_type" type="string" length="1"/>
<key-property name="budgetYear_" column="budget_year" type="string" length="4"/>
<key-property name="bonusMonth_" type="string" column="bonus_month" length="2"></key-property> </composite-id>
<property name="bonusRate" not-null="true" type="integer">
<column name="bonus_rate" sql-type="number(3)"/>
</property>

notice that "bonusRate" and "bonusMonth" both have type of "integer".

i'd like "bonusMonth" to have type of "integer" too, but when i generate the hibernate class and call the session.save() for that object,
it always produce/insert INCORRECT value (e.g. 1 becomes 1E6),
while "bonusRate" produce/insert the CORRECT value;

changing the "bonusMonth" into String gives the expected value (i.e the CORRECT one).

has anyone has encountered such problem? please help :)
thanks a lot in advance.

regards,
Dion

Are you saying that this one fails ?

Immanuel, yes, exactly.
when "bonusMonth_" has type of "integer", it stores INCORRECT value,
when I change the type into "String" it stores CORRECT one.

thanks for responding. so what did i do wrong?
thanks a lot

regards,
Dion

Emmanuel, yes, exactly.
when "bonusMonth_" has type of "integer", it stores INCORRECT value,
when I change the type into "String" it stores CORRECT one.

thanks for responding. so what did i do wrong?
thanks a lot

regards,
Dion

I think he is rather doing something like mapping an integer type to a string column in the database. If yes, this does not work of course, without using a custom UserType.

it's not my intention.
what i'd like to do is simply having integer type both in database and in java for column "bonusMonth" (which is a part of a COMPOSITE PRIMARY KEY).

other integer type (both in database and java) stores the CORRECT value, but for "bonusMonth" it doesnt.

thanks for your help. any idea what did i do wrong?
thanks in advance.

regards,
dion

are you really using integer/int everywhere? Please show your mapping, database schema and composite-id class.

here is the mapping:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class name="com.mycompany.bs115.Gpfb115Abc" table="Gpfb115Abc">
<composite-id name="compId" class="com.mycompany.bs115.PKGpfb115Abc">
<key-property name="budgetType_" column="budget_type" type="string" length="1"/>
<key-property name="budgetYear_" column="budget_year" type="string" length="4"/>
<!--
<key-property name="bonusMonth_" type="string" column="bonus_month" length="2">
-->
<key-property name="bonusMonth_" type="integer" column="bonus_month" >
<column name="bonus_month" sql-type="number(3)"/>
</key-property>
<!-- column name="bonus_month" sql-type="number(10)"/ -->
<key-property name="locationCode_" column="location_code" type="string" length="2"/>
<key-property name="bonusType_" column="bonus_type" type="string" length="2"/>
</composite-id>
<property name="bonusRate" not-null="true" type="integer">
<column name="bonus_rate" sql-type="number(3)"/>
</property>
<property name="lastUpdateDate" column="last_update_date" type="timestamp"/>
<many-to-one name="modifiedBy_" class="com.mycompany.user.Gpfb301" column="modified_by"/>
</class>
</hibernate-mapping>


here is the database schema (generated using hibernate's schemaexport)

create table Gpfb115Abc (
budget_type VARCHAR2(1) not null,
budget_year VARCHAR2(4) not null,
bonus_month NUMBER(10,0) not null,
location_code VARCHAR2(2) not null,
bonus_type VARCHAR2(2) not null,
bonus_rate number(3),
last_update_date DATE,
modified_by VARCHAR2(10),
primary key (budget_type, budget_year, bonus_month, location_code, bonus_type)
);

and here is the PK Class (generated using hibernate's hbm2java.CodeGenerator)

public class PKGpfb115Abc implements Serializable {

/** identifier field */
private String budgetType_;

/** identifier field */
private String budgetYear_;

/** identifier field */
private int bonusMonth_;

/** identifier field */
private String locationCode_;

/** identifier field */
private String bonusType_;

/** full constructor */
public PKGpfb115Abc(String budgetType_, String budgetYear_, int bonusMonth_, String locationCode_, String bonusType_) {
this.budgetType_ = budgetType_;
this.budgetYear_ = budgetYear_;
this.bonusMonth_ = bonusMonth_;
this.locationCode_ = locationCode_;
this.bonusType_ = bonusType_;
}

// the rest of the class is not shown

bonus_month NUMBER(10,0) not null,
bonus_rate number(3),

This is a DB type issue

Umm.. sorry I forgot to mentioned that I'm using Oracle 9i.
Is it known error with hibernate..?

Here's the content of my Hibernate.properties:

hibernate.dialect=net.sf.hibernate.dialect.OracleDialect
hibernate.show_sql=true
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver

and here's the way I set the value
PKGpfb115Abc pk = new PKGpfb115Abc();
pk.setBudgetType_("O");
pk.setBudgetYear_("2003");
pk.setBonusType_("L");
pk.setBonusMonth_(3); // this is the error

tx = session.beginTransaction();
session.save(hib);
session.flush();
tx.commit();

the value 3 becomes 1.42E80 in the first try , -6.6E-79 in the second try...
(consistently generate different values).

thanks a lot in advance.

regards,
Dion

You're using NUMBER(10,0) and set number(3) in Hibernate => oracle convert your number.
Try to set NUMBER(3) in DB.

Emmanuel, I did the following:
- alter table gpfb115Abc modify bonus_month number(3);
- commit;

then I set using setBonusMonth_(3)
it stores 6.9000E-29

setBonusMonth(5)
it stores -1.000E+50

I'm scratching my head... any idea why?
Thanks a lot .

regards,
Dion

btw, executing direct insert statement gives the expected value like this
INSERT INTO GPFB115ABC (budget_type, budget_year, bonus_month, location_code, bonus_type, bonus_rate, last_update_date, modified_by)
VALUES ('U', '2003', 5, 'L', 'T', 8, SYSDATE, 'user')

regards,
Dion

Try enabling sql and bind parameter logging - what does Hibernate generate and bind?

How to do that, gloeglm?
Looking at the hibernate doc (the pdf one), I could only think of
hibernate.show_sql=true
Thanks.

regards,
Dion