[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

[Wolf-Dieter Fink (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/HBX-729?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=31091#action_31091 ] 

Wolf-Dieter Fink commented on HBX-729:
--------------------------------------

I have a similar problem using JavaApplication with JPA.
The Table is not usable even if it is created by hibernate itself.
see http://forum.hibernate.org/viewtopic.php?t=990299

> 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
>          Issue Type: Bug
>    Affects 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