Hi Eric, Andy,
Can you please take a look at this? I can't get any of the Extent tests to run. I've checked in everything into svn except for the attached diffs, and I run the single test CloseAll. I've modified the schema to the requirements of the "org.jpox.validateTables" output and still no go.
diffs
Description: Binary data
maven -Dtest=extents.CloseAll runtck.jdorisingle
Here's the output I get:
...
ij> -------------------------
[java] -- company
[java] -------------------------
[java]
[java] DROP TABLE insuranceplans;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE project_reviewer;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE project_member;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE employee_phoneno_type;
[java] 0 rows inserted/updated/deleted
[java] ij> ALTER TABLE departments DROP CONSTRAINT EMP_MO_FK;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE persons;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE projects;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE departments;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE companies;
[java] 0 rows inserted/updated/deleted
[java] ij> DROP TABLE address;
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE address (
[java] ADDRESS_ID DECIMAL(19) NOT NULL,
[java] STREET VARCHAR(64),
[java] CITY VARCHAR(64),
[java] STATE VARCHAR(2),
[java] ZIPCODE VARCHAR(5),
[java] COUNTRY VARCHAR(64),
[java] CONSTRAINT ADDRESS_PK PRIMARY KEY(ADDRESS_ID)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE companies (
[java] ID INTEGER NOT NULL,
[java] NAME VARCHAR(32) NOT NULL,
[java] FOUNDED_DATE DATE NOT NULL,
[java] STREET VARCHAR(64),
[java] CITY VARCHAR(64),
[java] STATE VARCHAR(2),
[java] ZIPCODE VARCHAR(5),
[java] COUNTRY VARCHAR(64),
[java] CONSTRAINT COMPS_PK PRIMARY KEY (ID)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE departments (
[java] ID INTEGER NOT NULL,
[java] NAME VARCHAR(32) NOT NULL,
[java] EMP_OF_THE_MONTH INTEGER,
[java] COMPANYID INTEGER REFERENCES companies,
[java] CONSTRAINT DEPTS_PK PRIMARY KEY (ID)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE persons (
[java] PERSONID INTEGER NOT NULL,
[java] FIRSTNAME VARCHAR(32) NOT NULL,
[java] LASTNAME VARCHAR(32) NOT NULL,
[java] MIDDLENAME VARCHAR(32),
[java] BIRTHDATE DATE NOT NULL,
[java] STREET VARCHAR(64),
[java] CITY VARCHAR(64),
[java] STATE VARCHAR(2),
[java] ZIPCODE VARCHAR(5),
[java] COUNTRY VARCHAR(64),
[java] HIREDATE DATE,
[java] WEEKLYHOURS FLOAT,
[java] DEPARTMENT INTEGER REFERENCES departments,
[java] FUNDING_DEPT INTEGER REFERENCES departments,
[java] MANAGER INTEGER REFERENCES persons,
[java] MENTOR INTEGER REFERENCES persons,
[java] HRADVISOR INTEGER REFERENCES persons,
[java] SALARY FLOAT,
[java] WAGE FLOAT,
[java] DISCRIMINATOR varchar(64) NOT NULL,
[java] CONSTRAINT EMPS_PK PRIMARY KEY (PERSONID)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE insuranceplans (
[java] INSID INTEGER NOT NULL,
[java] CARRIER VARCHAR(64) NOT NULL,
[java] LIFETIME_ORTHO_BENEFIT DECIMAL(19),
[java] PLAN_TYPE VARCHAR(8),
[java] DISCRIMINATOR varchar(64) NOT NULL,
[java] EMPLOYEE INTEGER REFERENCES persons,
[java] CONSTRAINT INS_PK PRIMARY KEY (INSID)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE projects (
[java] PROJID INTEGER NOT NULL,
[java] NAME VARCHAR(32) NOT NULL,
[java] BUDGET DECIMAL(19) NOT NULL,
[java] CONSTRAINT PROJS_PK PRIMARY KEY (PROJID)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE project_reviewer (
[java] PROJID INTEGER REFERENCES projects NOT NULL,
[java] REVIEWER INTEGER REFERENCES persons NOT NULL,
[java] CONSTRAINT PROJ_REVIEWER_PK PRIMARY KEY (PROJID, REVIEWER)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE project_member (
[java] PROJID INTEGER REFERENCES projects NOT NULL,
[java] MEMBER INTEGER REFERENCES persons NOT NULL,
[java] CONSTRAINT PROJ_MEMBER_PK PRIMARY KEY (PROJID, MEMBER)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> CREATE TABLE employee_phoneno_type (
[java] PERSONID INTEGER REFERENCES persons NOT NULL,
[java] ADPT_PK_IDX INTEGER NOT NULL,
[java] PHONENO VARCHAR(16) NOT NULL,
[java] TYPE VARCHAR(16) NOT NULL,
[java] CONSTRAINT PK PRIMARY KEY (PERSONID, ADPT_PK_IDX)
[java] );
[java] 0 rows inserted/updated/deleted
[java] ij> ALTER TABLE departments
[java] ADD CONSTRAINT EMP_MO_FK FOREIGN KEY
[java] (EMP_OF_THE_MONTH) REFERENCES persons(PERSONID)
[java] ;
[java] 0 rows inserted/updated/deleted
runtck.jdorisingle:
[echo] Run TCK test org.apache.jdo.tck.extents.CloseAll on the RI with configuration /Users/clr/apachejdo/jdo/trunk/tck20/test/conf/applicationidentity.conf
[java] RUN CloseAll.test ERROR
[java] Time: 12.078
[java] There was 1 error:
[java] 1) test(org.apache.jdo.tck.extents.CloseAll)java.lang.IndexOutOfBoundsExcep tion: Index: 0, Size: 0
[java] at java.util.ArrayList.RangeCheck(ArrayList.java:507)
[java] at java.util.ArrayList.get(ArrayList.java:324)
[java] at org.jpox.store.mapping.JavaTypeMapping.getDataStoreMapping(JavaTypeMappi ng.java:110)
[java] at org.jpox.store.mapping.SingleFieldMapping.setObject(SingleFieldMapping.j ava:235)
[java] at org.jpox.store.mapping.PersistenceCapableMapping.setObject(PersistenceCa pableMapping.java:211)
[java] at org.jpox.store.rdbms.fieldmanager.ParameterSetter.storeObjectField(Param eterSetter.java:130)
[java] at org.jpox.state.StateManagerImpl.providedObjectField(StateManagerImpl.jav a:2315)
[java] at org.apache.jdo.tck.pc.company.Employee.jdoProvideField(Employee.java)
[java] at org.apache.jdo.tck.pc.company.FullTimeEmployee.jdoProvideField(FullTimeE mployee.java)
[java] at org.apache.jdo.tck.pc.company.Person.jdoProvideFields(Person.java)
[java] at org.jpox.state.StateManagerImpl.provideFields(StateManagerImpl.java: 2594)
[java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java: 226)
[java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:1686)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:616)
[java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl. java:2938)
[java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java: 2911)
[java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersi stenceManager.java:958)
[java] at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMa nager.java:1006)
[java] at org.jpox.store.rdbms.scostore.InverseSetStore.add(InverseSetStore.java: 387)
[java] at org.jpox.store.rdbms.scostore.InverseSetStore.addAll(InverseSetStore.jav a:428)
[java] at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.ja va:156)
[java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java: 298)
[java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:1686)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:616)
[java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl. java:2938)
[java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java: 2911)
[java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersi stenceManager.java:958)
[java] at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMa nager.java:1006)
[java] at org.jpox.store.rdbms.scostore.InverseSetStore.add(InverseSetStore.java: 387)
[java] at org.jpox.store.rdbms.scostore.InverseSetStore.addAll(InverseSetStore.jav a:428)
[java] at org.jpox.store.mapping.CollectionMapping.postInsert(CollectionMapping.ja va:156)
[java] at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java: 298)
[java] at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:1686)
[java] at org.jpox.store.StoreManager.insert(StoreManager.java:616)
[java] at org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl. java:2938)
[java] at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java: 2911)
[java] at org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersi stenceManager.java:958)
[java] at org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceMa nager.java:994)
[java] at org.apache.jdo.tck.extents.ExtentTest.initDB(ExtentTest.java:169)
[java] at org.apache.jdo.tck.extents.ExtentTest.checkPM(ExtentTest.java:82)
[java] at org.apache.jdo.tck.extents.ExtentTest.getPM(ExtentTest.java:237)
[java] at org.apache.jdo.tck.extents.ExtentTest.beginTransaction(ExtentTest.java: 252)
[java] at org.apache.jdo.tck.extents.CloseAll.test(CloseAll.java:58)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.jav a:39)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor Impl.java:25)
[java] at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:147)
[java] at org.apache.jdo.tck.util.BatchTestRunner.run(BatchTestRunner.java:75)
[java] at org.apache.jdo.tck.util.BatchTestRunner.run(BatchTestRunner.java:70)
[java] at org.apache.jdo.tck.extents.CloseAll.main(CloseAll.java:52)
[java] FAILURES!!!
[java] Tests run: 1, Failures: 0, Errors: 1
BUILD SUCCESSFUL
Total time: 36 seconds
Finished at: Sat Apr 23 14:55:49 PDT 2005
On Apr 23, 2005, at 12:16 AM, [EMAIL PROTECTED] wrote:
Hi,
Shouldn't the PCRECT table should have two foreign keys to PCPOINT?
Regards,
Erik Bengtson
Craig Russell Architect, Sun Java Enterprise System http://java.sun.com/products/jdo 408 276-5638 mailto:[EMAIL PROTECTED] P.S. A good JDO? O, Gasp!
smime.p7s
Description: S/MIME cryptographic signature
