[jbpm-dev] Re: Successful test of jBPM 3.3 with H2

[Thomas Diesler]

This is good work - thanks.

Did you see the wiki on

Adding a Database Axes
http://www.jboss.org/community/docs/DOC-12931

This should document how to add support for a new DB, but is probably a 
little bit outdated.

I'll help if you get stuck. The best place to discuss this is probably 
the dev forum

cheers
-thomas


Ronald van Kuijk wrote:
> Ok, some additional, even better info
> 
> H2 has an in-memory mode, test time reduces from an average of 2 minutes 
> to almost 1 minute, same test fails, a lot quicker since there is a 
> stack-overflow instead of a deadlock timeout
> 
> But.... I saw a parameter MVCC that I recognized from the ESB config. 
> Turning that param on, makes ALL tests run, really...  ALL tests.The 
> Deadlock timeouts had a major influence on the test time. With 
> persistency it is now 1.20 seconds...
> 
> Ronald
> 
> 
> On Mon, Dec 15, 2008 at 10:57 PM, Ronald van Kuijk <ronald at jbpm.org 
> <mailto:ronald at jbpm.org>> wrote:
> 
>     Guys,
> 
>     Considering all the trouble there continuously is with HSQLDB, I
>     gave it a shot to try and embed H2 in jBPM. The of my time was
>     figuring out where the <beep> all parts of the ddl/config generation
>     was put and how to create a new profile. Eventually when the tests
>     were run, only one failed in the core, the JobExecutorTest with
>     multiple threads. H2 gave a deadlock error there, but that might be
>     because of tuning, I'll try to figure that one out yet. It only took
>     H2 in embedded mode 1m45 with file persistency compared to H2 55
>     seconds in-memory (not sure there is a pure in-memory mode for H2)
> 
>     The web console for H2 btw is also nice, so for me it is a real
>     replacement for HSQLDB.
> 
>     Next is trying to figure out if the enterprise module can be tested
>     the same way... I've seen that the ESB guys run jBPM against H2
>     (they've created an mbean to start H2 the same way as HSQLDB is
>     started).
> 
>     Ronald
> 
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> jbpm-dev mailing list
> jbpm-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jbpm-dev

-- 
xxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thomas Diesler
BPM Product Lead
JBoss, a division of Red Hat
xxxxxxxxxxxxxxxxxxxxxxxxxxxx