[hibernate-issues] [Hibernate-JIRA] Commented: (HBX-729) boolean types mapped to bit in MySQL 5 not working with EJB3 in JBoss 4.0.4.GA

[Skjalg Stilson Arstad (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-729?page=comments#action_25179 ] 

Skjalg Stilson Arstad commented on HBX-729:
-------------------------------------------

I had the same problem, but it turned out it was caused by a mysql-connector for an mysql version was on the classpath alongside the right connector. Removing the pre-mysql-5 connector from the classpath fixed the issue, so this probably isn't a hibernate-bug.

> boolean types mapped to bit in MySQL 5 not working with EJB3 in JBoss 4.0.4.GA
> ------------------------------------------------------------------------------
>
>          Key: HBX-729
>          URL: http://opensource.atlassian.com/projects/hibernate/browse/HBX-729
>      Project: Hibernate Tools
>         Type: Bug

>     Versions: 3.2beta6
>  Environment: Debian
>     Reporter: Daniel Pocock

>
>
> I define a property with type="boolean" in my .hbm.xml
> The generated SQL column defaults to bit(1).  However, when using JBoss 4.0.4.GA and MySQL 5.0.22, reading the property (getXXX()) always return false
> If I force hbm2sql to generate a tinyint column, the boolean works as I would have expected:
> <column name="myColumn" sql-type="tinyint"/>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira