Mapping ORACLE's NUMBER Type with Hibernate

Question

I have a table in a ORACLE 10g database with a column "kzCode NUMBER(1)".

If I try to map this with Hibernate annotations in JBOSS Server WebApp like this:

@Column(nullable=false)
private Integer kzCode;

I got an error:

org.hibernate.HibernateException: Wrong column type: kzCode, expected: integer

I also tried

@Column(nullable=false) private BigInteger kzCode;

error:

org.hibernate.HibernateException: Wrong column type: kzCode, expected:numeric(19,2)

I don't really know, what Java type to take.

Ken Gentle · Accepted Answer · 2008-12-05 14:41:30Z

1

ok, got it!

I had a wrong dialect property in persistence.xml file. Now all works fine..

Ken Gentle

13.4k2 gold badges44 silver badges49 bronze badges

answered Dec 5, 2008 at 14:19

mahdia

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

Comments

Paul Croarkin · Accepted Answer · 2008-12-05 14:03:17Z

0

@Column(nullable=false)
private Boolean kzCode;

or if you really want it to be a number, change the Oracle type to NUMBER(36, 0) and use long or Long in your Java.

answered Dec 5, 2008 at 14:03

Paul Croarkin

14.7k16 gold badges82 silver badges120 bronze badges