Interesting.
I get different test failures and errors if I use postgres remotely
than via localhost. Brian McCallister was kind enough to send me his
configuration information, and I noticed he was connecting to the database
via localhost. So, I replicated my ojb-0.9.9 installation on the database
machine.
Using ojb-0.9.9 and postgres-7.3.2 with the latest stable postgres jdbc3
driver.
I only get 3 ODMG junit test errors (no failures) with the database on
localhost.
But I get the following against the same database running OJB remotely on
another (pretty much identically configured) machine:
junit-no-compile-no-prepare:
[junit] Running org.apache.ojb.broker.AllTests
[junit] Tests run: 174, Failures: 12, Errors: 3, Time elapsed: 153.23 sec
[junit] TEST org.apache.ojb.broker.AllTests FAILED
[junit] Running org.apache.ojb.odmg.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/p0/usr/local/jakarta-ojb-0.9.9/target/test/ojb/OJB.properties
[junit] Tests run: 147, Failures: 2, Errors: 5, Time elapsed: 87.414 sec
[junit] TEST org.apache.ojb.odmg.AllTests FAILED
[junit] Running org.apache.ojb.soda.AllTests
[junit] [BOOT] INFO: OJB.properties:
file:/p0/usr/local/jakarta-ojb-0.9.9/target/test/ojb/OJB.properties
[junit] Tests run: 3, Failures: 0, Errors: 0, Time elapsed: 6.9 sec
Below is the summary of Testcases from the broker junit tests.
If I want to run the postgres database on a separate machine (which I will
eventually), where should I start investigating this problem?
Thanks,
yuji
----
Testcase: testDelete took 5.241 sec
Testcase: testDeleteByQuery took 0.778 sec
FAILED
There should be 3 matching items
junit.framework.AssertionFailedError: There should be 3 matching items
at
org.apache.ojb.broker.PersistenceBrokerTest.testDeleteByQuery(PersistenceBrokerTest.java:236)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testDeleteByQueryTestcase: testMappingToOneTableWithAbstractBaseClass took
0.383 sec
Testcase: testExtentWithOneConcreteClassWithOjbConcreteClass took 0.044 sec
Testcase: testMappingToOneTable took 0.118 sec
Testcase: testGetDescriptor took 0.004 sec
Testcase: testGuidFieldConversion took 0.172 sec
Testcase: testRowReader took 0.044 sec
Testcase: testEscaping took 0.327 sec
Testcase: testGetByExampleAndGetByIdentity took 0.041 sec
Testcase: testGetCollectionByQuery took 0.13 sec
Testcase: testGetCollectionByQueryWithStartAndEnd took 0.136 sec
Testcase: testSorting took 0.21 sec
Testcase: testSortedCollectionAttribute took 0.242 sec
Testcase: testAutoIncrement took 0.061 sec
Testcase: testCountByReportQuery took 0.027 sec
FAILED
Iterator should produce 12 items expected:<12> but was:<13>
junit.framework.AssertionFailedError: Iterator should produce 12 items expected:<12>
but was:<13>
at
org.apache.ojb.broker.PersistenceBrokerTest.testCountByReportQuery(PersistenceBrokerTest.java:795)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testCountByReportQueryTestcase: testExtentAwareIteratorByQuery took 0.075 sec
FAILED
Iterator should produce 12 items expected:<12> but was:<13>
junit.framework.AssertionFailedError: Iterator should produce 12 items expected:<12>
but was:<13>
at
org.apache.ojb.broker.PersistenceBrokerTest.testExtentAwareIteratorByQuery(PersistenceBrokerTest.java:822)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testExtentAwareIteratorByQueryTestcase: testGetIteratorByQuery took 0.11 sec
Testcase: testGetIteratorBySQL took 0.07 sec
Testcase: testGetReportQueryIteratorBySQL took 0.08 sec
Testcase: testGetMultipleIteratorsByQuery took 0.331 sec
Testcase: testGetObjectByQuery took 0.436 sec
Testcase: testGetPKEnumerationByConstraints took 0.818 sec
Testcase: testInsert took 0.149 sec
Testcase: testUpdate took 0.048 sec
Testcase: testUpdateWithModification took 0.024 sec
Testcase: testCollectionRetrieval took 0.57 sec
Testcase: testModifications took 2.053 sec
Testcase: testObjectCache took 0.057 sec
Testcase: testShallowAndDeepRetrieval took 0.042 sec
Testcase: testRetrieveReference took 0.032 sec
Testcase: testRetrieveAllReferences took 0.031 sec
Testcase: testProgrammedProxies took 0.063 sec
Testcase: testDynamicProxies took 0.003 sec
Testcase: testCollectionProxies took 0.445 sec
Testcase: testCollectionProxiesAndExtents took 0.101 sec
FAILED
check size expected:<13> but was:<12>
junit.framework.AssertionFailedError: check size expected:<13> but was:<12>
at
org.apache.ojb.broker.ProxyExamples.testCollectionProxiesAndExtents(ProxyExamples.java:307)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testCollectionProxiesAndExtentsTestcase: testReferenceProxies took 0.127 sec
Testcase: testProxiesAndJDBCTransactionIsolation took 0.046 sec
Testcase: testCollectionRetrieval took 0.042 sec
FAILED
check size expected:<13> but was:<12>
junit.framework.AssertionFailedError: check size expected:<13> but was:<12>
at
org.apache.ojb.broker.PolymorphicExtents.testCollectionRetrieval(PolymorphicExtents.java:128)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testCollectionRetrievalTestcase: testCollectionByQuery took 0.034 sec
Testcase: testExtentByQuery took 0.353 sec
Testcase: testRetrieveObjectByIdentity took 0.02 sec
FAILED
should be of type BookArticle
junit.framework.AssertionFailedError: should be of type BookArticle
at
org.apache.ojb.broker.PolymorphicExtents.testRetrieveObjectByIdentity(PolymorphicExtents.java:187)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testRetrieveObjectByIdentityTestcase: testRetrieveReferences took 0.017 sec
Testcase: testCreate took 0.168 sec
Testcase: testTreeGroup took 0.444 sec
Testcase: testArray took 0.434 sec
Testcase: testTypedCollection took 0.178 sec
Testcase: testPolymorphMToN took 0.229 sec
Testcase: testMNLoading took 0.128 sec
Testcase: testMNLoadingUnidirectional took 0.013 sec
Testcase: testLoadingWithAssociationClass took 0.117 sec
Testcase: testInsertion took 0.146 sec
Testcase: testInsertAndDelete took 0.027 sec
Caused an ERROR
0
java.lang.ArrayIndexOutOfBoundsException: 0
at org.apache.ojb.broker.MtoNMapping.testInsertAndDelete(MtoNMapping.java:213)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testInsertAndDeleteTestcase: testDeletion took 0.073 sec
Testcase: testDeleteUnidirectional took 0.1 sec
Testcase: testOneOneReference took 0.118 sec
Testcase: testOneManyReference took 0.063 sec
Testcase: testVersionLock took 0.319 sec
Testcase: testLockHandling took 0.036 sec
Testcase: testTimestampLock took 1.112 sec
Testcase: testEqualCriteria took 0.033 sec
FAILED
null
junit.framework.AssertionFailedError
at org.apache.ojb.broker.QueryTest.testEqualCriteria(QueryTest.java:77)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testEqualCriteriaTestcase: testSubQuery2 took 0.135 sec
FAILED
Result of the query with sub-query does not match expected:<10> but was:<0>
junit.framework.AssertionFailedError: Result of the query with sub-query does not
match expected:<10> but was:<0>
at org.apache.ojb.broker.QueryTest.testSubQuery2(QueryTest.java:118)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testSubQuery2Testcase: testSubQuery1 took 0.129 sec
Testcase: testLikeCriteria took 0.015 sec
FAILED
null
junit.framework.AssertionFailedError
at org.apache.ojb.broker.QueryTest.testLikeCriteria(QueryTest.java:160)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testLikeCriteriaTestcase: testNullCriteria took 0.006 sec
Testcase: testBetweenCriteria took 0.066 sec
Testcase: testInCriteria took 0.006 sec
Testcase: testPathExpressions took 0.085 sec
Testcase: testPathExpressionsMtoNDecomposed took 0.007 sec
Testcase: testPathExpressionsMtoN took 0.007 sec
Testcase: testReportQuery took 0.006 sec
FAILED
null
junit.framework.AssertionFailedError
at org.apache.ojb.broker.QueryTest.testReportQuery(QueryTest.java:284)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testReportQueryTestcase: testReportQueryOrderBy took 0.058 sec
Testcase: testReportQueryGroupBy took 0.347 sec
Testcase: testInversePathExpression took 0.046 sec
Testcase: testPrefetchedCollectionSingleKey took 0.213 sec
Testcase: testNestedJoins took 0.016 sec
Testcase: testMultipleJoins took 0.008 sec
FAILED
null
junit.framework.AssertionFailedError
at org.apache.ojb.broker.QueryTest.testMultipleJoins(QueryTest.java:521)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testMultipleJoinsTestcase: testPrefetchedReferencesSingleKey took 0.417 sec
Testcase: testReportPathExpressionForExtents took 0.045 sec
FAILED
check size expected:<8> but was:<7>
junit.framework.AssertionFailedError: check size expected:<8> but was:<7>
at
org.apache.ojb.broker.QueryTest.testReportPathExpressionForExtents(QueryTest.java:681)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Testcase: testReportPathExpressionForExtentsTestcase: testPathExpressionForExtents1
took 0.145 sec
Testcase: testPathExpressionForExtents2 took 0.149 sec
Testcase: testQueryRangeOneLessThanTotal took 0.146 sec
Testcase: testQueryRangeAllRecords took 0.159 sec
Testcase: testQueryRangeOneMoreThanTotal took 0.137 sec
Testcase: testCreate took 0.303 sec
Testcase: testEqualToFieldQuery took 0.049 sec
Testcase: testSingleJoin took 0.051 sec
Testcase: testNestedJoin took 0.049 sec
Testcase: testMultiNonNestedJoin took 0.045 sec
Testcase: testStoreCallbacks took 0.011 sec
Testcase: testDeleteCallbacks took 0.003 sec
Testcase: testLookupCallback took 0.006 sec
Testcase: testCreateContractVersionEffectiveness took 3.054 sec
Testcase: testUpdateContractVersionEffectiveness took 1.835 sec
Testcase: testDeleteContractVersionEffectiveness took 1.135 sec
Testcase: testUpdate took 0.66 sec
Testcase: testCreate took 1.437 sec
Testcase: testGet took 3.278 sec
Testcase: testDeleteWithData took 2.68 sec
Testcase: testDeleteWithNoData took 1.045 sec
Testcase: testUpdate took 0.637 sec
Testcase: testCreate took 1.479 sec
Testcase: testGet took 4.088 sec
Testcase: testDeleteWithData took 3.018 sec
Testcase: testDeleteWithNoData took 1.083 sec
Testcase: testUpdate took 0.072 sec
Testcase: testCreateWithUpdate took 0.074 sec
Testcase: testGetA took 0.054 sec
Testcase: testGetB took 0.043 sec
Testcase: testDeleteA took 0.041 sec
Testcase: testDeleteB took 0.04 sec
Testcase: testCreateWithoutRelatedObject took 0.046 sec
Testcase: testCreateWithRelatedObject took 0.045 sec
Testcase: testDelete took 0.002 sec
Testcase: testUpdate took 0 sec
Testcase: testCreate took 0.001 sec
Testcase: testRead took 0.001 sec
Testcase: testPolymorphOneToMany took 0.129 sec
Testcase: testUserCommitClearCache took 0.32 sec
Testcase: testUserCommit took 0.447 sec
Testcase: testUserRollbackClearCache took 0.741 sec
Testcase: testUserRollback took 0.932 sec
Testcase: testRollback took 0.153 sec
Testcase: testInsertDelete took 0.324 sec
Testcase: testInsertDifferentObjects took 0.604 sec
Testcase: testInsertDifferentObjectsWithinTransaction took 0.098 sec
Testcase: testIterator took 0.18 sec
Testcase: testPBCreation took 0.018 sec
Testcase: testInsertDeleteNoAutoSequence took 0.82 sec
Testcase: testInsertDeleteAutoSequenceClearCache took 0.154 sec
Testcase: testInsertDeleteAutoSequence took 0.046 sec
Testcase: testWithReference took 0.07 sec
Testcase: testStoreRepository took 0.979 sec
Testcase: testReadCustomAttributes took 0.003 sec
Testcase: testSerializedReadCustomAttributes took 1.717 sec
Testcase: testMultipleAutoincrement took 0.203 sec
Testcase: testSequenceNameAttribute took 0.007 sec
Testcase: testDatabaseSequenceGeneration took 0.005 sec
Testcase: testMaxKeySearch1 took 0.079 sec
Testcase: testMaxKeySearch2 took 0.043 sec
Testcase: testMaxKeySearch3 took 0.153 sec
Testcase: testUniqueAcrossExtendsWithDifferentTables1 took 0.611 sec
Testcase: testUniqueAcrossExtendsWithDifferentTables2 took 0.602 sec
Testcase: testUniqueAcrossExtendsWithDifferentTables3 took 0.595 sec
Testcase: testUniqueAcrossExtendsWithSameTable1 took 1.054 sec
Testcase: testUniqueAcrossExtendsWithSameTable3 took 1.073 sec
Testcase: testUniqueAcrossExtendsWithSameTable4 took 0.59 sec
Testcase: testUniqueAcrossExtendsWithSameTable5 took 0.566 sec
Testcase: testGetUniqueIdWithOneBroker took 0.052 sec
Testcase: testSequenceGeneration took 60.073 sec
Testcase: testForLostKeys took 0.109 sec
Testcase: testConvertedReferenceLookup took 0.027 sec
Testcase: testConvertedReferenceInsert took 0.328 sec
Caused an ERROR
ERROR: Cannot insert a duplicate key into unique index conv_refered_pkey
java.sql.SQLException: ERROR: Cannot insert a duplicate key into unique index
conv_refered_pkey
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:199)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1742)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1683)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:632)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:151)
at
org.apache.ojb.broker.ConvertedKeyReferenceTest.testConvertedReferenceInsert(ConvertedKeyReferenceTest.java:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: ERROR: Cannot insert
a duplicate key into unique index conv_refered_pkey
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:218)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.storeToDb(PersistenceBrokerImpl.java:1742)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:1683)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:632)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:151)
at
org.apache.ojb.broker.ConvertedKeyReferenceTest.testConvertedReferenceInsert(ConvertedKeyReferenceTest.java:78)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: java.sql.SQLException: ERROR: Cannot insert a duplicate key into unique
index conv_refered_pkey
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeUpdate(AbstractJdbc1Statement.java:197)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeInsert(JdbcAccessImpl.java:199)
... 21 more
Testcase: testConvertedReferenceInsertTestcase: testKeyViolation took 0.12 sec
Testcase: testIterator took 0.04 sec
Testcase: testLogggers took 0.003 sec
Testcase: testDelete took 0.001 sec
Testcase: testUpdate took 0 sec
Testcase: testCreate took 0 sec
Testcase: testRead took 0.001 sec
Testcase: testDelete took 0.002 sec
Testcase: testUpdate took 0 sec
Testcase: testCreate took 0 sec
Testcase: testRead took 0 sec
Testcase: testMassOperations took 1.975 sec
Testcase: testClassDescriptorSerialization took 26.863 sec
Testcase: testToDisk took 0.46 sec
Testcase: testFromDisk took 0.912 sec
Testcase: testRemote took 0.001 sec
Testcase: testIdentityStuff took 0 sec
Testcase: testRuntimeMetadataChanges took 0.838 sec
Testcase: testTimeToCopyRepository took 1.339 sec
Testcase: testReadConnectionDescriptor took 0.003 sec
Testcase: testStoreNode took 0.055 sec
Caused an ERROR
ERROR: Unable to identify an operator '=' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast
java.sql.SQLException: ERROR: Unable to identify an operator '=' for types 'numeric'
and 'float8'
You will have to retype this query using an explicit cast
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAccessImpl.java:494)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:627)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:151)
at
org.apache.ojb.broker.FieldConversionForeigenKeyTest.testStoreNode(FieldConversionForeigenKeyTest.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
rethrown as org.apache.ojb.broker.PersistenceBrokerSQLException: ERROR: Unable to
identify an operator '=' for types 'numeric' and 'float8'
You will have to retype this query using an explicit cast
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAccessImpl.java:515)
at
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.store(PersistenceBrokerImpl.java:627)
at
org.apache.ojb.broker.singlevm.DelegatingPersistenceBroker.store(DelegatingPersistenceBroker.java:151)
at
org.apache.ojb.broker.FieldConversionForeigenKeyTest.testStoreNode(FieldConversionForeigenKeyTest.java:71)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
Caused by: java.sql.SQLException: ERROR: Unable to identify an operator '=' for types
'numeric' and 'float8'
You will have to retype this query using an explicit cast
at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:131)
at
org.postgresql.jdbc1.AbstractJdbc1Connection.ExecSQL(AbstractJdbc1Connection.java:505)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:320)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:48)
at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:153)
at
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(JdbcAccessImpl.java:494)
... 19 more
Testcase: testStoreNode
yuji
----
On Wed, 26 Feb 2003, Mahler Thomas wrote:
> Hi Yuji,
>
> We currently have about 6 failures and errors in CVS head. SO having 12
> problems with a non-hsqldb platform is not bad.
>
> Did you check the junit logs under target/test ?
> Do the logs indicate any problems with functionality that you need?
>
> In most cases it's only some special things that do not work, but do only
> affect 1% of all applications.
>
> cheers,
> Thomas
>
> > -----Original Message-----
> > From: Yuji Shinozaki [mailto:[EMAIL PROTECTED]
> > Sent: Wednesday, February 26, 2003 2:38 PM
> > To: OJB Users List
> > Subject: OJB/Postgres configuration recipe?
> >
> >
> > Does someone have a "recipe" for configuring OJB with
> > Postgres (7.3.2)?
> >
> > I have just started using OJB, and I have the task of applying it to a
> > project (with a fairly short deadline). The mapping and
> > caching features
> > promise to be a tremendous time saver, but I am now stuck on
> > getting the
> > junit tests to resolve satisfactorily.
> >
> > I am getting about over 12 failures and errors in the junit
> > tests (the PB
> > tests mainly) using both ojb-0.9.9 and the ojb from CVS HEAD.
> > I am using
> > postgres 7.3.2 with the latest stable jdbc3 driver. I have
> > tried various
> > profiles settings, but the junit failures remain about
> > constant. Now, I
> > know there are some failures due to the state of the ojb
> > codebase but they
> > seem to account for only 3 of them.
> >
> > Before I start diving deeper into the configuration, could
> > someone tell me
> > a configuration which has worked for them to use as a
> > starting point? OR
> > pointers to issues that I should deal with?
> >
> > Thanks!
> > yuji
> > ----
> > Yuji Shinozaki Computer
> > Systems Senior Engineer
> > [EMAIL PROTECTED] Advanced Technologies Group
> > (804)924-7171 Information Technology
> > & Communication
> > http://www.people.virginia.edu/~ys2n University of Virginia
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
Yuji Shinozaki Computer Systems Senior Engineer
[EMAIL PROTECTED] Advanced Technologies Group
(804)924-7171 Information Technology & Communication
http://www.people.virginia.edu/~ys2n University of Virginia
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
