On Fri, Dec 2, 2011 at 1:41 PM, Christian Müller <christian.muel...@gmail.com> wrote: > If I execute the test with H2, the "testMixedCommit" test still fail, > "testMixedRollbackOnlyLast" passed. > If I execute the test with Derby, both tests passed. > > Is there a good reason to use three different in memory databases for our > tests (Is there a functionality which is not supported by the others?)? Or > was it "only" the preference from the guy who developed this component? > If there is no good reason for it, I suggest to consolidate the databases > we use. I would choose Derby because of this issue. And I will be more > carefully than in my last commits... ;-) > > Sounds good for you? >
Yeah there is no special reason as I recall for using one embedded DB than the other. I just think hsqldb has historically been an embedded DB for a very long time, and thus something people back then was familiar with using. > Best, > Christian > > On Fri, Dec 2, 2011 at 12:55 PM, Christian Müller < > christian.muel...@gmail.com> wrote: > >> I checked this also. >> >> When the Spring JDBCTemplate calls "ps.executeUpdate()" in Line 817, the >> call blocks forever (dead lock). After downgrading to 1.8.0.10, the test >> passed again. Thinking about a solution... >> >> >> Best, >> Christian >> >> On Thu, Dec 1, 2011 at 10:42 PM, Hadrian Zbarcea <hzbar...@gmail.com>wrote: >> >>> Christian, >>> >>> I think this upgrade broke the trunk, camel-spring in particular. It is >>> quite likely that it uncovered a problem in Camel. Looking into it. >>> >>> Cheers, >>> Hadrian >>> >>> >>> >>> On 11/29/2011 06:35 PM, cmuel...@apache.org wrote: >>> >>>> Author: cmueller >>>> Date: Tue Nov 29 23:35:08 2011 >>>> New Revision: 1208138 >>>> >>>> URL: >>>> http://svn.apache.org/viewvc?**rev=1208138&view=rev<http://svn.apache.org/viewvc?rev=1208138&view=rev> >>>> Log: >>>> CAMEL-4726: Upgrade org.hsqldb:hsqldb 1.8.0.10 -> 2.2.6 >>>> >>>> Modified: >>>> camel/trunk/components/camel-**bam/pom.xml >>>> camel/trunk/components/camel-**ibatis/pom.xml >>>> camel/trunk/components/camel-**jdbc/pom.xml >>>> camel/trunk/components/camel-**mybatis/pom.xml >>>> camel/trunk/components/camel-**spring/pom.xml >>>> camel/trunk/components/camel-**sql/pom.xml >>>> camel/trunk/examples/camel-**example-bam/pom.xml >>>> camel/trunk/examples/camel-**example-etl/pom.xml >>>> camel/trunk/examples/camel-**example-tracer/pom.xml >>>> camel/trunk/parent/pom.xml >>>> camel/trunk/tests/camel-itest/**pom.xml >>>> >>>> Modified: camel/trunk/components/camel-**bam/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/components/camel-** >>>> bam/pom.xml?rev=1208138&r1=**1208137&r2=1208138&view=diff<http://svn.apache.org/viewvc/camel/trunk/components/camel-bam/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/components/camel-**bam/pom.xml (original) >>>> +++ camel/trunk/components/camel-**bam/pom.xml Tue Nov 29 23:35:08 2011 >>>> @@ -116,7 +116,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> - <groupId>hsqldb</groupId> >>>> + <groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> @@ -222,7 +222,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> - <groupId>hsqldb</groupId> >>>> + <groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> @@ -303,7 +303,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> - <groupId>hsqldb</groupId> >>>> + <groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> >>>> Modified: camel/trunk/components/camel-**ibatis/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/components/camel-** >>>> ibatis/pom.xml?rev=1208138&r1=**1208137&r2=1208138&view=diff<http://svn.apache.org/viewvc/camel/trunk/components/camel-ibatis/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/components/camel-**ibatis/pom.xml (original) >>>> +++ camel/trunk/components/camel-**ibatis/pom.xml Tue Nov 29 23:35:08 >>>> 2011 >>>> @@ -54,7 +54,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> >>>> Modified: camel/trunk/components/camel-**jdbc/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/components/camel-** >>>> jdbc/pom.xml?rev=1208138&r1=**1208137&r2=1208138&view=diff<http://svn.apache.org/viewvc/camel/trunk/components/camel-jdbc/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/components/camel-**jdbc/pom.xml (original) >>>> +++ camel/trunk/components/camel-**jdbc/pom.xml Tue Nov 29 23:35:08 2011 >>>> @@ -63,7 +63,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> >>>> Modified: camel/trunk/components/camel-**mybatis/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/components/camel-** >>>> mybatis/pom.xml?rev=1208138&**r1=1208137&r2=1208138&view=**diff<http://svn.apache.org/viewvc/camel/trunk/components/camel-mybatis/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/components/camel-**mybatis/pom.xml (original) >>>> +++ camel/trunk/components/camel-**mybatis/pom.xml Tue Nov 29 23:35:08 >>>> 2011 >>>> @@ -54,7 +54,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> >>>> Modified: camel/trunk/components/camel-**spring/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/components/camel-** >>>> spring/pom.xml?rev=1208138&r1=**1208137&r2=1208138&view=diff<http://svn.apache.org/viewvc/camel/trunk/components/camel-spring/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/components/camel-**spring/pom.xml (original) >>>> +++ camel/trunk/components/camel-**spring/pom.xml Tue Nov 29 23:35:08 >>>> 2011 >>>> @@ -160,7 +160,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> >>>> Modified: camel/trunk/components/camel-**sql/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/components/camel-** >>>> sql/pom.xml?rev=1208138&r1=**1208137&r2=1208138&view=diff<http://svn.apache.org/viewvc/camel/trunk/components/camel-sql/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/components/camel-**sql/pom.xml (original) >>>> +++ camel/trunk/components/camel-**sql/pom.xml Tue Nov 29 23:35:08 2011 >>>> @@ -76,7 +76,7 @@ >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> - <groupId>hsqldb</groupId> >>>> + <groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <scope>test</scope> >>>> </dependency> >>>> >>>> Modified: camel/trunk/examples/camel-**example-bam/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/examples/camel-** >>>> example-bam/pom.xml?rev=**1208138&r1=1208137&r2=1208138&**view=diff<http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-bam/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/examples/camel-**example-bam/pom.xml (original) >>>> +++ camel/trunk/examples/camel-**example-bam/pom.xml Tue Nov 29 >>>> 23:35:08 2011 >>>> @@ -88,7 +88,7 @@ >>>> <artifactId>hibernate</**artifactId> >>>> </dependency> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> </dependency> >>>> <dependency> >>>> >>>> Modified: camel/trunk/examples/camel-**example-etl/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/examples/camel-** >>>> example-etl/pom.xml?rev=**1208138&r1=1208137&r2=1208138&**view=diff<http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-etl/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/examples/camel-**example-etl/pom.xml (original) >>>> +++ camel/trunk/examples/camel-**example-etl/pom.xml Tue Nov 29 >>>> 23:35:08 2011 >>>> @@ -71,7 +71,7 @@ >>>> </dependency> >>>> >>>> <dependency> >>>> - <groupId>hsqldb</groupId> >>>> + <groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> </dependency> >>>> <dependency> >>>> @@ -289,7 +289,7 @@ >>>> <version>1.2.0</version> >>>> </dependency> >>>> <dependency> >>>> - <groupId>hsqldb</groupId> >>>> + <groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> </dependency> >>>> </dependencies> >>>> >>>> Modified: camel/trunk/examples/camel-**example-tracer/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/examples/camel-** >>>> example-tracer/pom.xml?rev=**1208138&r1=1208137&r2=1208138&**view=diff<http://svn.apache.org/viewvc/camel/trunk/examples/camel-example-tracer/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/examples/camel-**example-tracer/pom.xml (original) >>>> +++ camel/trunk/examples/camel-**example-tracer/pom.xml Tue Nov 29 >>>> 23:35:08 2011 >>>> @@ -68,7 +68,7 @@ >>>> <artifactId>hibernate</**artifactId> >>>> </dependency> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> </dependency> >>>> <dependency> >>>> >>>> Modified: camel/trunk/parent/pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/parent/pom.xml?** >>>> rev=1208138&r1=1208137&r2=**1208138&view=diff<http://svn.apache.org/viewvc/camel/trunk/parent/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/parent/pom.xml (original) >>>> +++ camel/trunk/parent/pom.xml Tue Nov 29 23:35:08 2011 >>>> @@ -88,7 +88,7 @@ >>>> <hazelcast-version>1.9.3</**hazelcast-version> >>>> <hibernate-version>3.2.6.ga</**hibernate-version> >>>> <hibernate-entitymanager-**version>3.2.1.ga</hibernate-** >>>> entitymanager-version> >>>> -<hsqldb-version>1.8.0.10</**hsqldb-version> >>>> +<hsqldb-version>2.2.6</**hsqldb-version> >>>> <httpunit-version>1.6.2</**httpunit-version> >>>> <httpcore4-version>4.1.2</**httpcore4-version> >>>> <httpclient4-version>4.1.2</**httpclient4-version> >>>> @@ -1368,7 +1368,7 @@ >>>> <version>${derby-version}</**version> >>>> </dependency> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> <version>${hsqldb-version}</**version> >>>> </dependency> >>>> >>>> Modified: camel/trunk/tests/camel-itest/**pom.xml >>>> URL: http://svn.apache.org/viewvc/**camel/trunk/tests/camel-itest/** >>>> pom.xml?rev=1208138&r1=**1208137&r2=1208138&view=diff<http://svn.apache.org/viewvc/camel/trunk/tests/camel-itest/pom.xml?rev=1208138&r1=1208137&r2=1208138&view=diff> >>>> ==============================**==============================** >>>> ================== >>>> --- camel/trunk/tests/camel-itest/**pom.xml (original) >>>> +++ camel/trunk/tests/camel-itest/**pom.xml Tue Nov 29 23:35:08 2011 >>>> @@ -186,9 +186,8 @@ >>>> >>>> <!-- some TX tests using iBatis --> >>>> <dependency> >>>> -<groupId>hsqldb</groupId> >>>> +<groupId>org.hsqldb</groupId> >>>> <artifactId>hsqldb</**artifactId> >>>> -<version>1.8.0.10</version> >>>> <scope>test</scope> >>>> </dependency> >>>> <dependency> >>>> >>>> >>>> >>> -- >>> Hadrian Zbarcea >>> Principal Software Architect >>> Talend, Inc >>> http://coders.talend.com/ >>> http://camelbot.blogspot.com/ >>> >> >> -- Claus Ibsen ----------------- FuseSource Email: cib...@fusesource.com Web: http://fusesource.com Twitter: davsclaus, fusenews Blog: http://davsclaus.blogspot.com/ Author of Camel in Action: http://www.manning.com/ibsen/