This is probably a simple question but my searches have not turned anything up.

I have a pre-existing oracle database where we store boolean values as 't' or 'f'. How do I map this properly in Hibernate so that the objects will utilize a boolean?

Thanks for your help.

Marcus

Did you read the documentation?

http://www.hibernate.org/hib_docs/refer ... ping-types

Yes I did, thank you for the useful reply.

Hibernate wants to store a 1 or a 0 for true or false which does not match what is needed. I need to store the boolean state as a t or an f and read it correctly.

What version of hibernate are you using?
Can you show the mapping?

Also the DDL for the table that you are talking about.

Check out net.sf.hibernate.UserType

http://www.hibernate.org/hib_docs/api/

This interface should be implemented by user-defined "types". A "type" class is not the actual property type - it is a class that knows how to serialize instances of another class to and from JDBC.

Don't know why someone wouldn't set a boolean type in a db to be a bit type or something small like that since it only has 2 values!

type="true_false"

This is in the documentation!

thank you for the responses.

While it is definitely in the documentation, the documentation on this particular subject DOES NOT say how the boolean is handled in the database based on the type setting. It just says that the setting is available.

What is it with the negativity on this forum? This is the beginner's forum is it not? I get two smart ass answers to a simple question. Perhaps you should take your life's frustrations out on someone else or go see a shrink.

Again, thank you for the answer to this simple problem.