db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael Watzek <mwa.t...@spree.de>
Subject Exception using datastore identity, inheritance strategy "new-table"
Date Mon, 25 Jul 2005 16:32:58 GMT
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/
-------------------------------------------------------------------

Mime
View raw message