Hi,

The mapping file for hibernate has the following for a db column.
<column name="ACCNO" length="9" not-null="true" unique="true" sql-type="DECIMAL"/>

this is one of the primary key for my fetch. The value is set in Hibernate prepared statements is 1036479002, but the hibernate Query execution automatically runs the query for 36479002 against the DB.

While I try the query with number 1136479002, the query doenst truncate the numbers.

The generated primary class for this propery is
/**
* @hibernate.property
* name="Accno"
* type="java.math.BigDecimal"
* @hibernate.column
* name="ACCNO"
* length="9"
* not-null="true"
* unique="true"
* sql-type="DECIMAL"
*/

I will be gald to get some help in resolving this issue.

Thanks & Regards,
Pavithra

can you post with some more details of your mapping(pk details)

The length of the account number field in the table is 9. And it is a DB2 database. It's type is Decimal.

Hope this helps. Could you please be specific of the details you are looking for.

Including some details from the log
12:32:57,108 DEBUG Loader:1742 - bindNamedParameters() 1018773107 -> accountNumber [2]
12:32:57,108 DEBUG BigDecimalType:79 - binding '1018773107' to parameter: 2
12:32:57,421 DEBUG AbstractBatcher:327 - about to open ResultSet (open ResultSets: 0, globally: 0)
12:32:57,421 DEBUG Loader:682 - processing result set
12:32:57,421 DEBUG Loader:687 - result set row: 0
12:32:57,421 DEBUG BigDecimalType:123 - returning '18773107' as column: ACCNO22_0_

In the above log the Returned BigDecimalType doesnt return the value of Account number as 1018773107 but as 18773107.

The same happens when I set the account number as 11018773107.

For a decimal if of length 9, if the leftmost 9th element is 0 this problem occurs. I will appretiate any help to resolve this issue.