Congratulations. Luckily the hard work paid of.
2008/11/9, Thomas Diesler <thomas.diesler(a)jboss.com>:
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
_______________________________________________
jbpm-dev mailing list
jbpm-dev(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jbpm-dev