You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jdo-commits@db.apache.org by mc...@apache.org on 2005/05/03 18:11:55 UTC
svn commit: r167925 - in /incubator/jdo/trunk/tck20/test:
orm/applicationidentity/org/apache/jdo/tck/pc/fieldtypes/ArrayCollections-derby.orm
sql/derby/schema1.sql
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
-------------------------