Display ORACLE NUMBER Hibernate type

Question

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

".

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

@Column(nullable=false)
private Integer kzCode;

An error appeared:

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

I have also tried

@Column(nullable=false) private BigInteger kzCode;

mistake:

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

I really don't know which type of Java to take.

0

mahdia 05 dec. '08 at 13:53

2 answers

mahdia · Answer 1 · 2008-12-05T14:19:03+0000

OK, it worked!

I had the wrong dialect property in the persistence.xml file. Everything is working fine now.

Paul croarkin · Answer 2 · 2008-12-05T14:03:17+0000

@Column(nullable=false)
private Boolean kzCode;

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