13.01.2010 9:52:17 org.apache.cayenne.unit.CayenneResources getResources
SEVERE: Error generating schema...
org.postgresql.util.PSQLException: ERROR: language "plpgsql" does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:336)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:328)
at org.apache.cayenne.unit.AccessStackAdapter.executeDDL(AccessStackAdapter.java:231)
at org.apache.cayenne.unit.AccessStackAdapter.executeDDL(AccessStackAdapter.java:240)
at org.apache.cayenne.unit.PostgresStackAdapter.createdTables(PostgresStackAdapter.java:68)
at org.apache.cayenne.unit.AbstractAccessStack.createSchema(AbstractAccessStack.java:267)
at org.apache.cayenne.unit.SimpleAccessStack.createSchema(SimpleAccessStack.java:121)
at org.apache.cayenne.unit.CayenneResources.rebuildSchema(CayenneResources.java:192)
at org.apache.cayenne.unit.CayenneResources.getResources(CayenneResources.java:108)
at org.apache.cayenne.unit.CayenneCase.<init>(CayenneCase.java:66)
at org.apache.cayenne.CayenneDataObjectValidationTest.<init>(CayenneDataObjectValidationTest.java:37)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at junit.framework.TestSuite.createTest(TestSuite.java:131)
at junit.framework.TestSuite.addTestMethod(TestSuite.java:114)
at junit.framework.TestSuite.<init>(TestSuite.java:75)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at org.apache.maven.surefire.junit.JUnitTestSet.constructTestObject(JUnitTestSet.java:151)
at org.apache.maven.surefire.junit.JUnitTestSet.execute(JUnitTestSet.java:197)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.executeTestSet(AbstractDirectoryTestSuite.java:115)
at org.apache.maven.surefire.suite.AbstractDirectoryTestSuite.execute(AbstractDirectoryTestSuite.java:102)
at org.apache.maven.surefire.Surefire.run(Surefire.java:180)
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:585)
at org.apache.maven.surefire.booter.SurefireBooter.runSuitesInProcess(SurefireBooter.java:350)
at org.apache.maven.surefire.booter.SurefireBooter.main(SurefireBooter.java:1021)
Tests run: 3, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 9.093 sec <<< FAILURE!
-----Original Message-----
From: Ольга Ткачева [mailto:tkachovaolg..mail.com]
Sent: Tuesday, January 12, 2010 7:43 PM
To: de..ayenne.apache.org
Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Evgeny, give your error in postgres. I think this error while generating the
schema.
12 января 2010 г. 16:50 пользователь Рябицкий Евгений <
eryabitski..iasoft.ru> написал:
>
> I run tests without my patch over hsqldb, mssql + jtds, posgres
>
> Postgres don't like me.... :/
>
>
> NO PATCH (ONLY TEST)
>
> * hsqldb *
>
> Failed tests:
> testDATE(org.apache.cayenne.access.ReturnTypesMappingTest)
> testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testREAL(org.apache.cayenne.access.ReturnTypesMappingTest)
> testSMALLINT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIME(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTINYINT(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests in error:
> testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testBLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
> testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests run: 2031, Failures: 7, Errors: 4, Skipped: 0
>
>
> * SQL Server + JTDS *
>
> Failed tests:
> testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest)
> testSelectLikeCaseSensitive(org.apache.cayenne.query.SelectQueryTest)
> testBLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
> testCLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
> testDATE(org.apache.cayenne.access.ReturnTypesMappingTest)
> testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest)
> testDECIMAL2(org.apache.cayenne.access.ReturnTypesMappingTest)
> testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testLONGVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
> testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest)
> testNUMERIC2(org.apache.cayenne.access.ReturnTypesMappingTest)
> testSMALLINT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIME(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIMESTAMP2(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTINYINT(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests in error:
> testLongIn(org.apache.cayenne.exp.ExpressionFactoryTest)
> testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testBINARY2(org.apache.cayenne.access.ReturnTypesMappingTest)
> testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testVARBINARY2(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests run: 2031, Failures: 17, Errors: 5, Skipped: 0
>
>
> * postgres *
>
> Failed tests:
> warning(junit.framework.TestSuite$1)
> testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest)
> testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest)
> testBIGINT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testBIT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testBLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
> testBOOLEAN(org.apache.cayenne.access.ReturnTypesMappingTest)
> testCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
> testCLOB(org.apache.cayenne.access.ReturnTypesMappingTest)
> testDATE(org.apache.cayenne.access.ReturnTypesMappingTest)
> testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest)
> testDOUBLE(org.apache.cayenne.access.ReturnTypesMappingTest)
> testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testINTEGER(org.apache.cayenne.access.ReturnTypesMappingTest)
> testLONGVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
> testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest)
> testREAL(org.apache.cayenne.access.ReturnTypesMappingTest)
> testSMALLINT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIME(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest)
> testTINYINT(org.apache.cayenne.access.ReturnTypesMappingTest)
> testVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests in error:
> testMultiDBUpdate(org.apache.cayenne.access.DataContextCrossDBTest)
> testQualifyOnToMany(org.apache.cayenne.unit.jira.CAY_194Test)
> testQualifyOnToOne(org.apache.cayenne.unit.jira.CAY_194Test)
> testUnregisterThenRegister(org.apache.cayenne.access.ObjectStoreTest)
> testNullifyToOne(org.apache.cayenne.NestedCayenneContextTest)
> testSelect(org.apache.cayenne.NestedCayenneContextTest)
> testDeleteNew(org.apache.cayenne.NestedCayenneContextTest)
> testLocalObjectSynchronize(org.apache.cayenne.NestedCayenneContextTest)
> testLocalObjectsNoOverride(org.apache.cayenne.NestedCayenneContextTest)
> testPrefetchingToOne(org.apache.cayenne.NestedCayenneContextTest)
> testPrefetchingToMany(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)
>
> testRollbackRelationshipModification(org.apache.cayenne.remote.RemoteRollbackTest)
> testRollbackDeletedObject(org.apache.cayenne.remote.RemoteRollbackTest)
> testRollbackModifiedObject(org.apache.cayenne.remote.RemoteRollbackTest)
> testInsertSubclass(org.apache.cayenne.CayenneContextInheritanceTest)
>
> testDeepMergeExistingSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest)
>
> testDeepMergeNonExistentSubclass(org.apache.cayenne.util.DeepMergeOperationInheritanceTest)
> testPrefetchQuote(org.apache.cayenne.access.DataContexQuoteTest)
>
> testParentUpdatedId(org.apache.cayenne.remote.NestedObjectContextParentEventsTest)
> testSave(org.apache.cayenne.access.InheritanceTest)
> testInsertSingle(org.apache.cayenne.GenericMappingTest)
> testInsertRelated(org.apache.cayenne.GenericMappingTest)
> testUpdateRelated(org.apache.cayenne.GenericMappingTest)
>
> testReturnDiffInPrePersist(org.apache.cayenne.remote.ClientChannelServerDiffsTest)
>
> testReturnDiffClientArcChanges(org.apache.cayenne.remote.ClientChannelServerDiffsTest)
> testReturnIdDiff(org.apache.cayenne.remote.ClientChannelServerDiffsTest)
> testNullify(org.apache.cayenne.remote.RelationshipChangeTest)
> testChange(org.apache.cayenne.remote.RelationshipChangeTest)
> testFailLockingOnToOne(org.apache.cayenne.access.OptimisticLockingTest)
> testNullParameter(org.apache.cayenne.query.EJBQLQueryTest)
> testAddToMany(org.apache.cayenne.CDOMapRelationshipTest)
> testAddToManyViaReverse(org.apache.cayenne.CDOMapRelationshipTest)
> testInsert(org.apache.cayenne.access.EmbeddingTest)
> testAddToMany(org.apache.cayenne.CayenneContextMapRelationshipTest)
> testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest)
> testNullifyToOne(org.apache.cayenne.CayenneContextDeleteRulesTest)
> testCascadeToOne(org.apache.cayenne.CayenneContextDeleteRulesTest)
> testDenyToOne(org.apache.cayenne.CayenneContextDeleteRulesTest)
>
> testCascadeToOneNewObject(org.apache.cayenne.CayenneContextDeleteRulesTest)
> testDenyToOne(org.apache.cayenne.access.DeleteRulesTest)
> testNoActionToOne(org.apache.cayenne.access.DeleteRulesTest)
> testNoActionToMany(org.apache.cayenne.access.DeleteRulesTest)
> testNoActionFlattened(org.apache.cayenne.access.DeleteRulesTest)
> testNoActionFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
> testCascadeFlattened(org.apache.cayenne.access.DeleteRulesTest)
> testCascadeFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
> testNullifyFlattened(org.apache.cayenne.access.DeleteRulesTest)
> testNullifyFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
> testDenyFlattened(org.apache.cayenne.access.DeleteRulesTest)
> testDenyFlattenedNoReverse(org.apache.cayenne.access.DeleteRulesTest)
> testUpdate(org.apache.cayenne.access.jdbc.SoftDeleteBatchQueryBuilderTest)
>
> testPeerObjectUpdatedSimpleProperty(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
>
> testPeerObjectUpdatedToOneRelationship(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
>
> testPeerObjectUpdatedToManyRelationship(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
>
> testPeerObjectUpdatedTempOID(org.apache.cayenne.remote.NestedObjectContextPeerEventsTest)
>
> testMultipleSimpleProperties(org.apache.cayenne.CayenneContextGraphDiffCompressorTest)
>
> testComplimentaryArcs(org.apache.cayenne.CayenneContextGraphDiffCompressorTest)
> testDeletion(org.apache.cayenne.remote.CayenneContextDeletionTest)
> testOutParams(org.apache.cayenne.access.DataContextProcedureQueryTest)
> testValidate(org.apache.cayenne.CayenneContextValidationTest)
>
> testReturnDiffInPrePersist(org.apache.cayenne.CayenneContextServerDiffsTest)
>
> testReturnDiffInPreUpdate(org.apache.cayenne.CayenneContextServerDiffsTest)
>
> testReturnDiffClientArcChanges(org.apache.cayenne.CayenneContextServerDiffsTest)
>
> testReturnDiffServerArcChanges(org.apache.cayenne.CayenneContextServerDiffsTest)
> testReadRelationship(org.apache.cayenne.CDOOneToManyFKTest)
> testAddToMany(org.apache.cayenne.CDOSetRelationshipTest)
> testAddToManyViaReverse(org.apache.cayenne.CDOSetRelationshipTest)
> testDefault(org.apache.cayenne.remote.RemoteCallbacksTest)
> testServer(org.apache.cayenne.remote.LightSuperClassTest)
>
> testCollectionMemberOfId(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest)
>
> testCollectionNotMemberOfId(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest)
>
> testCollectionNotMemberOfToOne(org.apache.cayenne.access.DataContextEJBQLConditionsPeopleTest)
> testInsertJoinWithPK(org.apache.cayenne.FlattenedRelationshipsTest)
>
> testQualifyOnToManyFlattened(org.apache.cayenne.FlattenedRelationshipsTest)
> testToOneSeriesFlattenedRel(org.apache.cayenne.FlattenedRelationshipsTest)
> testSynchronizeCommit(org.apache.cayenne.access.ClientServerChannelTest)
> testRollbackChanges(org.apache.cayenne.CayenneContextWithDataContextTest)
> testSelectPrimitives(org.apache.cayenne.CayenneContextWithDataContextTest)
>
> testCommitChangesPrimitives(org.apache.cayenne.CayenneContextWithDataContextTest)
> testPostAddCallback(org.apache.cayenne.CayenneContextWithDataContextTest)
>
> testPostAddOnObjectCallback(org.apache.cayenne.CayenneContextWithDataContextTest)
>
> testPreRemoveCallback(org.apache.cayenne.CayenneContextWithDataContextTest)
> testCAY830(org.apache.cayenne.CayenneContextWithDataContextTest)
>
> testOIDQueryInterception(org.apache.cayenne.CayenneContextWithDataContextTest)
> testAddToMany(org.apache.cayenne.CDOCollectionRelationshipTest)
> testAddToManyViaReverse(org.apache.cayenne.CDOCollectionRelationshipTest)
> testDelete(org.apache.cayenne.CDOOneToOneFKTest)
> testReadRelationship(org.apache.cayenne.CDOOneToOneFKTest)
> testNewAdd(org.apache.cayenne.CDOOneToOneFKTest)
> test2Null(org.apache.cayenne.CDOOneToOneFKTest)
> testTakeObjectSnapshotDependentFault(org.apache.cayenne.CDOOneToOneFKTest)
> testReplaceNull1(org.apache.cayenne.CDOOneToOneFKTest)
> testReplaceNull2(org.apache.cayenne.CDOOneToOneFKTest)
>
> testSyncNewObject(org.apache.cayenne.CayenneContextClientChannelEventsTest)
>
> testSyncNewDeletedObject(org.apache.cayenne.CayenneContextClientChannelEventsTest)
>
> testSyncNewObjectIntoDirtyContext(org.apache.cayenne.CayenneContextClientChannelEventsTest)
>
> testSyncToManyRelationship(org.apache.cayenne.CayenneContextClientChannelEventsTest)
>
> testSyncToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest)
>
> testSyncManyToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest)
> testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests run: 2031, Failures: 23, Errors: 108, Skipped: 0
>
>
> Evgeny.
>
>
> -----Original Message-----
> From: Ольга Ткачева [mailto:tkachovaolg..mail.com]
> Sent: Tuesday, January 12, 2010 4:43 PM
> To: de..ayenne.apache.org
> Subject: Re: [jira] Commented: (CAY-extClientChannelEventsTest)
>
> testSyncToManyRelationship(org.apache.cayenne.CayenneContextClientChannelEventsTest)
>
> testSyncToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest)
>
> testSyncManyToManyRelationship1(org.apache.cayenne.CayenneContextClientChannelEventsTest)
> testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
> testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest)
>
> Tests run: 2031, Failures: 23, Errors: 108, Skipped: 0
>
>
> Evgeny.
>
>
> -----Original Message-----
> From: Ольга Ткачева [mailto:tkachovaolg..mail.com]
> Sent: Tuesday, January 12, 2010 4:43 PM
> To: de..ayenne.apache.org
> Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected
> values in Row Queries
>
> in oracle ReturnTypesMappingTest has error generating schema
>
> SEVERE: Error generating schema...
> java.sql.SQLException: ORA-01754: a table may contain only one column of
> type LONG
>
> at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
> at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
>
> in test generate 2 long column: LONGVARBINARY_COLUMN LONG RAW NULL,
> LONGVARCHAR_COLUMN LONG VARCHAR NULL
>
>
> 12 января 2010 г. 11:48 пользователь Andrus Adamchik <
> andru..bjectstyle.org
> > написал:
>
> >
> > On Jan 11, 2010, at 1:45 PM, Рябицкий Евгений wrote:
> >
> > Strange result... looks like I have to install Postgress to check it
> >> myself... :)
> >>
> >> Evgeny.
> >>
> >
> > Hi Evgeny,
> >
> > looking at most test failures in Olga's tests, I see that most failures
> are
> > caused by various DB incompatibilities, and have nothing to do with the
> > change itself, but rather with the unit tests themselves not being
> > compatible with a given DB. Olga just logged one issue (CAY-1363) that is
> > actually a bug in Cayenne. Others are similar, such as:
> >
> > * MySQL truncating milliseconds (so the test has to be written to compare
> > with precision up to the nearest second)
> > * Precision and scale not declared for decimal values, causing loss of
> > precision in some DB's
> > * Max length for VARCHAR being 255 on some DBs
> >
> > Those fairly benign issues would cause massive test failures, and
> > potentially hide the real issues. And those affect not only the current
> > patch, but also your earlier commit per
> > http://svn.apache.org/viewvc?view=revision&revision=889168
> >
> > We may need your help to make your tests compatible with other DB's. Olga
> > is about to send a patch on top of your patch fixing some of the above
> > things (and also fix CAY-1363). Can you take it from there and install at
> > least PostgreSQL and MySQL and try to make your tests run on those (in
> > addition to Oracle, HSQLDB, and anything else you might be testing
> against)?
> >
> > This would be of tremendous help to us, as your changes touch on JDBC
> > internals that are very sensitive to DB and driver type and version.
> >
> > Andrus
> >
> >
> >
> >
>
>
> --
> Olga Tkacheva
>
-- Olga Tkacheva
This archive was generated by hypermail 2.0.0 : Wed Jan 13 2010 - 02:01:38 EST