cayenne-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Рябицкий Евгений <eryabits...@diasoft.ru>
Subject RE: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries
Date Wed, 13 Jan 2010 06:54:18 GMT
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:tkachovaolga@gmail.com] 
Sent: Tuesday, January 12, 2010 7:43 PM
To: dev@cayenne.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 пользователь Рябицкий Евгений <
eryabitskiy@diasoft.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:tkachovaolga@gmail.com]
> Sent: Tuesday, January 12, 2010 4:43 PM
> To: dev@cayenne.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 <
> andrus@objectstyle.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

Mime
View raw message