Problem mapping decimal field

fmcypriano · **Joined:** Tue Mar 13, 2007 8:26 am **Posts:** 25

Hello,

I have in my firebird database the following field: LARGURA DECIMAL(4,2)

And I mapped as follow:

Code:

private float largura;

// ...

    @Column(name = "LARGURA")
    public float getLargura() {
        return largura;
    }

    public void setLargura(float largura) {
        this.largura = largura;
    }

But I'm getting a erro message:

Quote:

Caused by: org.hibernate.HibernateException: Wrong column type: LARGURA, expected: float
at org.hibernate.mapping.Table.validateColumns(Table.java:261)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1083)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:317)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)

How do I map a decimal field using annotations?

Thanks,

kristian · **Posted:** Tue Mar 13, 2007 10:02 am

have you tried using BigDecimal?

fmcypriano · **Joined:** Tue Mar 13, 2007 8:26 am **Posts:** 25

Hi kristian,

Yes, take a look:

Code:

    @Column(name = "LARGURA", precision = 4, scale = 2)
    public BigDecimal getLargura() {
        return largura;
    }

    public void setLargura(BigDecimal largura) {
        this.largura = largura;
    }

Now the erro is:

Quote:

Caused by: org.hibernate.HibernateException: Wrong column type: LARGURA, expected: numeric(4,2)
at org.hibernate.mapping.Table.validateColumns(Table.java:261)
at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1083)
at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:116)
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:317)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1294)

The field is decimal(4,2). Why this? DECIMAL and NUMBER are incopatibles?

In hibernate.cfg.xml:

Code:

...

<property name="hbm2ddl.auto">validate</property>
...