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

[Ronald van Kuijk (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPM-443?page=comments#action_12340771 ] 
            
Ronald van Kuijk commented on JBPM-443:
---------------------------------------

ok, thanks for finding this. Now we at least have a workaround and pinpointed this. I thought I had 5.0.x but it turned out to be the client version. Shame on me. I run 4.1.x

So there is at least the workaround to define the SQL-Type=Boolean as described in the above link, but maybe adding something to the connectionstring also works: 

jdbc:mysql://localhost:3306/database?transformedBitIsBoolean=true



> 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