[jboss-jira] [JBoss JIRA] Commented: (JBPM-443) JPBM does not work with MySQL 5.0

[Chris OBrien (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPM-443?page=comments#action_12341521 ] 
            
Chris OBrien commented on JBPM-443:
-----------------------------------

I ran into the same issue here, using the default jBPM 3.1.2 mappings, and MySQL 5.0.24.
The bit columns had an empty string.

When I changed the column in MySQL from BIT to SMALLINT, the problem fixed itself.  Actually, the data that was previously entered, and not showing up when it was a BIT column, was then properly displayed (in MySQL query browser) after changing to a SMALLINT.

Perhaps a bug in MySQL 5 itself?

> JPBM does not work with MySQL 5.0
> ---------------------------------
>
>                 Key: JBPM-443
>                 URL: http://jira.jboss.com/jira/browse/JBPM-443
>             Project: JBoss jBPM
>          Issue Type: Bug
>          Components: Core Engine
>    Affects Versions: jBPM 3.0, jBPM 3.1, jBPM 3.0.1, jBPM 3.0.2, jBPM 3.0.3, jBPM 3.2 alpha 1, jBPM 3.1.1,  jBPM 3.1.2, jBPM 3.0.4
>         Environment: Windows XP, Mysql 5.0 beta2, JBPM 3.0
>            Reporter: Ravi Prakash Reddy Ummadi
>         Assigned To: Tom Baeyens
>
> When JBPM is used with MySQL 5.0, the process is skipping the intermediate steps in the process definition.
> The behaviour is unpredictable. The same works fine with MySQL 4.1 and other databases.
> The problem may be in DB scripts ( DB scrips run fine though) or .hbm.xml files .

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