How to map a bit field

astu18 · **Joined:** Thu Aug 09, 2007 9:50 am **Posts:** 9

Hi everybody

I am new in this forum so first of all sorry if I do something wrong.

I am also new with hibernate. I have read some tutorials and at least I have it running with a very simple application. I use hibernate 3.2, postgresql 8.1 and Eclipse 3.3 with java jdk 1.6.

My problem is that I have a bit field in my database and I want to use hibernate to set it. How can I do it? I mean, which java type should I use? I have tested with String, long, etc... but it always crashes. Any ideas?

Thanks a lot!

kochcp · **Posted:** Thu Aug 09, 2007 12:32 pm

boolean

astu18 · **Joined:** Thu Aug 09, 2007 9:50 am **Posts:** 9

Thanks for your answer.

I think I didn't explain my problem very well. I have a bit(64) column in my database. That is, a 64 length string of bits.

If I want to insert a new record in the postgresql database I must write:

Code:

INSERT INTO table (column) VALUES ('b01101000....010');

I don't know which java type is this bit(64). I have tried creating a String variable and setting it to 'b0110100..010' but it didn't work. Any ideas?

Thanks in advance.

astu18 · **Joined:** Thu Aug 09, 2007 9:50 am **Posts:** 9

No ideas?

Javaprogrammer · **Posted:** Sat Aug 11, 2007 7:35 am

Perhaps you should read this first

http://www.xaprb.com/blog/2006/04/11/bit-values-in-mysql/

saga · **Joined:** Sat Sep 08, 2007 12:44 pm **Posts:** 1

Hello,

I have the same issue of the author of this thread: I need a Hibernate mapping for the bit varying type of Postgresql. Has anyone had the same issue and found a solution? Whether bit fields are bad practice or not doesn't help me much, as I'm mapping to a database I cannot change. I'll be resorting to pure JDBC in the meanwhile...

Thanks!