[jbpm-dev] Status jbpm-3.3.0.GA and sybase

Folks, I'm happy to announce that we had a successful QA Matrix run on Sybase. http://jbpm.dyndns.org:8280/hudson/job/jBPM3-ShortMatrix/8/ This has been possible with the help of Alejandro and Tom who worked with me during the long night shifts over the weekend. Now to the details and limitations: We installed ASE-15.0.2 Developer Edition with EBF15682 and EBF15962 http://www.jboss.org/community/docs/DOC-12932 The tests run with the jConnect version that comes with EBF15962. This jar is not part of the distribution and we currently have a hard coded system dependency on the driver. # [JBPM-1820] Replace proprietary sybase driver with OS alternative SYBASE_JDBC_DRIVER=/opt/sybase/ase1502dev/shared/lib/jconn3.jar The jConnect driver does not support CLOB which is the SQL data type for hibernate type="text". I created special sybase hibernate mappings for sybase [tdiesler@tdvaio trunk]$ find . -name "*sybase.hbm.xml" ./modules/core/target/classes/org/jbpm/context/log/variableinstance/StringUpdateLog.sybase.hbm.xml ./modules/core/target/classes/org/jbpm/context/exe/variableinstance/JcrNodeInstance.sybase.hbm.xml ./modules/core/target/classes/org/jbpm/context/exe/variableinstance/StringInstance.sybase.hbm.xml ./modules/core/target/classes/org/jbpm/job/Job.sybase.hbm.xml ... which are then concatenated into hibernate.cfg.sybase.xml Various core tests have been excluded. This documents what functionality is not supported on Sybase using the current setup. https://jira.jboss.org/jira/browse/JBPM-1824 <!-- [JBPM-1824] Investigate core test failures against Sybase --> <exclude>org/jbpm/db/DeleteProcessInstanceDbTest.java</exclude> <exclude>org/jbpm/graph/exe/SubProcessPlusConcurrencyDbTest.java</exclude> <exclude>org/jbpm/jbpm1072/JBPM1072Test.java</exclude> <exclude>org/jbpm/jbpm1755/JBPM1755Test.java</exclude> <exclude>org/jbpm/jbpm983/JBPM983Test.java</exclude> <exclude>org/jbpm/job/executor/JobExecutorDbTest.java</exclude> <exclude>org/jbpm/optimisticlocking/LockingTest.java</exclude> <exclude>org/jbpm/scheduler/exe/UnsafeSessionUsageTest.java</exclude> <exclude>org/jbpm/seam/JobExecutorCustomizationTest.java</exclude> The ASE-15.0.2 Develper Edition does not support XA Transactions https://jira.jboss.org/jira/browse/JBPM-1824 As a result, <local-tx-datasource> has been used and the bulk of enterprise tests needed to be excluded <!-- [JBPM-1818] Use Sybase instance that supports XA Transaction --> <exclude>org/jbpm/scheduler/ejbtimer/EjbSchedulerTest.java</exclude> <exclude>org/jbpm/persistence/jta/JtaDbPersistenceTest.java</exclude> <exclude>org/jbpm/msg/jms/JmsMessageTest.java</exclude> AFAIC, we can release 3.3.0.GA on Monday,11-Nov as promised. The release would however have the documented limitations described above. We would then work on an SP1 to come out shortly after. Alejandro has done work with the open source jtds driver, which apparently supports type="text" and might overcome some of the above limitations. This work is still in progress and can now continue from a functional baseline as reported by Hudson. cheers -thomas -- xxxxxxxxxxxxxxxxxxxxxxxxxxxx Thomas Diesler BPM Product Lead JBoss, a division of Red Hat xxxxxxxxxxxxxxxxxxxxxxxxxxxx