Hi,

I am using Hibernate 2.1.12 with MySQL 4.0.20d. In the past I have used SAPDB and it has been easy enough to use Boolean. But due to the lack of a Boolean type in MySQL, I was wondering if going with Bit as the MySQL data type and java.lang.Boolean as the mapping type would cause any problems. I am NOT using Middlegen. I would prefer not to use primitives in my POJOs. Any suggestions are greatly appreciated.

If this topic has been discussed at great lengths in the past, please point me to the right discussion. I have been trying to find a discussion but have drawn a blank so far. Same for Google.

TIA

I am successfully using this tag with MySQL 4.0.15:

Schemaupdate maps that to a tinyint with a length of 1. It sticks a "1" in the DB for true values. I don't have any false values right now, but I'd guess you'd get a "0".

Actually I saw a post from someone else in the forum who said that he is only getting 0s for tinyint, which is another reason I was unsure. Have you tried doing
<property name="locked" type="java.lang.Boolean"/>

I have not had cause to try a Boolean, just the primitive. Sorry.[/quote]

[/quote]

I just read the Appendix for "Hibernate: A Developer's Notebook" on Safari and it says the following.

Type class Boolean
Type name boolean
SQL type BIT
Notes A basic type

So I guess I am going to have to try out BIT with java.lang.Boolean and see what it does. If anyone has already tried it, please let me know. Thanks in advance.

Well, I tried using BIT as the data type and java.lang.Boolean as the type in the Hibernate mapping and even when I implicitly passed in new Boolean(true) into the object to saveOrUpdate() it stored a 0 to the Bit. Any ideas how I could solve this problem? Do I have to use a TINYINT instead of a BIT. If so, do I need to make the TINYINT(1) or will using the 8-bit signed value still work for java.lang.Boolean?

TIA

Sorry all for this mess. I was using an antiquated MySQL Driver that came with my Resin distro. I just got the latest driver from the mysql site and it works fine now.