| Michael Watzek 2005-07-25, 5:45 pm |
| Hi Andy, Erik,
I adapted the mapping using inheritance strategy "new-table" (which I
sent in my previous mail) to datastore identity.
The completeness test fails throwing the exception below. The exception
is also thrown at check time. Object have been made persistent without
errors. The database does not contain reasonable entries: Both
inheritance hierarchies only have entries for tables mapped by the base
classes, e.g. Person and Insurance. Both tables have more entries than
expected. Subclass tables do not contain any entries.
I attached the schema file and the orm file. Can you please check them also?
Regards,
Michael
[java] 1)
test(org.apache.jdo.tck.mapping.CompletenessTest)javax.jdo.JDODataStoreException:
Size request failed : SELECT COUNT(*) FROM datastoreidentity1.PERSONS
WHERE DEPARTMENT = ?
[java] at
org.jpox.store.rdbms.scostore.AbstractSetStore.size(AbstractSetStore.java:281)
[java] at org.jpox.sco.Collection.size(Collection.java:485)
[java] at
org.apache.jdo.tck.util.EqualityHelper.deepEquals(EqualityHelper.java:169)
[java] at
org.apache.jdo.tck.pc.company.Department.deepCompareFields(Department.java:235)
[java] at
org.apache.jdo.tck.mapping.CompletenessTest.test(CompletenessTest.java:99)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197)
[java] at
org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)
[java] at
org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)
[java] NestedThrowablesStackTrace:
[java] ERROR 42X04: Column 'DEPARTMENT' is not in any table in the
FROM list or it appears within a join specification and is outside the
scope of the join specification or it appears in a HAVING clause and is
not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement
then 'DEPARTMENT' is not a column in the target table.
[java] at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
[java] at
org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(ColumnReference.java)
[java] at
org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java)
[java] at
org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(BinaryComparisonOperato
rNode.java)
[java] at
org.apache.derby.impl.sql.compile.SelectNode.bindExpressions(SelectNode.java)
[java] at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindExpressions(DMLStatementNode.java)
[java] at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java)
[java] at
org.apache.derby.impl.sql.compile.ReadCursorNode.bind(ReadCursorNode.java)
[java] at
org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java)
[java] at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java)
[java] at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
[java] at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLangu
ageConnectionContext.java)
[java] at
org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java)
[java] at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java)
[java] at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java)
[java] at
org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java)
[java] at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
[java] at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java)
[java] at
com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:303)
[java] at
org.jpox.store.rdbms.scostore.AbstractSetStore.size(AbstractSetStore.java:242)
[java] at org.jpox.sco.Collection.size(Collection.java:485)
[java] at
org.apache.jdo.tck.util.EqualityHelper.deepEquals(EqualityHelper.java:169)
[java] at
org.apache.jdo.tck.pc.company.Department.deepCompareFields(Department.java:235)
[java] at
org.apache.jdo.tck.mapping.CompletenessTest.test(CompletenessTest.java:99)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native
Method)
[java] at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[java] at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[java] at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:197)
[java] at
org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:128)
[java] at
org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:106)
--
-------------------------------------------------------------------
Michael Watzek Tech@Spree Engineering GmbH
mailto:mwa.tech@spree.de Buelowstr. 66
Tel.: ++49/30/235 520 36 10783 Berlin - Germany
Fax.: ++49/30/217 520 12 http://www.spree.de/
-------------------------------------------------------------------
|