Author: mcaisse Date: Tue May 3 09:11:54 2005 New Revision: 167925 URL: http://svn.apache.org/viewcvs?rev=167925&view=rev Log: JDO-8 interim check-in: ArrayCollections, application identity
Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm (with props) Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Added: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm?rev=167925&view=auto ============================================================================== --- incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm (added) +++ incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm Tue May 3 09:11:54 2005 @@ -0,0 +1,152 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE orm PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects Mapping Metadata 2.0//EN" "http://java.sun.com/dtd/orm_2_0.dtd"> +<!-- +Metadata for application identity +--> +<orm> + <package name="org.apache.jdo.tck.pc.fieldtypes"> + <class name="ArrayCollections" table="ARRAY_COLLECTIONS"> + <field name="identifier" column="IDENTIFIER" primary-key="true"/> + <field name="ArrayOfObject0" table="ARRAY_OF_OBJECT0"> + <join column="IDENTIFIER"/> + <element column="OBJVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfObject1" table="ARRAY_OF_OBJECT1"> + <join column="IDENTIFIER"/> + <element column="OBJVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfSimpleClass2" table="ARRAY_OF_SIMPLE_CLASS2"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfSimpleClass3" table="ARRAY_OF_SIMPLE_CLASS3"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfSimpleInterface4" table="ARRAY_OF_SIMPLE_INTERFACE4"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfSimpleInterface5" table="ARRAY_OF_SIMPLE_INTERFACE5"> + <join column="IDENTIFIER"/> + <element column="SIMPINTVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfString6" table="ARRAY_OF_STRING6"> + <join column="IDENTIFIER"/> + <element column="STRINGVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfString7" table="ARRAY_OF_STRING7"> + <join column="IDENTIFIER"/> + <element column="STRINGVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfDate8" table="ARRAY_OF_DATE8"> + <join column="IDENTIFIER"/> + <element column="DATEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfDate9" table="ARRAY_OF_DATE9"> + <join column="IDENTIFIER"/> + <element column="DATEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfLocale10" table="ARRAY_OF_LOCALE10"> + <join column="IDENTIFIER"/> + <element column="LOCALEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfLocale11" table="ARRAY_OF_LOCALE11"> + <join column="IDENTIFIER"/> + <element column="LOCALEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfBigDecimal12" table="ARRAY_OF_BIG_DECIMAL12"> + <join column="IDENTIFIER"/> + <element column="BIG_DECIMALVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfBigDecimal13" table="ARRAY_OF_BIG_DECIMAL13"> + <join column="IDENTIFIER"/> + <element column="BIG_DECIMALVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfBigInteger14" table="ARRAY_OF_BIG_INTEGER14"> + <join column="IDENTIFIER"/> + <element column="BIG_INTEGERVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfBigInteger15" table="ARRAY_OF_BIG_INTEGER15"> + <join column="IDENTIFIER"/> + <element column="BIG_INTEGERVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfByte16" table="ARRAY_OF_BYTE16"> + <join column="IDENTIFIER"/> + <element column="BYTEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfByte17" table="ARRAY_OF_BYTE17"> + <join column="IDENTIFIER"/> + <element column="BYTEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfDouble18" table="ARRAY_OF_DOUBLE18"> + <join column="IDENTIFIER"/> + <element column="DOUBLEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfDouble19" table="ARRAY_OF_DOUBLE19"> + <join column="IDENTIFIER"/> + <element column="DOUBLEVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfFloat20" table="ARRAY_OF_FLOAT20"> + <join column="IDENTIFIER"/> + <element column="FLOATVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfFloat21" table="ARRAY_OF_FLOAT21"> + <join column="IDENTIFIER"/> + <element column="FLOATVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfInteger22" table="ARRAY_OF_INTEGER22"> + <join column="IDENTIFIER"/> + <element column="INTEGERVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfInteger23" table="ARRAY_OF_INTEGER22"> + <join column="IDENTIFIER"/> + <element column="INTEGERVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfLong24" table="ARRAY_OF_LONG24"> + <join column="IDENTIFIER"/> + <element column="LONGVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfLong25" table="ARRAY_OF_LONG25"> + <join column="IDENTIFIER"/> + <element column="LONGVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfShort26" table="ARRAY_OF_SHORT26"> + <join column="IDENTIFIER"/> + <element column="SHORTVAL"/> + <order column="INDEX"/> + </field> + <field name="ArrayOfShort27" table="ARRAY_OF_SHORT27"> + <join column="IDENTIFIER"/> + <element column="SHORTVAL"/> + <order column="INDEX"/> + </field> + </class> + </package> +</orm> Propchange: incubator/jdo/trunk/tck20/test/orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm ------------------------------------------------------------------------------ svn:executable = * Modified: incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql URL: http://svn.apache.org/viewcvs/incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql?rev=167925&r1=167924&r2=167925&view=diff ============================================================================== --- incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql (original) +++ incubator/jdo/trunk/tck20/test/sql/derby/schema1.sql Tue May 3 09:11:54 2005 @@ -1978,6 +1978,241 @@ FOREIGN KEY (FSN3_N3) REFERENCES FieldSameName (KEY_VALUE) ); +CREATE TABLE ARRAY_COLLECTIONS +( + IDENTIFIER INTEGER NOT NULL, + CONSTRAINT AK12_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_BIG_DECIMAL12 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + CONSTRAINT BD12_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_BIG_DECIMAL13 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + BIG_DECIMALVAL LONG VARCHAR FOR BIT DATA, + CONSTRAINT BD13_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_BIG_INTEGER14 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + CONSTRAINT BI14_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_BIG_INTEGER15 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + BIG_INTEGERVAL BIGINT, + CONSTRAINT BI15_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_BYTE16 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + BYTEVAL SMALLINT, + CONSTRAINT BY16_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_BYTE17 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + BYTEVAL SMALLINT, + CONSTRAINT BY17_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_DATE8 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + DATEVAL DATE, + CONSTRAINT BY8_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_DATE9 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + DATEVAL DATE, + CONSTRAINT BY9_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_DOUBLE18 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + CONSTRAINT DO18_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_DOUBLE19 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + DOUBLEVAL DOUBLE, + CONSTRAINT DO19_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_FLOAT20 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + FLOATVAL FLOAT, + CONSTRAINT FL20 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_FLOAT21 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + FLOATVAL FLOAT, + CONSTRAINT FL21 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_INTEGER22 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + INTEGERVAL INTEGER, + CONSTRAINT IN22 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_INTEGER23 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + INTEGERVAL INTEGER, + CONSTRAINT IN23 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_LOCALE10 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + LOCALEVAL CHAR(20), + CONSTRAINT LOC10 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_LOCALE11 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + LOCALEVAL CHAR(20), + CONSTRAINT LOC11 PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_LONG24 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + LONGVAL BIGINT, + CONSTRAINT BI24_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_LONG25 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + LONGVAL BIGINT, + CONSTRAINT BI25_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_OBJECT0 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + OBJVAL BLOB, + CONSTRAINT OB0_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_OBJECT1 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + OBJVAL BLOB, + CONSTRAINT OB1_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_SHORT26 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + SHORTVAL SMALLINT, + CONSTRAINT SM26_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_SHORT27 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + SHORTVAL SMALLINT, + CONSTRAINT SM27_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_SIMPLE_CLASS2 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_SIMPLE_CLASS3 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_SIMPLE_INTERFACE4 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI4_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_SIMPLE_INTERFACE5 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + SIMPINTERFVAL BLOB, + CONSTRAINT SI5_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_STRING6 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + CONSTRAINT ST6_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAY_OF_STRING7 +( + IDENTIFIER INTEGER REFERENCES ARRAY_COLLECTIONS NOT NULL, + INDEX INTEGER NOT NULL, + STRINGVAL VARCHAR(1024), + CONSTRAINT ST7_PK PRIMARY KEY (IDENTIFIER) +); + +CREATE TABLE ARRAYLISTCOLLECTIONS +( + IDENTIFIER INTEGER NOT NULL +); + ------------------------- --instancecallbacks -------------------------