You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by Andrus Adamchik <an...@objectstyle.org> on 2010/10/04 21:15:35 UTC
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Hi Mike (mrg)!
Wonder why we are getting a bunch of Hudson H2 errors? Is this a different H2 version compared to what you've tested against?
Cheers,
Andrus
On Sep 28, 2010, at 4:19 PM, Apache Hudson Server wrote:
> See <https://hudson.apache.org/hudson/job/Cayenne-trunk/./cayenneTestConnection=h2,jdk=JDK%201.5%20(latest),label=Ubuntu/372/changes>
>
> Changes:
>
> [mgentry] Updated the H2 Adapter to support auto-generating primary keys through H2's AUTO_INCREMENT option.
>
> ------------------------------------------
> [...truncated 26528 lines...]
> testSetContext(org.apache.cayenne.CayenneDataObjectInContextTest)
> testFetchByAttribute(org.apache.cayenne.CayenneDataObjectInContextTest)
> testUniquing(org.apache.cayenne.CayenneDataObjectInContextTest)
> testSnapshotVersion1(org.apache.cayenne.CayenneDataObjectInContextTest)
> testSnapshotVersion2(org.apache.cayenne.CayenneDataObjectInContextTest)
> testSnapshotVersion3(org.apache.cayenne.CayenneDataObjectInContextTest)
> testObjectsCommittedManualOID(org.apache.cayenne.CayenneDataObjectInContextTest)
> testGeneratedJoinInFlattenedRelationship(org.apache.cayenne.access.IdentityColumnsTest)
> testCompoundPKWithGeneratedColumn(org.apache.cayenne.access.IdentityColumnsTest)
> testDbEntityQualifier(org.apache.cayenne.access.trans.SelectTranslatorTest)
> testSave(org.apache.cayenne.access.InheritanceTest)
> test(org.apache.cayenne.query.StatementFetchSizeTest)
> testPerformPaginatedQuery(org.apache.cayenne.access.DataContextTest)
> testCurrentSnapshot1(org.apache.cayenne.access.DataContextTest)
> testCurrentSnapshot2(org.apache.cayenne.access.DataContextTest)
> testCurrentSnapshot3(org.apache.cayenne.access.DataContextTest)
> testCurrentSnapshotWithToOneFault(org.apache.cayenne.access.DataContextTest)
> testCharFetch(org.apache.cayenne.access.DataContextTest)
> testCharInQualifier(org.apache.cayenne.access.DataContextTest)
> testMultiObjRelFetch(org.apache.cayenne.access.DataContextTest)
> testMultiDbRelFetch(org.apache.cayenne.access.DataContextTest)
> testSelectDate(org.apache.cayenne.access.DataContextTest)
> testCaseInsensitiveOrdering(org.apache.cayenne.access.DataContextTest)
> testPerformSelectQuery1(org.apache.cayenne.access.DataContextTest)
> testPerformSelectQuery2(org.apache.cayenne.access.DataContextTest)
> testPerformNonSelectingQuery(org.apache.cayenne.access.DataContextTest)
> testPerformNonSelectingQueryCounts1(org.apache.cayenne.access.DataContextTest)
> testPerformNonSelectingQueryCounts2(org.apache.cayenne.access.DataContextTest)
> testPerformPaginatedQuery1(org.apache.cayenne.access.DataContextTest)
> testPerformPaginatedQueryBigPage(org.apache.cayenne.access.DataContextTest)
> testPerformDataRowQuery(org.apache.cayenne.access.DataContextTest)
> testCommitChangesRO1(org.apache.cayenne.access.DataContextTest)
> testCommitChangesRO2(org.apache.cayenne.access.DataContextTest)
> testCommitChangesRO3(org.apache.cayenne.access.DataContextTest)
> testCommitChangesRO4(org.apache.cayenne.access.DataContextTest)
> testPerformIteratedQuery1(org.apache.cayenne.access.DataContextTest)
> testPerformIteratedQuery2(org.apache.cayenne.access.DataContextTest)
> testHasChangesPhantom(org.apache.cayenne.access.DataContextTest)
> testHasChangesRealModify(org.apache.cayenne.access.DataContextTest)
> testInvalidateObjects(org.apache.cayenne.access.DataContextTest)
> testBeforeHollowDeleteShouldChangeStateToCommited(org.apache.cayenne.access.DataContextTest)
> testSelectSelectCommitRefresh(org.apache.cayenne.access.DataContextSharedCacheEmpiricTest)
> testSelectSelectCommitRefreshReverse(org.apache.cayenne.access.DataContextSharedCacheEmpiricTest)
> testSelectUpdateSelectCommitRefresh(org.apache.cayenne.access.DataContextSharedCacheEmpiricTest)
> testGeneratePkForDbEntity(org.apache.cayenne.dba.PkGeneratorTest)
> testSerializeNew(org.apache.cayenne.access.DataContextSerializationTest)
> testSerializeCommitted(org.apache.cayenne.access.DataContextSerializationTest)
> testSerializeResolver(org.apache.cayenne.access.DataContextSerializationTest)
> testSerializeChannel(org.apache.cayenne.access.DataContextSerializationTest)
> testSerializeNestedChannel(org.apache.cayenne.access.DataContextSerializationTest)
> testSerializeWithSharedCache(org.apache.cayenne.access.DataContextSerializationTest)
> testSerializeWithLocalCache(org.apache.cayenne.access.DataContextSerializationTest)
> testSerializeModified(org.apache.cayenne.access.DataContextSerializationTest)
> testLocalObjectSynchronize(org.apache.cayenne.NestedCayenneContextTest)
> testLocalObjectsNoOverride(org.apache.cayenne.NestedCayenneContextTest)
> testSelect(org.apache.cayenne.NestedCayenneContextTest)
> testPrefetchingToOne(org.apache.cayenne.NestedCayenneContextTest)
> testPrefetchingToMany(org.apache.cayenne.NestedCayenneContextTest)
> testDeleteNew(org.apache.cayenne.NestedCayenneContextTest)
> testNullifyToOne(org.apache.cayenne.NestedCayenneContextTest)
> testCommitChangesToParent(org.apache.cayenne.NestedCayenneContextTest)
> testCommitChangesToParentDeleted(org.apache.cayenne.NestedCayenneContextTest)
> testCommitChanges(org.apache.cayenne.NestedCayenneContextTest)
> testAddRemove(org.apache.cayenne.NestedCayenneContextTest)
> testChangeRel(org.apache.cayenne.NestedCayenneContextTest)
> testCAY1183(org.apache.cayenne.NestedCayenneContextTest)
> testIterator(org.apache.cayenne.access.SimpleIdIncrementalFaultListDataRowsTest)
> testGet1(org.apache.cayenne.access.SimpleIdIncrementalFaultListDataRowsTest)
> testIndexOf1(org.apache.cayenne.access.SimpleIdIncrementalFaultListDataRowsTest)
> testIndexOf2(org.apache.cayenne.access.SimpleIdIncrementalFaultListDataRowsTest)
> testLastIndexOf1(org.apache.cayenne.access.SimpleIdIncrementalFaultListDataRowsTest)
> testLastIndexOf2(org.apache.cayenne.access.SimpleIdIncrementalFaultListDataRowsTest)
> testCompareToNull(org.apache.cayenne.access.DataContextEJBQLIsNullTest)
> testCompareToNull2(org.apache.cayenne.access.DataContextEJBQLIsNullTest)
> testCompareToNull3(org.apache.cayenne.access.DataContextEJBQLIsNullTest)
> testIsNull(org.apache.cayenne.access.DataContextEJBQLIsNullTest)
> testIsNotNull(org.apache.cayenne.access.DataContextEJBQLIsNullTest)
> testToOneIsNull(org.apache.cayenne.access.DataContextEJBQLIsNullTest)
> testToOneIsNotNull(org.apache.cayenne.access.DataContextEJBQLIsNullTest)
> testFetchLimit(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testFetchOffset(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testPageSize(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testSQLResultSetMappingScalar(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testSQLResultSetMappingMixed(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testSQLResultSetMappingScalarArray(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testColumnNamesCapitalization(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testFetchDataRows(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testFetchObjects(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectEqualShort(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectNotEqualShort(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectEqualFull(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectEqualFullNonArray(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectEqualNull(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectNotEqualFull(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectEqualCompound(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectNotEqualCompound(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindObjectNotEqualNull(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testBindEqualNull(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testFetchOffsetFetchLimit(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testIteratedQuery(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testQueryWithLineBreakAfterMacro(org.apache.cayenne.access.DataContextSQLTemplateTest)
> testManyToMany(org.apache.cayenne.access.FlattenedPrefetchTest)
> testMultiPrefetch(org.apache.cayenne.access.FlattenedPrefetchTest)
> testJointManyToMany(org.apache.cayenne.access.FlattenedPrefetchTest)
> testJointMultiPrefetch(org.apache.cayenne.access.FlattenedPrefetchTest)
> testOrderByDefault(org.apache.cayenne.access.DataContextEJBQLOrderByTest)
> testOrderByAsc(org.apache.cayenne.access.DataContextEJBQLOrderByTest)
> testOrderByDesc(org.apache.cayenne.access.DataContextEJBQLOrderByTest)
> testOrderByQualified(org.apache.cayenne.access.DataContextEJBQLOrderByTest)
> testOrderByMultiple(org.apache.cayenne.access.DataContextEJBQLOrderByTest)
> testOrderByPath(org.apache.cayenne.access.DataContextEJBQLOrderByTest)
> testCollectionMemberOfThetaJoin(org.apache.cayenne.access.DataContextEJBQLFlattenedRelationshipsTest)
> testCommitDecorated(org.apache.cayenne.access.DataContextDecoratedStackTest)
> testGetParentDataDomain(org.apache.cayenne.access.DataContextDecoratedStackTest)
> testLocalCacheStaysLocal(org.apache.cayenne.access.NestedDataContextLocalCacheTest)
> testParentUpdatedId(org.apache.cayenne.access.NestedDataContextParentEventsTest)
> testUpdateQualifier(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testUpdateNoQualifierString(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testUpdateNoQualifierNull(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testUpdateNoQualifierMultipleItems(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testUpdateNoQualifierDecimal(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testUpdateNoQualifierBoolean(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testUpdateNoQualifierToOne(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testUpdateNoQualifierToOneCompoundPK(org.apache.cayenne.access.DataContextEJBQLUpdateTest)
> testFetchLimit(org.apache.cayenne.query.SelectQueryTest)
> testFetchOffset(org.apache.cayenne.query.SelectQueryTest)
> testDbEntityRoot(org.apache.cayenne.query.SelectQueryTest)
> testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
> testFetchOffsetWithQualifier(org.apache.cayenne.query.SelectQueryTest)
> testFetchLimitWithQualifier(org.apache.cayenne.query.SelectQueryTest)
> testSelectAllObjectsRootEntityName(org.apache.cayenne.query.SelectQueryTest)
> testSelectAllObjectsRootClass(org.apache.cayenne.query.SelectQueryTest)
> testSelectAllObjectsRootObjEntity(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeExactMatch(org.apache.cayenne.query.SelectQueryTest)
> testSelectNotLikeSingleWildcardMatch(org.apache.cayenne.query.SelectQueryTest)
> testSelectNotLikeIgnoreCaseSingleWildcardMatch(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeCaseSensitive(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeSingleWildcardMatch(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeSingleWildcardMatchAndEscape(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeMultipleWildcardMatch(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeIgnoreCaseObjects1(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeIgnoreCaseObjects2(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeIgnoreCaseClob(org.apache.cayenne.query.SelectQueryTest)
> testSelectIn(org.apache.cayenne.query.SelectQueryTest)
> testSelectParameterizedIn(org.apache.cayenne.query.SelectQueryTest)
> testSelectParameterizedEmptyIn(org.apache.cayenne.query.SelectQueryTest)
> testSelectParameterizedEmptyNotIn(org.apache.cayenne.query.SelectQueryTest)
> testSelectEmptyIn(org.apache.cayenne.query.SelectQueryTest)
> testSelectEmptyNotIn(org.apache.cayenne.query.SelectQueryTest)
> testSelectBooleanTrue(org.apache.cayenne.query.SelectQueryTest)
> testSelectBooleanNotTrueOr(org.apache.cayenne.query.SelectQueryTest)
> testSelectBooleanFalse(org.apache.cayenne.query.SelectQueryTest)
> testSelectBooleanFalseOr(org.apache.cayenne.query.SelectQueryTest)
> testRouteWithPrefetches(org.apache.cayenne.query.SelectQueryTest)
> testRouteQueryWithPrefetchesNoReverse(org.apache.cayenne.query.SelectQueryTest)
> testRouteQueryWithPrefetchesPrefetchExpressionPath(org.apache.cayenne.query.SelectQueryTest)
> testLeftJoinAndPrefetchToMany(org.apache.cayenne.query.SelectQueryTest)
> testLeftJoinAndPrefetchToOne(org.apache.cayenne.query.SelectQueryTest)
> testRollbackRelationshipModification(org.apache.cayenne.remote.RemoteRollbackTest)
> testRollbackDeletedObject(org.apache.cayenne.remote.RemoteRollbackTest)
> testRollbackModifiedObject(org.apache.cayenne.remote.RemoteRollbackTest)
> testNullify(org.apache.cayenne.remote.RelationshipChangeTest)
> testChange(org.apache.cayenne.remote.RelationshipChangeTest)
> testAddToMany(org.apache.cayenne.CDOCollectionRelationshipTest)
> testAddToManyViaReverse(org.apache.cayenne.CDOCollectionRelationshipTest)
> testFlushToParent_Commit(org.apache.cayenne.access.DataContextCommitTest)
> testDeepMergeExistingSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest)
> testDeepMergeNonExistentSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest)
> testReadRelationship(org.apache.cayenne.CDOOneToManyFKTest)
> testGeneratedKey(org.apache.cayenne.access.DataContextEntityWithMeaningfulPKTest)
> testToManyRelationshipWithMeaningfulPK2(org.apache.cayenne.access.DataContextEntityWithMeaningfulPKTest)
> testNotLike(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testIn(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testNotIn(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testOr(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testAnd(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testNot(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testEqual(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testNotEqual(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testLessThan(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testLessThanEqualTo(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testGreaterThan(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testGreaterThanEqualTo(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testLike(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testLikeIgnoreCase(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testNotLikeIgnoreCase(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testBetween(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testNotBetween(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testParameter(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testDbExpression(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testFloatExpression(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testNullExpression(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testTrueExpression(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testFalseExpression(org.apache.cayenne.exp.ParsedExpQualifierCompatTest)
> testMultipleOrdering(org.apache.cayenne.access.DataContextOrderingTest)
> testMultipleOrderingInSelectClauseCAY_1074(org.apache.cayenne.access.DataContextOrderingTest)
> testCommit(org.apache.cayenne.access.UserTransactionTest)
> testLocalObjectPeerContextMap(org.apache.cayenne.access.DataContextObjectTrackingTest)
> testLocalObjectPeerContextNoOverride(org.apache.cayenne.access.DataContextObjectTrackingTest)
> testFetchLimit_DistinctResultIterator(org.apache.cayenne.access.jdbc.SelectActionTest)
> testLocalCacheRefreshObjectsRefresh(org.apache.cayenne.access.DataContextQueryCachingTest)
> testPeerObjectUpdatedSimpleProperty(org.apache.cayenne.access.NestedDataContextParentPeerEventsTest)
> testPeerObjectUpdatedToOneRelationship(org.apache.cayenne.access.NestedDataContextParentPeerEventsTest)
> testPeerObjectUpdatedToManyRelationship(org.apache.cayenne.access.NestedDataContextParentPeerEventsTest)
>
> Tests run: 2065, Failures: 3, Errors: 851, Skipped: 0
>
> [INFO] ------------------------------------------------------------------------
> [ERROR] BUILD FAILURE
> [INFO] ------------------------------------------------------------------------
> [INFO] There are test failures.
>
> Please refer to <https://hudson.apache.org/hudson/job/Cayenne-trunk/./cayenneTestConnection=h2,jdk=JDK%201.5%20(latest),label=Ubuntu/ws/trunk/framework/cayenne-jdk1.5-unpublished/target/surefire-reports> for the individual test results.
> [INFO] ------------------------------------------------------------------------
> [INFO] Trace
> org.apache.maven.BuildFailureException: There are test failures.
>
> Please refer to <https://hudson.apache.org/hudson/job/Cayenne-trunk/./cayenneTestConnection=h2,jdk=JDK%201.5%20(latest),label=Ubuntu/ws/trunk/framework/cayenne-jdk1.5-unpublished/target/surefire-reports> for the individual test results.
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:715)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalWithLifecycle(DefaultLifecycleExecutor.java:556)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoal(DefaultLifecycleExecutor.java:535)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoalAndHandleFailures(DefaultLifecycleExecutor.java:387)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeTaskSegments(DefaultLifecycleExecutor.java:348)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.execute(DefaultLifecycleExecutor.java:180)
> at org.apache.maven.DefaultMaven.doExecute(DefaultMaven.java:328)
> at org.apache.maven.DefaultMaven.execute(DefaultMaven.java:138)
> at org.apache.maven.cli.MavenCli.main(MavenCli.java:362)
> at org.apache.maven.cli.compat.CompatibleMain.main(CompatibleMain.java:60)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
> at java.lang.reflect.Method.invoke(Method.java:597)
> at org.codehaus.classworlds.Launcher.launchEnhanced(Launcher.java:315)
> at org.codehaus.classworlds.Launcher.launch(Launcher.java:255)
> at org.codehaus.classworlds.Launcher.mainWithExitCode(Launcher.java:430)
> at org.codehaus.classworlds.Launcher.main(Launcher.java:375)
> Caused by: org.apache.maven.plugin.MojoFailureException: There are test failures.
>
> Please refer to <https://hudson.apache.org/hudson/job/Cayenne-trunk/./cayenneTestConnection=h2,jdk=JDK%201.5%20(latest),label=Ubuntu/ws/trunk/framework/cayenne-jdk1.5-unpublished/target/surefire-reports> for the individual test results.
> at org.apache.maven.plugin.surefire.SurefirePlugin.execute(SurefirePlugin.java:629)
> at org.apache.maven.plugin.DefaultPluginManager.executeMojo(DefaultPluginManager.java:490)
> at org.apache.maven.lifecycle.DefaultLifecycleExecutor.executeGoals(DefaultLifecycleExecutor.java:694)
> ... 17 more
> [INFO] ------------------------------------------------------------------------
> [INFO] Total time: 50 seconds
> [INFO] Finished at: Tue Sep 28 13:19:26 UTC 2010
> [INFO] Final Memory: 73M/431M
> [INFO] ------------------------------------------------------------------------
> Recording test results
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
Of course.
On Oct 21, 2010, at 5:36 PM, Michael Gentry wrote:
> Dare we switch? :-)
>
>
> On Thu, Oct 21, 2010 at 10:31 AM, Andrus Adamchik
> <an...@objectstyle.org> wrote:
>> Nice!
>>
>> On Oct 21, 2010, at 5:29 PM, Michael Gentry wrote:
>>
>>> FWIW, the H2 people fixed the bug for us and 3.1 builds and the tests
>>> successfully run with with H2 1.2.144.
>>>
>>> mrg
>>>
>>>
>>> On Sat, Oct 9, 2010 at 7:13 PM, Michael Gentry <mg...@masslight.net> wrote:
>>>> Sure, I'll take care of that. I also filed a bug for the H2 people.
>>>> Maybe they'll fix it, but at least we are back to building now.
>>>>
>>>> mrg
>>>>
>>>>
>>>> On Sat, Oct 9, 2010 at 4:24 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>>> Awesome. It worked.
>>>>>
>>>>> Can we possibly log a Jira about H2 auto increment feature and record it in RELEASE-NOTES? It should help us down the line in documenting 3.1 improvements.
>>>>>
>>>>> Andrus
>>>>>
>>>>>
>>>>> On Oct 9, 2010, at 7:05 PM, Michael Gentry wrote:
>>>>>
>>>>>> H2 1.1.119 ran tests successfully locally, so I've committed the POM
>>>>>> and hopefully Hudson will build cleanly now.
>>>>>>
>>>>>> mrg
>>>>>>
>>>>>>
>>>>>> On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>>>>> I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
>>>>>>>
>>>>>>> Andrus
>>>>>>>
>>>>>>>
>>>>>>> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
>>>>>>>> Hi,
>>>>>>>>
>>>>>>>> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
>>>>>>>> it worked fine (returned one record). Against an in memory DB it
>>>>>>>> failed (returned 3 records). Seems like there is a bug in H2
>>>>>>>> somewhere. Thoughts on how we should handle this?
>>>>>>>>
>>>>>>>> Thanks,
>>>>>>>>
>>>>>>>> mrg
>>>>>>>>
>>>>>>>> PS. Here is the SQL:
>>>>>>>>
>>>>>>>>
>>>>>>>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
>>>>>>>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
>>>>>>>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
>>>>>>>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
>>>>>>>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
>>>>>>>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>>>>>>>>
>>>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
>>>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
>>>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
>>>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>>>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
>>>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>>>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
>>>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>>>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>>>>>>>>
>>>>>>>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
>>>>>>>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
>>>>>>>> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Dare we switch? :-)
On Thu, Oct 21, 2010 at 10:31 AM, Andrus Adamchik
<an...@objectstyle.org> wrote:
> Nice!
>
> On Oct 21, 2010, at 5:29 PM, Michael Gentry wrote:
>
>> FWIW, the H2 people fixed the bug for us and 3.1 builds and the tests
>> successfully run with with H2 1.2.144.
>>
>> mrg
>>
>>
>> On Sat, Oct 9, 2010 at 7:13 PM, Michael Gentry <mg...@masslight.net> wrote:
>>> Sure, I'll take care of that. I also filed a bug for the H2 people.
>>> Maybe they'll fix it, but at least we are back to building now.
>>>
>>> mrg
>>>
>>>
>>> On Sat, Oct 9, 2010 at 4:24 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>> Awesome. It worked.
>>>>
>>>> Can we possibly log a Jira about H2 auto increment feature and record it in RELEASE-NOTES? It should help us down the line in documenting 3.1 improvements.
>>>>
>>>> Andrus
>>>>
>>>>
>>>> On Oct 9, 2010, at 7:05 PM, Michael Gentry wrote:
>>>>
>>>>> H2 1.1.119 ran tests successfully locally, so I've committed the POM
>>>>> and hopefully Hudson will build cleanly now.
>>>>>
>>>>> mrg
>>>>>
>>>>>
>>>>> On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>>>> I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
>>>>>>
>>>>>> Andrus
>>>>>>
>>>>>>
>>>>>> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
>>>>>>> Hi,
>>>>>>>
>>>>>>> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
>>>>>>> it worked fine (returned one record). Against an in memory DB it
>>>>>>> failed (returned 3 records). Seems like there is a bug in H2
>>>>>>> somewhere. Thoughts on how we should handle this?
>>>>>>>
>>>>>>> Thanks,
>>>>>>>
>>>>>>> mrg
>>>>>>>
>>>>>>> PS. Here is the SQL:
>>>>>>>
>>>>>>>
>>>>>>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
>>>>>>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
>>>>>>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
>>>>>>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
>>>>>>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
>>>>>>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>>>>>>>
>>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
>>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
>>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
>>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
>>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
>>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>>>>>>>
>>>>>>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
>>>>>>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
>>>>>>> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>>
>>>
>>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
Nice!
On Oct 21, 2010, at 5:29 PM, Michael Gentry wrote:
> FWIW, the H2 people fixed the bug for us and 3.1 builds and the tests
> successfully run with with H2 1.2.144.
>
> mrg
>
>
> On Sat, Oct 9, 2010 at 7:13 PM, Michael Gentry <mg...@masslight.net> wrote:
>> Sure, I'll take care of that. I also filed a bug for the H2 people.
>> Maybe they'll fix it, but at least we are back to building now.
>>
>> mrg
>>
>>
>> On Sat, Oct 9, 2010 at 4:24 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>> Awesome. It worked.
>>>
>>> Can we possibly log a Jira about H2 auto increment feature and record it in RELEASE-NOTES? It should help us down the line in documenting 3.1 improvements.
>>>
>>> Andrus
>>>
>>>
>>> On Oct 9, 2010, at 7:05 PM, Michael Gentry wrote:
>>>
>>>> H2 1.1.119 ran tests successfully locally, so I've committed the POM
>>>> and hopefully Hudson will build cleanly now.
>>>>
>>>> mrg
>>>>
>>>>
>>>> On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>>> I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
>>>>>
>>>>> Andrus
>>>>>
>>>>>
>>>>> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
>>>>>> Hi,
>>>>>>
>>>>>> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
>>>>>> it worked fine (returned one record). Against an in memory DB it
>>>>>> failed (returned 3 records). Seems like there is a bug in H2
>>>>>> somewhere. Thoughts on how we should handle this?
>>>>>>
>>>>>> Thanks,
>>>>>>
>>>>>> mrg
>>>>>>
>>>>>> PS. Here is the SQL:
>>>>>>
>>>>>>
>>>>>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
>>>>>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
>>>>>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
>>>>>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
>>>>>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
>>>>>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>>>>>>
>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
>>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
>>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>>>>>>
>>>>>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
>>>>>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
>>>>>> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
FWIW, the H2 people fixed the bug for us and 3.1 builds and the tests
successfully run with with H2 1.2.144.
mrg
On Sat, Oct 9, 2010 at 7:13 PM, Michael Gentry <mg...@masslight.net> wrote:
> Sure, I'll take care of that. I also filed a bug for the H2 people.
> Maybe they'll fix it, but at least we are back to building now.
>
> mrg
>
>
> On Sat, Oct 9, 2010 at 4:24 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>> Awesome. It worked.
>>
>> Can we possibly log a Jira about H2 auto increment feature and record it in RELEASE-NOTES? It should help us down the line in documenting 3.1 improvements.
>>
>> Andrus
>>
>>
>> On Oct 9, 2010, at 7:05 PM, Michael Gentry wrote:
>>
>>> H2 1.1.119 ran tests successfully locally, so I've committed the POM
>>> and hopefully Hudson will build cleanly now.
>>>
>>> mrg
>>>
>>>
>>> On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>> I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
>>>>
>>>> Andrus
>>>>
>>>>
>>>> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
>>>>> Hi,
>>>>>
>>>>> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
>>>>> it worked fine (returned one record). Against an in memory DB it
>>>>> failed (returned 3 records). Seems like there is a bug in H2
>>>>> somewhere. Thoughts on how we should handle this?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> mrg
>>>>>
>>>>> PS. Here is the SQL:
>>>>>
>>>>>
>>>>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
>>>>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
>>>>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
>>>>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
>>>>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
>>>>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>>>>>
>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
>>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
>>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>>>>>
>>>>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
>>>>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
>>>>> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>>>>>
>>>>
>>>>
>>>
>>
>>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Sure, I'll take care of that. I also filed a bug for the H2 people.
Maybe they'll fix it, but at least we are back to building now.
mrg
On Sat, Oct 9, 2010 at 4:24 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
> Awesome. It worked.
>
> Can we possibly log a Jira about H2 auto increment feature and record it in RELEASE-NOTES? It should help us down the line in documenting 3.1 improvements.
>
> Andrus
>
>
> On Oct 9, 2010, at 7:05 PM, Michael Gentry wrote:
>
>> H2 1.1.119 ran tests successfully locally, so I've committed the POM
>> and hopefully Hudson will build cleanly now.
>>
>> mrg
>>
>>
>> On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>> I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
>>>
>>> Andrus
>>>
>>>
>>> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
>>>> Hi,
>>>>
>>>> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
>>>> it worked fine (returned one record). Against an in memory DB it
>>>> failed (returned 3 records). Seems like there is a bug in H2
>>>> somewhere. Thoughts on how we should handle this?
>>>>
>>>> Thanks,
>>>>
>>>> mrg
>>>>
>>>> PS. Here is the SQL:
>>>>
>>>>
>>>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
>>>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
>>>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
>>>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
>>>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
>>>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>>>>
>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
>>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
>>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>>>>
>>>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
>>>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
>>>> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>>>>
>>>
>>>
>>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
Awesome. It worked.
Can we possibly log a Jira about H2 auto increment feature and record it in RELEASE-NOTES? It should help us down the line in documenting 3.1 improvements.
Andrus
On Oct 9, 2010, at 7:05 PM, Michael Gentry wrote:
> H2 1.1.119 ran tests successfully locally, so I've committed the POM
> and hopefully Hudson will build cleanly now.
>
> mrg
>
>
> On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>> I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
>>
>> Andrus
>>
>>
>> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
>>> Hi,
>>>
>>> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
>>> it worked fine (returned one record). Against an in memory DB it
>>> failed (returned 3 records). Seems like there is a bug in H2
>>> somewhere. Thoughts on how we should handle this?
>>>
>>> Thanks,
>>>
>>> mrg
>>>
>>> PS. Here is the SQL:
>>>
>>>
>>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
>>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
>>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
>>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
>>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
>>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>>>
>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
>>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
>>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>>>
>>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
>>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
>>> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>>>
>>
>>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
H2 1.1.119 ran tests successfully locally, so I've committed the POM
and hopefully Hudson will build cleanly now.
mrg
On Sat, Oct 9, 2010 at 11:29 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
>
> Andrus
>
>
> On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
>> Hi,
>>
>> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
>> it worked fine (returned one record). Against an in memory DB it
>> failed (returned 3 records). Seems like there is a bug in H2
>> somewhere. Thoughts on how we should handle this?
>>
>> Thanks,
>>
>> mrg
>>
>> PS. Here is the SQL:
>>
>>
>> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
>> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
>> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
>> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
>> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
>> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>>
>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
>> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
>> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
>> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>>
>> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
>> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
>> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
I suggest filing a bug with H2 and downgrading down, until we (hopefully) find a version that is free of that bug but still supports auto-increment. If that doesn't work, we can switch tests to file-based URLs.
Andrus
On Oct 9, 2010, at 6:23 PM, Michael Gentry wrote:
> Hi,
>
> I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
> it worked fine (returned one record). Against an in memory DB it
> failed (returned 3 records). Seems like there is a bug in H2
> somewhere. Thoughts on how we should handle this?
>
> Thanks,
>
> mrg
>
> PS. Here is the SQL:
>
>
> CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
> NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
> CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
> DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
> VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
> VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
>
> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
> INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
> ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
> ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
> INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
> ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
>
> SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
> t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
> (t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Hi,
I just did an experiment. Using H2 against a file (/tmp/CayenneTest)
it worked fine (returned one record). Against an in memory DB it
failed (returned 3 records). Seems like there is a bug in H2
somewhere. Thoughts on how we should handle this?
Thanks,
mrg
PS. Here is the SQL:
CREATE TABLE ARTIST (ARTIST_ID BIGINT NOT NULL, ARTIST_NAME CHAR(254)
NOT NULL, DATE_OF_BIRTH DATE NULL, PRIMARY KEY (ARTIST_ID));
CREATE TABLE PAINTING (ARTIST_ID BIGINT NULL, ESTIMATED_PRICE
DECIMAL(10, 2) NULL, GALLERY_ID INTEGER NULL, PAINTING_DESCRIPTION
VARCHAR(255) NULL, PAINTING_ID INTEGER NOT NULL, PAINTING_TITLE
VARCHAR(255) NOT NULL, PRIMARY KEY (PAINTING_ID));
INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33001, 'B');
INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33002, 'A');
INSERT INTO ARTIST (ARTIST_ID, ARTIST_NAME) VALUES (33003, 'D');
INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
ESTIMATED_PRICE) VALUES (33009, 33001, 'X', 5000);
INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
ESTIMATED_PRICE) VALUES (33010, 33001, 'Y', 5000);
INSERT INTO PAINTING (PAINTING_ID, ARTIST_ID, PAINTING_TITLE,
ESTIMATED_PRICE) VALUES (33011, 33002, 'Z', 5000);
SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
(t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL;
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Well, I just manually created the ARTIST and PAINTING table and added
the 3 records in each using the H2 1.2.143 console. I then did the
query and it returned only 1 row (the correct one). So something more
is going on here.
mrg
On Wed, Oct 6, 2010 at 3:01 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>
> On Oct 6, 2010, at 3:17 AM, Michael Gentry wrote:
>
>> Obviously it seems to have happened after I updated the adapter to
>> support auto increment PKs. :-)
>
> I suspect the real issue for these remaining failures is actually H2 version upgrade.
>
> Andrus
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
On Oct 6, 2010, at 3:17 AM, Michael Gentry wrote:
> Obviously it seems to have happened after I updated the adapter to
> support auto increment PKs. :-)
I suspect the real issue for these remaining failures is actually H2 version upgrade.
Andrus
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Still a few errors being generated. I haven't had a lot of time to
look into it. One issue is:
DataContextEJBQLConditionsTest.testCollectionEmpty
It inserts 3 artists and 3 paintings. 2 paintings off 1 artist, 1
painting off another artist, and 1 artist with 0 paintings. It then
uses:
ejbql = "SELECT a FROM Artist a WHERE a.paintingArray IS EMPTY";
to create an EJBQLQuery which executes:
INFO: SELECT t0.DATE_OF_BIRTH AS ec0_0, t0.ARTIST_ID AS ec0_2,
t0.ARTIST_NAME AS ec0_1 FROM ARTIST t0 LEFT OUTER JOIN PAINTING t1 ON
(t0.ARTIST_ID = t1.ARTIST_ID) WHERE t1.PAINTING_ID IS NULL
Oct 5, 2010 8:03:38 PM org.apache.cayenne.log.CommonsJdbcEventLogger
logSelectCount
INFO: === returned 3 rows. - took 41 ms.
All 3 artists seem to be returned instead of just the 1 artist without
a painting. This causes:
assertEquals(1, objects.size());
to fail. I'm not sure if this is an H2 issue or something else.
Obviously it seems to have happened after I updated the adapter to
support auto increment PKs. :-)
mrg
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
svn commit -m "Updated h2 from 1.0.64 to 1.2.143" pom.xml
Not sure if everything will run, but problem won't hurt. :-)
On Tue, Oct 5, 2010 at 12:16 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
> Totally, let's upgrade.
>
> On Oct 5, 2010, at 6:04 PM, Michael Gentry wrote:
>
>> The following SQL:
>>
>> CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK INTEGER NOT NULL,
>> GENERATED_COLUMN INTEGER NOT NULL AUTO_INCREMENT, NAME VARCHAR(100)
>> NULL, PROPAGATED_PK INTEGER NOT NULL, PRIMARY KEY (AUTO_PK,
>> GENERATED_COLUMN, PROPAGATED_PK))
>>
>> h2-1.0.61: fail
>> h2-1.2.128: pass
>>
>> We are using 1.0.64 in the pom.xml. Perhaps we should use a newer version?
>>
>> mrg
>>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
Totally, let's upgrade.
On Oct 5, 2010, at 6:04 PM, Michael Gentry wrote:
> The following SQL:
>
> CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK INTEGER NOT NULL,
> GENERATED_COLUMN INTEGER NOT NULL AUTO_INCREMENT, NAME VARCHAR(100)
> NULL, PROPAGATED_PK INTEGER NOT NULL, PRIMARY KEY (AUTO_PK,
> GENERATED_COLUMN, PROPAGATED_PK))
>
> h2-1.0.61: fail
> h2-1.2.128: pass
>
> We are using 1.0.64 in the pom.xml. Perhaps we should use a newer version?
>
> mrg
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
The following SQL:
CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK INTEGER NOT NULL,
GENERATED_COLUMN INTEGER NOT NULL AUTO_INCREMENT, NAME VARCHAR(100)
NULL, PROPAGATED_PK INTEGER NOT NULL, PRIMARY KEY (AUTO_PK,
GENERATED_COLUMN, PROPAGATED_PK))
h2-1.0.61: fail
h2-1.2.128: pass
We are using 1.0.64 in the pom.xml. Perhaps we should use a newer version?
mrg
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
One issue it is failing with:
SEVERE: Error generating schema...
org.h2.jdbc.JdbcSQLException: Attempt to define a second primary key;
SQL statement:
CREATE TABLE GENERATED_COLUMN_COMP_KEY (AUTO_PK INTEGER NOT NULL,
GENERATED_COLUMN INTEGER NOT NULL AUTO_INCREMENT, NAME VARCHAR(100)
NULL, PROPAGATED_PK INTEGER NOT NULL, PRIMARY KEY (AUTO_PK,
GENERATED_COLUMN, PROPAGATED_PK)) [90017-64]
The test map has the following:
<db-entity name="GENERATED_COLUMN_COMP_KEY">
<db-attribute name="AUTO_PK" type="INTEGER"
isPrimaryKey="true" isMandatory="true"/>
<db-attribute name="GENERATED_COLUMN" type="INTEGER"
isPrimaryKey="true" isGenerated="true" isMandatory="true"/>
<db-attribute name="NAME" type="VARCHAR" length="100"/>
<db-attribute name="PROPAGATED_PK" type="INTEGER"
isPrimaryKey="true" isMandatory="true"/>
</db-entity>
I'm guessing that H2 doesn't allow multiple/compound PKs if one of
them is autogenerated. Thoughts?
Thanks,
mrg
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
[INFO] ------------------------------------------------------------------------
[ERROR] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] There are test failures.
Now I have something to look at. :-)
On Tue, Oct 5, 2010 at 8:55 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> That explains it. You need to configure in-memory H2. E.g. here is mine:
>
> ~: cat ~/.cayenne/connection.properties |grep h2
>
> h2.cayenne.adapter = org.apache.cayenne.dba.h2.H2Adapter
> h2.jdbc.username = username
> h2.jdbc.password = password
> h2.jdbc.url = jdbc:h2:mem:myTestMem;MVCC=TRUE
> h2.jdbc.driver = org.h2.Driver
>
> Andrus
>
> On Oct 5, 2010, at 3:49 PM, Michael Gentry wrote:
>
>> Hi Andrus,
>>
>> Mine gives:
>>
>> INFO: Invalid connection key 'h2', trying default: internal_embedded_datasource
>>
>> And then uses HSQLDB.
>>
>> mrg
>>
>>
>> -------------------------------------------------------
>> T E S T S
>> -------------------------------------------------------
>> Running org.apache.cayenne.access.trans.BatchQueryBuilderTest
>> Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.427 sec
>> Running org.apache.cayenne.unit.di.DICaseSelfTest
>> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.062 sec
>> Running org.apache.cayenne.exp.parser.ExpressionEvaluateInMemoryTest
>> Oct 4, 2010 4:20:00 PM
>> org.springframework.beans.factory.xml.XmlBeanDefinitionReader
>> loadBeanDefinitions
>> INFO: Loading XML bean definitions from resource loaded through InputStream
>> Oct 4, 2010 4:20:00 PM org.springframework.core.CollectionFactory <clinit>
>> INFO: Commons Collections 3.x available
>> Oct 4, 2010 4:20:00 PM org.apache.cayenne.unit.CayenneResources setConnectionKey
>> INFO: Invalid connection key 'h2', trying default: internal_embedded_datasource
>> Oct 4, 2010 4:20:00 PM org.apache.cayenne.unit.CayenneResources setConnectionKey
>> INFO: test connection info: [org.apache.cayenne.conn.DataSourceInfo:
>> user name: sa
>> password: **********
>> driver: org.hsqldb.jdbcDriver
>> db adapter class: org.apache.cayenne.dba.hsqldb.HSQLDBAdapter
>> url: jdbc:hsqldb:mem:aname
>> min. connections: 1
>> max. connections: 1
>> ]
>>
>>
>> On Tue, Oct 5, 2010 at 2:46 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>> On Oct 4, 2010, at 11:24 PM, Michael Gentry wrote:
>>>
>>>> Not sure what is going on with Hudson at the moment.
>>>
>>> It is not just Hudson. It is reproducible on my machine.
>>>
>>>
>>>> Just tried with -DcayenneTestConnection=h2, which I hadn't used before:
>>>
>>> So let's compare Maven output. At the test phase of the cayenne-jdk1.5-unpublished project it should print H2 adapter and URL:
>>>
>>> -------------------------------------------------------
>>> T E S T S
>>> -------------------------------------------------------
>>> Running org.apache.cayenne.access.trans.BatchQueryBuilderTest
>>> Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.1 sec
>>> Running org.apache.cayenne.unit.di.DICaseSelfTest
>>> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.053 sec
>>> Running org.apache.cayenne.exp.parser.ExpressionEvaluateInMemoryTest
>>> Oct 5, 2010 9:44:23 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
>>> INFO: Loading XML bean definitions from resource loaded through InputStream
>>> Oct 5, 2010 9:44:23 AM org.springframework.core.CollectionFactory <clinit>
>>> INFO: Commons Collections 3.x available
>>> Oct 5, 2010 9:44:23 AM org.apache.cayenne.unit.CayenneResources setConnectionKey
>>> INFO: test connection info: [org.apache.cayenne.conn.DataSourceInfo:
>>> user name: username
>>> password: **********
>>> driver: org.h2.Driver
>>> db adapter class: org.apache.cayenne.dba.h2.H2Adapter
>>> url: jdbc:h2:mem:myTestMem;MVCC=TRUE
>>> min. connections: 1
>>> max. connections: 1
>>> ]
>>>
>>>
>>> Andrus
>>>
>>>
>>>
>>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
That explains it. You need to configure in-memory H2. E.g. here is mine:
~: cat ~/.cayenne/connection.properties |grep h2
h2.cayenne.adapter = org.apache.cayenne.dba.h2.H2Adapter
h2.jdbc.username = username
h2.jdbc.password = password
h2.jdbc.url = jdbc:h2:mem:myTestMem;MVCC=TRUE
h2.jdbc.driver = org.h2.Driver
Andrus
On Oct 5, 2010, at 3:49 PM, Michael Gentry wrote:
> Hi Andrus,
>
> Mine gives:
>
> INFO: Invalid connection key 'h2', trying default: internal_embedded_datasource
>
> And then uses HSQLDB.
>
> mrg
>
>
> -------------------------------------------------------
> T E S T S
> -------------------------------------------------------
> Running org.apache.cayenne.access.trans.BatchQueryBuilderTest
> Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.427 sec
> Running org.apache.cayenne.unit.di.DICaseSelfTest
> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.062 sec
> Running org.apache.cayenne.exp.parser.ExpressionEvaluateInMemoryTest
> Oct 4, 2010 4:20:00 PM
> org.springframework.beans.factory.xml.XmlBeanDefinitionReader
> loadBeanDefinitions
> INFO: Loading XML bean definitions from resource loaded through InputStream
> Oct 4, 2010 4:20:00 PM org.springframework.core.CollectionFactory <clinit>
> INFO: Commons Collections 3.x available
> Oct 4, 2010 4:20:00 PM org.apache.cayenne.unit.CayenneResources setConnectionKey
> INFO: Invalid connection key 'h2', trying default: internal_embedded_datasource
> Oct 4, 2010 4:20:00 PM org.apache.cayenne.unit.CayenneResources setConnectionKey
> INFO: test connection info: [org.apache.cayenne.conn.DataSourceInfo:
> user name: sa
> password: **********
> driver: org.hsqldb.jdbcDriver
> db adapter class: org.apache.cayenne.dba.hsqldb.HSQLDBAdapter
> url: jdbc:hsqldb:mem:aname
> min. connections: 1
> max. connections: 1
> ]
>
>
> On Tue, Oct 5, 2010 at 2:46 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
>> On Oct 4, 2010, at 11:24 PM, Michael Gentry wrote:
>>
>>> Not sure what is going on with Hudson at the moment.
>>
>> It is not just Hudson. It is reproducible on my machine.
>>
>>
>>> Just tried with -DcayenneTestConnection=h2, which I hadn't used before:
>>
>> So let's compare Maven output. At the test phase of the cayenne-jdk1.5-unpublished project it should print H2 adapter and URL:
>>
>> -------------------------------------------------------
>> T E S T S
>> -------------------------------------------------------
>> Running org.apache.cayenne.access.trans.BatchQueryBuilderTest
>> Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.1 sec
>> Running org.apache.cayenne.unit.di.DICaseSelfTest
>> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.053 sec
>> Running org.apache.cayenne.exp.parser.ExpressionEvaluateInMemoryTest
>> Oct 5, 2010 9:44:23 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
>> INFO: Loading XML bean definitions from resource loaded through InputStream
>> Oct 5, 2010 9:44:23 AM org.springframework.core.CollectionFactory <clinit>
>> INFO: Commons Collections 3.x available
>> Oct 5, 2010 9:44:23 AM org.apache.cayenne.unit.CayenneResources setConnectionKey
>> INFO: test connection info: [org.apache.cayenne.conn.DataSourceInfo:
>> user name: username
>> password: **********
>> driver: org.h2.Driver
>> db adapter class: org.apache.cayenne.dba.h2.H2Adapter
>> url: jdbc:h2:mem:myTestMem;MVCC=TRUE
>> min. connections: 1
>> max. connections: 1
>> ]
>>
>>
>> Andrus
>>
>>
>>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
On Oct 5, 2010, at 3:49 PM, Michael Gentry wrote:
> INFO: Invalid connection key 'h2', trying default: internal_embedded_datasource
Maybe we should throw an exception here, to be more explicit that a given key is invalid. Although since this happens within a single unit test, there's no clean way to abort the entire test suite (System.exit(1) or something ???).
Andrus
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Hi Andrus,
Mine gives:
INFO: Invalid connection key 'h2', trying default: internal_embedded_datasource
And then uses HSQLDB.
mrg
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.apache.cayenne.access.trans.BatchQueryBuilderTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.427 sec
Running org.apache.cayenne.unit.di.DICaseSelfTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.062 sec
Running org.apache.cayenne.exp.parser.ExpressionEvaluateInMemoryTest
Oct 4, 2010 4:20:00 PM
org.springframework.beans.factory.xml.XmlBeanDefinitionReader
loadBeanDefinitions
INFO: Loading XML bean definitions from resource loaded through InputStream
Oct 4, 2010 4:20:00 PM org.springframework.core.CollectionFactory <clinit>
INFO: Commons Collections 3.x available
Oct 4, 2010 4:20:00 PM org.apache.cayenne.unit.CayenneResources setConnectionKey
INFO: Invalid connection key 'h2', trying default: internal_embedded_datasource
Oct 4, 2010 4:20:00 PM org.apache.cayenne.unit.CayenneResources setConnectionKey
INFO: test connection info: [org.apache.cayenne.conn.DataSourceInfo:
user name: sa
password: **********
driver: org.hsqldb.jdbcDriver
db adapter class: org.apache.cayenne.dba.hsqldb.HSQLDBAdapter
url: jdbc:hsqldb:mem:aname
min. connections: 1
max. connections: 1
]
On Tue, Oct 5, 2010 at 2:46 AM, Andrus Adamchik <an...@objectstyle.org> wrote:
> On Oct 4, 2010, at 11:24 PM, Michael Gentry wrote:
>
>> Not sure what is going on with Hudson at the moment.
>
> It is not just Hudson. It is reproducible on my machine.
>
>
>> Just tried with -DcayenneTestConnection=h2, which I hadn't used before:
>
> So let's compare Maven output. At the test phase of the cayenne-jdk1.5-unpublished project it should print H2 adapter and URL:
>
> -------------------------------------------------------
> T E S T S
> -------------------------------------------------------
> Running org.apache.cayenne.access.trans.BatchQueryBuilderTest
> Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.1 sec
> Running org.apache.cayenne.unit.di.DICaseSelfTest
> Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.053 sec
> Running org.apache.cayenne.exp.parser.ExpressionEvaluateInMemoryTest
> Oct 5, 2010 9:44:23 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
> INFO: Loading XML bean definitions from resource loaded through InputStream
> Oct 5, 2010 9:44:23 AM org.springframework.core.CollectionFactory <clinit>
> INFO: Commons Collections 3.x available
> Oct 5, 2010 9:44:23 AM org.apache.cayenne.unit.CayenneResources setConnectionKey
> INFO: test connection info: [org.apache.cayenne.conn.DataSourceInfo:
> user name: username
> password: **********
> driver: org.h2.Driver
> db adapter class: org.apache.cayenne.dba.h2.H2Adapter
> url: jdbc:h2:mem:myTestMem;MVCC=TRUE
> min. connections: 1
> max. connections: 1
> ]
>
>
> Andrus
>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
On Oct 4, 2010, at 11:24 PM, Michael Gentry wrote:
> Not sure what is going on with Hudson at the moment.
It is not just Hudson. It is reproducible on my machine.
> Just tried with -DcayenneTestConnection=h2, which I hadn't used before:
So let's compare Maven output. At the test phase of the cayenne-jdk1.5-unpublished project it should print H2 adapter and URL:
-------------------------------------------------------
T E S T S
-------------------------------------------------------
Running org.apache.cayenne.access.trans.BatchQueryBuilderTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.1 sec
Running org.apache.cayenne.unit.di.DICaseSelfTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.053 sec
Running org.apache.cayenne.exp.parser.ExpressionEvaluateInMemoryTest
Oct 5, 2010 9:44:23 AM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
INFO: Loading XML bean definitions from resource loaded through InputStream
Oct 5, 2010 9:44:23 AM org.springframework.core.CollectionFactory <clinit>
INFO: Commons Collections 3.x available
Oct 5, 2010 9:44:23 AM org.apache.cayenne.unit.CayenneResources setConnectionKey
INFO: test connection info: [org.apache.cayenne.conn.DataSourceInfo:
user name: username
password: **********
driver: org.h2.Driver
db adapter class: org.apache.cayenne.dba.h2.H2Adapter
url: jdbc:h2:mem:myTestMem;MVCC=TRUE
min. connections: 1
max. connections: 1
]
Andrus
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
I hadn't updated since I did the H2 tweak, so I just updated to pick
up your change and any others. Same story:
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3 minutes 49 seconds
[INFO] Finished at: Mon Oct 04 16:22:58 EDT 2010
[INFO] Final Memory: 101M/309M
[INFO] ------------------------------------------------------------------------
Not sure what is going on with Hudson at the moment.
mrg
On Mon, Oct 4, 2010 at 4:18 PM, Michael Gentry <mg...@masslight.net> wrote:
> Just tried with -DcayenneTestConnection=h2, which I hadn't used before:
>
> [INFO] ------------------------------------------------------------------------
> [INFO] BUILD SUCCESSFUL
> [INFO] ------------------------------------------------------------------------
> [INFO] Total time: 4 minutes 17 seconds
> [INFO] Finished at: Mon Oct 04 16:17:03 EDT 2010
> [INFO] Final Memory: 101M/309M
> [INFO] ------------------------------------------------------------------------
>
>
> On Mon, Oct 4, 2010 at 4:04 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>> Just reproduced the errors locally running like this:
>>
>> mvn clean install -DcayenneTestConnection=h2
>>
>> Could you doublecheck the property name activating the "h2" profile? It is different between 3.0 and 3.1 branches (above is a 3.1 version per http://cayenne.apache.org/running-unit-tests.html ). The new syntax is due to some stupid Hudson limitations on dots in the property names.
>>
>> Andrus
>>
>> On Oct 4, 2010, at 10:55 PM, Andrus Adamchik wrote:
>>
>>> yeah, I'd think so:
>>>
>>> <dependency>
>>> <groupId>com.h2database</groupId>
>>> <artifactId>h2</artifactId>
>>> <version>1.0.64</version>
>>> <scope>test</scope>
>>> </dependency>
>>>
>>>> I haven't seen any more Hudson failures since then.
>>>
>>> All my today's commits resulted in the same failures. Build #373.
>>>
>>> Andrus
>>>
>>> On Oct 4, 2010, at 10:38 PM, Michael Gentry wrote:
>>>
>>>> Hi Andrus,
>>>>
>>>> I saw that error e-mail, but when I built and ran tests I didn't get
>>>> the errors. Wouldn't the version of H2 to use when running tests be
>>>> specified in the pom.xml and in theory should be the same? Is this
>>>> still happening? I haven't seen any more Hudson failures since then.
>>>>
>>>> Thanks,
>>>>
>>>> mrg
>>>>
>>>>
>>>> On Mon, Oct 4, 2010 at 3:15 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>>> Hi Mike (mrg)!
>>>>>
>>>>> Wonder why we are getting a bunch of Hudson H2 errors? Is this a different H2 version compared to what you've tested against?
>>>>>
>>>>> Cheers,
>>>>> Andrus
>>>>>
>>>>>
>>>>> On Sep 28, 2010, at 4:19 PM, Apache Hudson Server wrote:
>>>>>
>>>>> [spew deleted]
>>>>
>>>
>>>
>>
>>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Just tried with -DcayenneTestConnection=h2, which I hadn't used before:
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 4 minutes 17 seconds
[INFO] Finished at: Mon Oct 04 16:17:03 EDT 2010
[INFO] Final Memory: 101M/309M
[INFO] ------------------------------------------------------------------------
On Mon, Oct 4, 2010 at 4:04 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
> Just reproduced the errors locally running like this:
>
> mvn clean install -DcayenneTestConnection=h2
>
> Could you doublecheck the property name activating the "h2" profile? It is different between 3.0 and 3.1 branches (above is a 3.1 version per http://cayenne.apache.org/running-unit-tests.html ). The new syntax is due to some stupid Hudson limitations on dots in the property names.
>
> Andrus
>
> On Oct 4, 2010, at 10:55 PM, Andrus Adamchik wrote:
>
>> yeah, I'd think so:
>>
>> <dependency>
>> <groupId>com.h2database</groupId>
>> <artifactId>h2</artifactId>
>> <version>1.0.64</version>
>> <scope>test</scope>
>> </dependency>
>>
>>> I haven't seen any more Hudson failures since then.
>>
>> All my today's commits resulted in the same failures. Build #373.
>>
>> Andrus
>>
>> On Oct 4, 2010, at 10:38 PM, Michael Gentry wrote:
>>
>>> Hi Andrus,
>>>
>>> I saw that error e-mail, but when I built and ran tests I didn't get
>>> the errors. Wouldn't the version of H2 to use when running tests be
>>> specified in the pom.xml and in theory should be the same? Is this
>>> still happening? I haven't seen any more Hudson failures since then.
>>>
>>> Thanks,
>>>
>>> mrg
>>>
>>>
>>> On Mon, Oct 4, 2010 at 3:15 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>>> Hi Mike (mrg)!
>>>>
>>>> Wonder why we are getting a bunch of Hudson H2 errors? Is this a different H2 version compared to what you've tested against?
>>>>
>>>> Cheers,
>>>> Andrus
>>>>
>>>>
>>>> On Sep 28, 2010, at 4:19 PM, Apache Hudson Server wrote:
>>>>
>>>> [spew deleted]
>>>
>>
>>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
Just reproduced the errors locally running like this:
mvn clean install -DcayenneTestConnection=h2
Could you doublecheck the property name activating the "h2" profile? It is different between 3.0 and 3.1 branches (above is a 3.1 version per http://cayenne.apache.org/running-unit-tests.html ). The new syntax is due to some stupid Hudson limitations on dots in the property names.
Andrus
On Oct 4, 2010, at 10:55 PM, Andrus Adamchik wrote:
> yeah, I'd think so:
>
> <dependency>
> <groupId>com.h2database</groupId>
> <artifactId>h2</artifactId>
> <version>1.0.64</version>
> <scope>test</scope>
> </dependency>
>
>> I haven't seen any more Hudson failures since then.
>
> All my today's commits resulted in the same failures. Build #373.
>
> Andrus
>
> On Oct 4, 2010, at 10:38 PM, Michael Gentry wrote:
>
>> Hi Andrus,
>>
>> I saw that error e-mail, but when I built and ran tests I didn't get
>> the errors. Wouldn't the version of H2 to use when running tests be
>> specified in the pom.xml and in theory should be the same? Is this
>> still happening? I haven't seen any more Hudson failures since then.
>>
>> Thanks,
>>
>> mrg
>>
>>
>> On Mon, Oct 4, 2010 at 3:15 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>>> Hi Mike (mrg)!
>>>
>>> Wonder why we are getting a bunch of Hudson H2 errors? Is this a different H2 version compared to what you've tested against?
>>>
>>> Cheers,
>>> Andrus
>>>
>>>
>>> On Sep 28, 2010, at 4:19 PM, Apache Hudson Server wrote:
>>>
>>> [spew deleted]
>>
>
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Andrus Adamchik <an...@objectstyle.org>.
yeah, I'd think so:
<dependency>
<groupId>com.h2database</groupId>
<artifactId>h2</artifactId>
<version>1.0.64</version>
<scope>test</scope>
</dependency>
> I haven't seen any more Hudson failures since then.
All my today's commits resulted in the same failures. Build #373.
Andrus
On Oct 4, 2010, at 10:38 PM, Michael Gentry wrote:
> Hi Andrus,
>
> I saw that error e-mail, but when I built and ran tests I didn't get
> the errors. Wouldn't the version of H2 to use when running tests be
> specified in the pom.xml and in theory should be the same? Is this
> still happening? I haven't seen any more Hudson failures since then.
>
> Thanks,
>
> mrg
>
>
> On Mon, Oct 4, 2010 at 3:15 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
>> Hi Mike (mrg)!
>>
>> Wonder why we are getting a bunch of Hudson H2 errors? Is this a different H2 version compared to what you've tested against?
>>
>> Cheers,
>> Andrus
>>
>>
>> On Sep 28, 2010, at 4:19 PM, Apache Hudson Server wrote:
>>
>> [spew deleted]
>
Re: Build failed in Hudson: Cayenne-trunk » h2,JDK 1.5 (latest),Ubuntu #372
Posted by Michael Gentry <mg...@masslight.net>.
Hi Andrus,
I saw that error e-mail, but when I built and ran tests I didn't get
the errors. Wouldn't the version of H2 to use when running tests be
specified in the pom.xml and in theory should be the same? Is this
still happening? I haven't seen any more Hudson failures since then.
Thanks,
mrg
On Mon, Oct 4, 2010 at 3:15 PM, Andrus Adamchik <an...@objectstyle.org> wrote:
> Hi Mike (mrg)!
>
> Wonder why we are getting a bunch of Hudson H2 errors? Is this a different H2 version compared to what you've tested against?
>
> Cheers,
> Andrus
>
>
> On Sep 28, 2010, at 4:19 PM, Apache Hudson Server wrote:
>
> [spew deleted]