Hello:
I am using Hibernate tools 3.2 Eclipse plugin.

I have some data fields of type 'numeric' in a databse table. There is a rule states that the field value is either '1' or '0'.
Hibernate generation tool sets the type of those fields to boolean.

Can some explain to me why Hibernate using 'boolean' instead of 'numeric'?

Thanks

there is no java nor hibernate type called 'numeric' and if your numeric is of length 1 then it maps perfect to a boolean, right?

So, what you saying is that Hibernate will convert the boolean value to numeric when persisting an object?

did you try it before assuming it wont work ?

your jdbc driver should do the job for you in this case.

I did not assume it won't work. I would try it if I could. We are in the early stages of a new project. The database is being modoled, and I am learing Hibernate.
After I used Hibernate tools (defualt configurations) to generate the Beans and the mapping files, I noticed that the 'numeric' type was substitued by 'boolean'. I couldn't find any relevent information in the reference manual. So, I thought to join the forum and maybe I find someone who can explain what has happened behind the scene.

numeric with length 1 is a comon way of modelling boolean on dbs that does not have a boolean type

I think you need to read the question carefully..!

question: "I have some data fields of type 'numeric' in a databse table. There is a rule states that the field value is either '1' or '0'.
Hibernate generation tool sets the type of those fields to boolean."

answer(s):there is no java nor hibernate type called 'numeric' and if your numeric is of length 1 then it maps perfect to a boolean. numeric with length 1 is a comon way of modelling boolean on dbs that does not have a boolean type

What are am I missing ?