Hibernate casts BigDecimal instead of Integer

Question

I don't know why but hibernate tries to cast BigDecimal to one of my columns. This column is definied as Decimal(3,0) in my DB2 DB. So there can't be a BigDecimal.

hbm.xml

  <composite-id name="Id" class="db2.P5Id">
   ....
    <key-property name="land" type="int">
        <column name="PFIELD1" precision="3"/>
    </key-property>
    ....
 </composite-id>

When I try to commit a query like

sf.createQuery("from P5 where type = 1 and land in (:cs)")
     .setParameterList("cs", cses, Hibernate.INTEGER).list()

I get the ClassCastException. The provided Collection only has Integer values.

stackoverflow.com/questions/2230182/…

zmf
– zmf

2010-02-25 23:05:26 +00:00
Commented Feb 25, 2010 at 23:05 — zmf
– zmf, Commented Feb 25, 2010 at 23:05

Pascal Thivent · Accepted Answer · 2010-02-25 23:02:07Z

3

This looks like the "problem" discussed in this thread and the suggested ~~fix~~workaround is to subclass the DB2Dialect:

import org.hibernate.dialect.DB2Dialect;
import java.sql.Types;

public class FixedDB2Dialect extends DB2Dialect {

    public FixedDB2Dialect() {
    super();
    registerColumnType(Types.INTEGER, "decimal($p)");
    registerColumnType(Types.NUMERIC, "decimal($p,$s)");
    registerColumnType(Types.DECIMAL, "decimal($p,$s)");
    }
}

There is maybe a Jira issue with an official patch but I couldn't find it.

edited Feb 25, 2010 at 23:02

answered Feb 25, 2010 at 15:57

Pascal Thivent

572k140 gold badges1.1k silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Matthew Flynn · Accepted Answer · 2010-02-25 16:29:44Z

1

I'm curious as to why your database was modeled to use a decimal type with 0 scale rather than an integer type? The behavior you are seeing (and the "issue" Pascal mentions) is because hibernate naturally assumes that a DECIMAL is a floating point type, and is baffled when you configure it to be an int.

Is it possible to change the datatype in db2 to SMALLINT? This would probably take up less space on the db (2 bytes rather than 3) and be more logically consistent.

If not, go with Pascal's solution.

answered Feb 25, 2010 at 16:29

Matthew Flynn

2,23819 silver badges27 bronze badges

Collectives™ on Stack Overflow

Hibernate casts BigDecimal instead of Integer

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related