Return-Path: 
 <open-jpa-dev-return-905-apmail-incubator-open-jpa-dev-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org
Received: (qmail 24000 invoked from network); 17 Oct 2006 20:38:52 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 17 Oct 2006 20:38:52 -0000
Received: (qmail 78840 invoked by uid 500); 17 Oct 2006 20:38:51 -0000
Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org
Received: (qmail 78813 invoked by uid 500); 17 Oct 2006 20:38:51 -0000
Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:open-jpa-dev-help@incubator.apache.org>
List-Unsubscribe: <mailto:open-jpa-dev-unsubscribe@incubator.apache.org>
List-Post: <mailto:open-jpa-dev@incubator.apache.org>
List-Id: <open-jpa-dev.incubator.apache.org>
Reply-To: open-jpa-dev@incubator.apache.org
Delivered-To: mailing list open-jpa-dev@incubator.apache.org
Received: (qmail 78804 invoked by uid 99); 17 Oct 2006 20:38:51 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Oct 2006 13:38:51 -0700
X-ASF-Spam-Status: No, hits=2.0 required=10.0
	tests=HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [66.160.117.11] (HELO ptint5.peacetech.com) (66.160.117.11)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Oct 2006 13:38:43 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C6F22C.27941508"
Subject: RE: Why would Kodo refuse to batch inserts in certain tables? Big
 performance drop migrating to Kodo 4.1
Date: Tue, 17 Oct 2006 16:38:07 -0400
Message-ID: <49BF64BA795F6A498EC2F04F39BAA8D3D97EDE@ptint5.peacetech.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Why would Kodo refuse to batch inserts in certain tables? Big
 performance drop migrating to Kodo 4.1
Thread-Index: AcbyK7xjmQ1Qz1//TeqRwdVHoP/rtgAACoZg
From: "Roytman, Alex" <Roytmana@peacetech.com>
To: <open-jpa-dev@incubator.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------_=_NextPart_001_01C6F22C.27941508
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Yes it will be wrapped by email though

=20

15  WARN   [main] openjpa.Runtime - The property named
"kodo.jdbc.SequenceFactory" was not recognized and will be ignored,
although the name closely matches a valid property called
"kodo.jdbc.SchemaFactory".

15  WARN   [main] openjpa.Runtime - The property named
"kodo.jdbc.ClassIndicator" was not recognized and will be ignored,
although the name closely matches a valid property called
"kodo.jdbc.MappingFactory".

47  INFO   [main] openjpa.Runtime - Starting BEA Kodo 4.1.0 with
patches:=20

    Kodo JDO Utilities vtip-revision

62  INFO   [main] openjpa.jdbc.JDBC - Using dictionary class
"org.apache.openjpa.jdbc.sql.OracleDictionary".

328  INFO   [main] openjpa.jdbc.JDBC - oracle-batch-override

1578  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 21057622 SELECT t0.JDO_LOCK, t0.IS_ACTIVE,
t0.DEFAULT_VALUE, t0.DESCRIPTION, t0.IS_LOOKUP, t0.LOOKUP_SORT_ORDER,
t0.IS_MULTI_VALUE FROM DTS.PROPERTY_DEFINITION t0 WHERE t0.NAME =3D ?
[params=3D(String) IC]

1578  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1593  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 21057622 SELECT t0.JDO_LOCK, t0.IS_ACTIVE,
t0.DEFAULT_VALUE, t0.DESCRIPTION, t0.IS_LOOKUP, t0.LOOKUP_SORT_ORDER,
t0.IS_MULTI_VALUE FROM DTS.PROPERTY_DEFINITION t0 WHERE t0.NAME =3D ?
[params=3D(String) DocType]

1593  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1593  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 21057622 SELECT t0.JDO_LOCK, t0.IS_ACTIVE,
t0.DEFAULT_VALUE, t0.DESCRIPTION, t0.IS_LOOKUP, t0.LOOKUP_SORT_ORDER,
t0.IS_MULTI_VALUE FROM DTS.PROPERTY_DEFINITION t0 WHERE t0.NAME =3D ?
[params=3D(String) GC]

1593  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1593  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 21057622 SELECT t0.JDO_LOCK, t0.IS_ACTIVE,
t0.DEFAULT_VALUE, t0.DESCRIPTION, t0.IS_LOOKUP, t0.LOOKUP_SORT_ORDER,
t0.IS_MULTI_VALUE FROM DTS.PROPERTY_DEFINITION t0 WHERE t0.NAME =3D ?
[params=3D(String) ClauseId]

1593  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 15513215 INSERT INTO DTS.DOCUMENT (DOCUMENT_NODE_ID,
DOCUMENT_NUMBER, TEMPLATE_ID, ORG_UNIT_ID, PREPARER, TITLE,
IS_PUBLISHED, PUBLISH_DATE) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
[params=3D(long) 529800, (String) {529800}, (long) 9432, (long) 1, =
(long)
1, (null) null, (int) 0, (null) null]

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 12675864 INSERT INTO DTS.DOCUMENT_FIELD
(DOCUMENT_NODE_ID, NAME, CONTENT_ID, VALUE, JDO_CLASS, JDO_LOCK) VALUES
(?, ?, ?, ?, ?, ?) [params=3D(long) 529802, (String) preferences, (long)
2117, (null) null, (int) 520, (int) 1]

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 12675864 INSERT INTO DTS.DOCUMENT_FIELD
(DOCUMENT_NODE_ID, NAME, CONTENT_ID, VALUE, JDO_CLASS, JDO_LOCK) VALUES
(?, ?, ?, ?, ?, ?) [params=3D(long) 529801, (String) preferences, (long)
2116, (null) null, (int) 520, (int) 1]

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 12675864 INSERT INTO DTS.DOCUMENT_FIELD
(DOCUMENT_NODE_ID, NAME, CONTENT_ID, VALUE, JDO_CLASS, JDO_LOCK) VALUES
(?, ?, ?, ?, ?, ?) [params=3D(long) 529802, (String) address, (long) =
2117,
(null) null, (int) 510, (int) 1]

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 12675864 INSERT INTO DTS.DOCUMENT_FIELD
(DOCUMENT_NODE_ID, NAME, CONTENT_ID, VALUE, JDO_CLASS, JDO_LOCK) VALUES
(?, ?, ?, ?, ?, ?) [params=3D(long) 529801, (String) address, (long) =
2116,
(null) null, (int) 510, (int) 1]

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1625  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 12675864 INSERT INTO DTS.DOCUMENT_FIELD
(DOCUMENT_NODE_ID, NAME, CONTENT_ID, VALUE, JDO_CLASS, JDO_LOCK) VALUES
(?, ?, ?, ?, ?, ?) [params=3D(long) 529801, (String) address, (long) =
2116,
(null) null, (int) 510, (int) 1]

1640  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [15
ms] spent

1640  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 6169134 INSERT INTO DTS.DOCUMENT_NODE
(DOCUMENT_NODE_ID, OWNER_DOCUMENT, LOCAL_ROOT, PARENT, NAME,
CREATE_DATE, UPDATE_DATE, UPDATE_USER, JDO_CLASS, JDO_LOCK) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?, ?) [params=3D(long) 529800, (long) 529800, =
(long)
529800, (null) null, (String) d529800, (Date) 2006-10-16, (Date)
2006-10-16, (String) dts.test, (int) 440, (int) 1]

1640  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1640  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 1440568 INSERT INTO DTS.DOCUMENT_NODE
(DOCUMENT_NODE_ID, OWNER_DOCUMENT, LOCAL_ROOT, PARENT,
PARENT_SORT_ORDER, NAME, CONTENT_ID, ORIGINAL_CONTENT, REFERENCE_NUMBER,
IS_GROUP, IS_SELECTED_BY_USER, IS_SELECTED_BY_RULE, CREATE_DATE,
UPDATE_DATE, UPDATE_USER, JDO_CLASS, JDO_LOCK) VALUES (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=3D(long) 529801, (long) 529800,
(long) 529800, (long) 529800, (int) 0, (String) t1, (long) 2116, (null)
null, (null) null, (int) 0, (null) null, (int) 0, (Date) 2006-10-16,
(Date) 2006-10-16, (String) dts.test, (int) 430, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [16
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 1440568 INSERT INTO DTS.DOCUMENT_NODE
(DOCUMENT_NODE_ID, OWNER_DOCUMENT, LOCAL_ROOT, PARENT,
PARENT_SORT_ORDER, NAME, CONTENT_ID, ORIGINAL_CONTENT, REFERENCE_NUMBER,
IS_GROUP, IS_SELECTED_BY_USER, IS_SELECTED_BY_RULE, CREATE_DATE,
UPDATE_DATE, UPDATE_USER, JDO_CLASS, JDO_LOCK) VALUES (?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [params=3D(long) 529802, (long) 529800,
(long) 529800, (long) 529801, (int) 0, (String) t1.1, (long) 2117,
(null) null, (null) null, (int) 0, (null) null, (int) 0, (Date)
2006-10-16, (Date) 2006-10-16, (String) dts.test, (int) 430, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529802, (String) IC, (String) IC1, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529801, (String) ClauseId, (String) CRS, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529802, (String) GC, (String) CRS, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529800, (String) DocType, (String) RFP, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529802, (String) GC, (String) EDUC, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529801, (String) GC, (String) CRS, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529802, (String) ClauseId, (String) CRS, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529800, (String) IC, (String) NHLBI, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529802, (String) IC, (String) IC2, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529801, (String) GC, (String) EDUC, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529800, (String) IC, (String) NCI, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529801, (String) IC, (String) IC1, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
batching prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529801, (String) IC, (String) IC2, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164>
executing prepstmnt 18895884 INSERT INTO DTS.DOCUMENT_NODE_PROPERTY
(DOCUMENT_NODE_ID, NAME, VALUE, JDO_LOCK) VALUES (?, ?, ?, ?)
[params=3D(long) 529801, (String) IC, (String) IC2, (int) 1]

1656  TRACE  [main] openjpa.jdbc.SQL - <t 28035001, conn 15038164> [0
ms] spent

=20

=20

=20

=20

<?xml version=3D"1.0" encoding=3D"UTF-8"?>

<!DOCTYPE jdo PUBLIC "-//Sun Microsystems, Inc.//DTD Java Data Objects
Metadata 2.0//EN" "http://java.sun.com/dtd/jdo_2_0.dtd">

<jdo>

  <package name=3D"com.peacetech.dts.jdo">

=20

    <interface name=3D"com.peacetech.dts.ApplicationProperty"/>

=20

    <class name=3D"ApplicationPropertyImpl" =
table=3D"APPLICATION_PROPERTY"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.ApplicationPropertyImpl$OID">

      <implements name=3D"com.peacetech.dts.ApplicationProperty"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"name" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"value">

        <column name=3D"VALUE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"250" scale=3D"0"/>

      </field>

      <field name=3D"modifiable" null-value=3D"exception">

        <column name=3D"MODIFIABLE" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"runtimeModifiable" null-value=3D"exception">

        <column name=3D"RUNTIME_MODIFIABLE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"256" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Attribute"/>

=20

    <class name=3D"AttributeImpl" table=3D"ATTRIBUTE"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.AttributeImpl$OID">

      <implements name=3D"com.peacetech.dts.Attribute"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"ATTRIBUTE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"name" null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"200" scale=3D"0"/>

      </field>

      <field name=3D"active" null-value=3D"exception">

        <column name=3D"IS_ACTIVE" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"shared" null-value=3D"exception">

        <column name=3D"IS_SHARED" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"lookup" null-value=3D"exception">

        <column name=3D"IS_LOOKUP" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"lookupSortOrder" null-value=3D"exception"
persistence-modifier=3D"persistent" default-fetch-group=3D"true">

        <extension vendor-name=3D"kodo" key=3D"externalizer"
value=3D"toSqlValue"/>

        <extension vendor-name=3D"kodo" key=3D"factory"
value=3D"fromSqlValue"/>

        <column name=3D"LOOKUP_SORT_ORDER" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"9" scale=3D"0"/>

      </field>

      <field name=3D"multiValue" null-value=3D"exception">

        <column name=3D"IS_MULTI_VALUE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"required" null-value=3D"exception">

        <column name=3D"IS_REQUIRED" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"defaultValue">

        <column name=3D"DEFAULT_VALUE" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"100" scale=3D"0"/>

      </field>

      <field name=3D"lookupValues" table=3D"ATTRIBUTE_LOOKUP"
mapped-by=3D"attribute"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.AttributeLookupImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"AttributeImpl.lookupValues"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.AttributeLookup"/>

=20

    <class name=3D"AttributeLookupImpl" table=3D"ATTRIBUTE_LOOKUP"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.AttributeLookupImpl$OID">

      <implements name=3D"com.peacetech.dts.AttributeLookup"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"attributeId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"ATTRIBUTE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"code" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"CODE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"16" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"120" scale=3D"0"/>

      </field>

      <field name=3D"shortDescription">

        <column name=3D"SHORT_DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"64" scale=3D"0"/>

      </field>

      <field name=3D"sortOrder" null-value=3D"exception">

        <column name=3D"SORT_ORDER" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"9" scale=3D"0"/>

      </field>

      <field name=3D"attribute"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"ATTRIBUTE_ID" target=3D"ATTRIBUTE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"AttributeLookupImpl.attribute"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Component"/>

=20

    <class name=3D"ComponentImpl" table=3D"COMPONENT"
identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.TemplateNodeImpl"=
>

      <implements name=3D"com.peacetech.dts.Component"/>

=20

      <inheritance strategy=3D"new-table">

        <join>

          <column name=3D"TEMPLATE_NODE_ID" =
target=3D"TEMPLATE_NODE_ID"/>

        </join>

        <discriminator value=3D"110"/>

      </inheritance>

      <field name=3D"released" null-value=3D"exception">

        <column name=3D"IS_RELEASED" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"effectiveDate">

        <column name=3D"EFFECTIVE_DATE" jdbc-type=3D"DATE" =
sql-type=3D"DATE"
length=3D"7" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"200" scale=3D"0"/>

      </field>

      <field name=3D"preparer"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"PREPARER" target=3D"EMPLOYEE_ID" =
jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ComponentImpl.preparer"/>

      </field>

      <field name=3D"orgUnit"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"ORG_UNIT_ID" target=3D"ORG_UNIT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ComponentImpl.orgUnit"/>

      </field>

      <field name=3D"container"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"CONTAINER_ID" target=3D"CONTAINER_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ComponentImpl.container"/>

      </field>

       <field name=3D"attributes" table=3D"COMPONENT_ATTRIBUTE"> <!-- =
M-N
-->

        <collection =
element-type=3D"com.peacetech.dts.jdo.AttributeImpl"/>

        <join>

          <column name=3D"TEMPLATE_NODE_ID" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        </join>

        <element>

          <column name=3D"ATTRIBUTE_ID" target=3D"ATTRIBUTE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        </element>

        <order column=3D"SORT_ORDER"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ComponentImpl.attributes"/>

      </field>

    </class>

 =20

    <interface name=3D"com.peacetech.dts.Container"/>

=20

    <class name=3D"ContainerImpl" table=3D"CONTAINER"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.ContainerImpl$OID">

      <implements name=3D"com.peacetech.dts.Container"/>

      <inheritance strategy=3D"new-table">

        <discriminator strategy=3D"value-map" value=3D"300"
column=3D"JDO_CLASS"/>

      </inheritance>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"CONTAINER_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"name" null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"48" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"400" scale=3D"0"/>

      </field>

      <field name=3D"parent" >  <!-- N-1 (ref) -->

        <column name=3D"PARENT" target=3D"CONTAINER_ID" =
jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContainerImpl.parent"/>

      </field>

      <field name=3D"subNodes" table=3D"CONTAINER" mapped-by=3D"parent"> =
<!--
1-N -->

        <collection =
element-type=3D"com.peacetech.dts.jdo.ContainerImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContainerImpl.subNodes"/>

      </field>

      <field name=3D"properties" table=3D"CONTAINER_PROPERTY"
mapped-by=3D"container"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.ContainerPropertyImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContainerImpl.properties"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.ContainerProperty"/>

=20

    <class name=3D"ContainerPropertyImpl" table=3D"CONTAINER_PROPERTY"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.ContainerPropertyImpl$OID">

      <implements name=3D"com.peacetech.dts.ContainerProperty"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"containerId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"CONTAINER_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"nameId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"value" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"VALUE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"container"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"CONTAINER_ID" target=3D"CONTAINER_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContainerPropertyImpl.container"/>

      </field>

      <field name=3D"definition"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"NAME" target=3D"NAME" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContainerPropertyImpl.definition"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Content"/>

=20

    <class name=3D"ContentImpl" table=3D"CONTENT"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.ContentImpl$OID">

      <implements name=3D"com.peacetech.dts.Content"/>

      <inheritance strategy=3D"new-table">

        <discriminator strategy=3D"value-map" value=3D"200"
column=3D"JDO_CLASS"/>

      </inheritance>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"CONTENT_ID" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"tocTitle">

        <column name=3D"TOC_TITLE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"500" scale=3D"0"/>

      </field>

      <field name=3D"shortTitle">

        <column name=3D"SHORT_TITLE" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"80" scale=3D"0"/>

      </field>

      <field name=3D"longTitle">

        <column name=3D"LONG_TITLE" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"200" scale=3D"0"/>

      </field>

      <field name=3D"text">

        <column name=3D"TEXT" jdbc-type=3D"CLOB" sql-type=3D"CLOB" =
length=3D"-1"
scale=3D"0"/>

      </field>

      <field name=3D"instructions">

        <column name=3D"INSTRUCTIONS" jdbc-type=3D"CLOB" =
sql-type=3D"CLOB"
length=3D"-1" scale=3D"0"/>

      </field>

      <field name=3D"fields" table=3D"CONTENT_FIELD" =
mapped-by=3D"content">
<!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.ContentFieldImpl"/>

        <order column=3D"SORT_ORDER"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContentImpl.fields"/>

      </field>

      <field name=3D"rules" table=3D"TEMPLATE_RULE" =
mapped-by=3D"content">
<!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.TemplateRuleImpl"/>

        <order column=3D"CONTENT_SORT_ORDER"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContentImpl.rules"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.ContentField"/>

=20

    <class name=3D"ContentFieldImpl" table=3D"CONTENT_FIELD"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.ContentFieldImpl$OID">

      <implements name=3D"com.peacetech.dts.ContentField"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"contentId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"CONTENT_ID" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"name" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"40" scale=3D"0"/>

      </field>

      <field name=3D"dataType">

        <column name=3D"DATA_TYPE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"20" scale=3D"0"/>

      </field>

      <field name=3D"format">

        <column name=3D"FORMAT" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"30" scale=3D"0"/>

      </field>

      <field name=3D"required">

        <column name=3D"REQUIRED" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"80" scale=3D"0"/>

      </field>

      <field name=3D"label">

        <column name=3D"LABEL" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"60" scale=3D"0"/>

      </field>

      <field name=3D"attributes" null-value=3D"exception"
persistence-modifier=3D"persistent" default-fetch-group=3D"true">

        <extension vendor-name=3D"kodo" key=3D"externalizer"
value=3D"com.peacetech.dts.jdo.helpers.Externalizers.fromStringMap"/>

        <extension vendor-name=3D"kodo" key=3D"factory"
value=3D"com.peacetech.dts.jdo.helpers.Externalizers.toStringMap"/>

        <column name=3D"ATTRIBUTES" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"512" scale=3D"0"/>

      </field>

      <field name=3D"multiValue" null-value=3D"exception">

        <column name=3D"IS_MULTI_VALUE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"inputValues" null-value=3D"exception"
persistence-modifier=3D"persistent" default-fetch-group=3D"true">

        <extension vendor-name=3D"kodo" key=3D"externalizer"
value=3D"com.peacetech.dts.jdo.helpers.Externalizers.fromStringMap"/>

        <extension vendor-name=3D"kodo" key=3D"factory"
value=3D"com.peacetech.dts.jdo.helpers.Externalizers.toStringMap"/>

        <column name=3D"INPUT_VALUES" jdbc-type=3D"CLOB" =
sql-type=3D"CLOB"
length=3D"-1" scale=3D"0"/>

      </field>

      <field name=3D"content"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"CONTENT_ID" target=3D"CONTENT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ContentFieldImpl.content"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Document"/>

=20

    <class name=3D"DocumentImpl" table=3D"DOCUMENT"
identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.DocumentNodeImpl"=
>

      <implements name=3D"com.peacetech.dts.Document"/>

=20

      <inheritance strategy=3D"new-table">

        <join>

          <column name=3D"DOCUMENT_NODE_ID" =
target=3D"DOCUMENT_NODE_ID"/>

        </join>

        <discriminator value=3D"440"/>

      </inheritance>

      <field name=3D"documentNumber" null-value=3D"exception">

        <column name=3D"DOCUMENT_NUMBER" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"title">

        <column name=3D"TITLE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"200" scale=3D"0"/>

      </field>

      <field name=3D"published" null-value=3D"exception">

        <column name=3D"IS_PUBLISHED" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"publishDate">

        <column name=3D"PUBLISH_DATE" jdbc-type=3D"DATE" =
sql-type=3D"DATE"
length=3D"7" scale=3D"0"/>

      </field>

      <field name=3D"preparer"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"PREPARER" target=3D"EMPLOYEE_ID" =
jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentImpl.preparer"/>

      </field>

      <field name=3D"orgUnit"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"ORG_UNIT_ID" target=3D"ORG_UNIT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentImpl.orgUnit"/>

      </field>

      <field name=3D"attributes" table=3D"DOCUMENT_ATTRIBUTE"
mapped-by=3D"document"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.DocumentAttributeImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentImpl.attributes"/>

      </field>

      <field name=3D"relatedDocuments" table=3D"RELATED_DOCUMENT"
mapped-by=3D"source"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.RelatedDocumentImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentImpl.relatedDocuments"/>

      </field>

      <field name=3D"relatedToDocuments" table=3D"RELATED_DOCUMENT"
mapped-by=3D"target"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.RelatedDocumentImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentImpl.relatedToDocuments"/>

      </field>

      <field name=3D"template"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"TEMPLATE_ID" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentImpl.template"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentAttribute"/>

=20

    <class name=3D"DocumentAttributeImpl" table=3D"DOCUMENT_ATTRIBUTE"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.DocumentAttributeImpl$OID">

      <implements name=3D"com.peacetech.dts.DocumentAttribute"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"documentNodeId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"DOCUMENT_NODE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"attributeId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"ATTRIBUTE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"value">

        <column name=3D"VALUE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"100" scale=3D"0"/>

      </field>

      <field name=3D"attribute"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"ATTRIBUTE_ID" target=3D"ATTRIBUTE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentAttributeImpl.attribute"/>

      </field>

      <field name=3D"document"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"DOCUMENT_NODE_ID" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentAttributeImpl.document"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentField"/>

=20

    <class name=3D"DocumentFieldImpl" table=3D"DOCUMENT_FIELD"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.DocumentFieldImpl$OID">

      <implements name=3D"com.peacetech.dts.DocumentField"/>

      <inheritance strategy=3D"new-table">

        <discriminator strategy=3D"value-map" value=3D"500"
column=3D"JDO_CLASS"/>

      </inheritance>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"documentNodeId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"DOCUMENT_NODE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"nameId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"40" scale=3D"0"/>

      </field>

      <field name=3D"definition"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"CONTENT_ID" target=3D"CONTENT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <column name=3D"NAME" target=3D"NAME" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"40" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentFieldImpl.definition"/>

      </field>

      <field name=3D"topic"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"DOCUMENT_NODE_ID" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentFieldImpl.topic"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentNode"/>

=20

    <class name=3D"DocumentNodeImpl" table=3D"DOCUMENT_NODE"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.DocumentNodeImpl$OID">

      <implements name=3D"com.peacetech.dts.DocumentNode"/>

      <inheritance strategy=3D"new-table">

        <discriminator strategy=3D"value-map" value=3D"400"
column=3D"JDO_CLASS"/>

      </inheritance>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"DOCUMENT_NODE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"name" null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"64" scale=3D"0"/>

      </field>

      <field name=3D"createDate">

        <column name=3D"CREATE_DATE" jdbc-type=3D"DATE" =
sql-type=3D"DATE"
length=3D"7" scale=3D"0"/>

      </field>

      <field name=3D"updateDate">

        <column name=3D"UPDATE_DATE" jdbc-type=3D"DATE" =
sql-type=3D"DATE"
length=3D"7" scale=3D"0"/>

      </field>

      <field name=3D"updateUser">

        <column name=3D"UPDATE_USER" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"localRoot"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"LOCAL_ROOT" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentNodeImpl.localRoot"/>

      </field>

      <field name=3D"parent" >  <!-- N-1 (ref) -->

        <column name=3D"PARENT" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentNodeImpl.parent"/>

      </field>

      <field name=3D"subNodes" table=3D"DOCUMENT_NODE" =
mapped-by=3D"parent">
<!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.DocumentNodeImpl"/>

        <order column=3D"PARENT_SORT_ORDER"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentNodeImpl.subNodes"/>

      </field>

      <field name=3D"properties" table=3D"DOCUMENT_NODE_PROPERTY"
mapped-by=3D"documentNode"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.DocumentNodePropertyImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentNodeImpl.properties"/>

      </field>

      <field name=3D"ownerDocument"  null-value=3D"exception">  <!-- N-1
(ref) -->

        <column name=3D"OWNER_DOCUMENT" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentNodeImpl.ownerDocument"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentNodeProperty"/>

=20

    <class name=3D"DocumentNodePropertyImpl"
table=3D"DOCUMENT_NODE_PROPERTY" identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.DocumentNodePropertyImpl$OID">

      <implements name=3D"com.peacetech.dts.DocumentNodeProperty"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"documentNodeId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"DOCUMENT_NODE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"nameId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"value" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"VALUE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"documentNode"  null-value=3D"exception">  <!-- N-1
(ref) -->

        <column name=3D"DOCUMENT_NODE_ID" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentNodePropertyImpl.documentNode"/>

      </field>

      <field name=3D"definition"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"NAME" target=3D"NAME" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentNodePropertyImpl.definition"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentRelationshipType"/>

=20

    <class name=3D"DocumentRelationshipTypeImpl"
table=3D"DOCUMENT_RELATIONSHIP_TYPE" identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.DocumentRelationshipTypeImpl$OID"=
>

      <implements name=3D"com.peacetech.dts.DocumentRelationshipType"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"DOCUMENT_RELATIONSHIP_TYPE" =
jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"9" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"120" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Employee"/>

=20

    <class name=3D"EmployeeImpl" table=3D"EMPLOYEE"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.EmployeeImpl$OID">

      <implements name=3D"com.peacetech.dts.Employee"/>

      <inheritance strategy=3D"new-table">

        <discriminator strategy=3D"value-map" value=3D"610"
column=3D"JDO_CLASS"/>

      </inheritance>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"EMPLOYEE_ID" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"firstName">

        <column name=3D"FIRST_NAME" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"lastName">

        <column name=3D"LAST_NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"middleName">

        <column name=3D"MIDDLE_NAME" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.OrgUnit"/>

=20

    <class name=3D"OrgUnitImpl" table=3D"ORG_UNIT"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.OrgUnitImpl$OID">

      <implements name=3D"com.peacetech.dts.OrgUnit"/>

      <inheritance strategy=3D"new-table">

        <discriminator strategy=3D"value-map" value=3D"600"
column=3D"JDO_CLASS"/>

      </inheritance>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"ORG_UNIT_ID" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"name">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"128" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.PropertyDefinition"/>

=20

    <class name=3D"PropertyDefinitionImpl" table=3D"PROPERTY_DEFINITION"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.PropertyDefinitionImpl$OID">

      <implements name=3D"com.peacetech.dts.PropertyDefinition"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"name" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"200" scale=3D"0"/>

      </field>

      <field name=3D"active" null-value=3D"exception">

        <column name=3D"IS_ACTIVE" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"lookup" null-value=3D"exception">

        <column name=3D"IS_LOOKUP" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"lookupSortOrder" null-value=3D"exception"
persistence-modifier=3D"persistent" default-fetch-group=3D"true">

        <extension vendor-name=3D"kodo" key=3D"externalizer"
value=3D"toSqlValue"/>

        <extension vendor-name=3D"kodo" key=3D"factory"
value=3D"fromSqlValue"/>

        <column name=3D"LOOKUP_SORT_ORDER" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"9" scale=3D"0"/>

      </field>

      <field name=3D"multiValue" null-value=3D"exception">

        <column name=3D"IS_MULTI_VALUE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"defaultValue">

        <column name=3D"DEFAULT_VALUE" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"lookupValues" table=3D"PROPERTY_LOOKUP"
mapped-by=3D"definition"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.PropertyLookupImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"PropertyDefinitionImpl.lookupValues"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.PropertyLookup"/>

=20

    <class name=3D"PropertyLookupImpl" table=3D"PROPERTY_LOOKUP"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.PropertyLookupImpl$OID">

      <implements name=3D"com.peacetech.dts.PropertyLookup"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"nameId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"code" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"CODE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"16" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"120" scale=3D"0"/>

      </field>

      <field name=3D"shortDescription">

        <column name=3D"SHORT_DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"64" scale=3D"0"/>

      </field>

      <field name=3D"sortOrder" null-value=3D"exception">

        <column name=3D"SORT_ORDER" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"9" scale=3D"0"/>

      </field>

      <field name=3D"active" null-value=3D"exception">

        <column name=3D"IS_ACTIVE" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"definition"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"NAME" target=3D"NAME" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"PropertyLookupImpl.definition"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.RelatedDocument"/>

=20

    <class name=3D"RelatedDocumentImpl" table=3D"RELATED_DOCUMENT"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.RelatedDocumentImpl$OID">

      <implements name=3D"com.peacetech.dts.RelatedDocument"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"sourceId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"SOURCE" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"relationshipTypeId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"RELATIONSHIP_TYPE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"9" scale=3D"0"/>

      </field>

      <field name=3D"targetId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"TARGET" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"notes">

        <column name=3D"NOTES" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"120" scale=3D"0"/>

      </field>

      <field name=3D"source"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"SOURCE" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"RelatedDocumentImpl.source"/>

      </field>

      <field name=3D"target"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"TARGET" target=3D"DOCUMENT_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"RelatedDocumentImpl.target"/>

      </field>

      <field name=3D"relationshipType"  null-value=3D"exception">  <!-- =
N-1
(ref) -->

        <column name=3D"RELATIONSHIP_TYPE"
target=3D"DOCUMENT_RELATIONSHIP_TYPE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"9" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"RelatedDocumentImpl.relationshipType"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.TemplateNode"/>

=20

    <class name=3D"TemplateNodeImpl" table=3D"TEMPLATE_NODE"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.TemplateNodeImpl$OID">

      <extension vendor-name=3D"kodo" key=3D"subclass-fetch-mode"
value=3D"none"/>

      <implements name=3D"com.peacetech.dts.TemplateNode"/>

      <inheritance strategy=3D"new-table">

        <discriminator strategy=3D"value-map" value=3D"100"
column=3D"JDO_CLASS"/>

      </inheritance>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"TEMPLATE_NODE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"name" null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"64" scale=3D"0"/>

      </field>

      <field name=3D"createDate">

        <column name=3D"CREATE_DATE" jdbc-type=3D"DATE" =
sql-type=3D"DATE"
length=3D"7" scale=3D"0"/>

      </field>

      <field name=3D"updateDate">

        <column name=3D"UPDATE_DATE" jdbc-type=3D"DATE" =
sql-type=3D"DATE"
length=3D"7" scale=3D"0"/>

      </field>

      <field name=3D"updateUser">

        <column name=3D"UPDATE_USER" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"parent" >  <!-- N-1 (ref) -->

        <column name=3D"PARENT" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodeImpl.parent"/>

      </field>

      <field name=3D"subNodes" table=3D"TEMPLATE_NODE" =
mapped-by=3D"parent">
<!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.TemplateNodeImpl"/>

        <order column=3D"PARENT_SORT_ORDER"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodeImpl.subNodes"/>

      </field>

      <field name=3D"priorVersion" >  <!-- N-1 (ref) -->

        <column name=3D"PRIOR_VERSION" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodeImpl.priorVersion"/>

      </field>

      <field name=3D"nextVersion" table=3D"TEMPLATE_NODE"
mapped-by=3D"priorVersion"> <!-- 1-1 -->

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodeImpl.nextVersion"/>

      </field>

      <field name=3D"properties" table=3D"TEMPLATE_NODE_PROPERTY"
mapped-by=3D"templateNode"> <!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.TemplateNodePropertyImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodeImpl.properties"/>

      </field>

      <field name=3D"ownerComponent"  null-value=3D"exception">  <!-- =
N-1
(ref) -->

        <column name=3D"OWNER_COMPONENT" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodeImpl.ownerComponent"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.TemplateNodeProperty"/>

=20

    <class name=3D"TemplateNodePropertyImpl"
table=3D"TEMPLATE_NODE_PROPERTY" identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.TemplateNodePropertyImpl$OID">

      <implements name=3D"com.peacetech.dts.TemplateNodeProperty"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"templateNodeId" primary-key=3D"true"
null-value=3D"exception">

        <column name=3D"TEMPLATE_NODE_ID" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"nameId" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"value" primary-key=3D"true" =
null-value=3D"exception">

        <column name=3D"VALUE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"definition"  null-value=3D"exception">  <!-- N-1 =
(ref)
-->

        <column name=3D"NAME" target=3D"NAME" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"32" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodePropertyImpl.definition"/>

      </field>

      <field name=3D"templateNode"  null-value=3D"exception">  <!-- N-1
(ref) -->

        <column name=3D"TEMPLATE_NODE_ID" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateNodePropertyImpl.templateNode"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.TemplateRule"/>

=20

    <class name=3D"TemplateRuleImpl" table=3D"TEMPLATE_RULE"
identity-type=3D"application"
objectid-class=3D"com.peacetech.dts.jdo.TemplateRuleImpl$OID">

      <implements name=3D"com.peacetech.dts.TemplateRule"/>

      <version strategy=3D"version-number" column=3D"JDO_LOCK"/>

      <field name=3D"id" primary-key=3D"true" null-value=3D"exception">

        <column name=3D"RULE_ID" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"12" scale=3D"0"/>

      </field>

      <field name=3D"type" null-value=3D"exception">

        <column name=3D"TYPE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"name">

        <column name=3D"NAME" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"32" scale=3D"0"/>

      </field>

      <field name=3D"description">

        <column name=3D"DESCRIPTION" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"80" scale=3D"0"/>

      </field>

      <field name=3D"text">

        <column name=3D"TEXT" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"1024" scale=3D"0"/>

      </field>

      <field name=3D"content"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"CONTENT_ID" target=3D"CONTENT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateRuleImpl.content"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.ComponentNode"/>

=20

    <class name=3D"ComponentNodeImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.TemplateNodeImpl"=
>

      <implements name=3D"com.peacetech.dts.ComponentNode"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"130"/>

      </inheritance>

      <field name=3D"referenceNumber">

        <column name=3D"REFERENCE_NUMBER" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"16" scale=3D"0"/>

      </field>

      <field name=3D"ownedContent" table=3D"CONTENT" =
mapped-by=3D"owner"> <!--
1-1 -->

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ComponentNodeImpl.ownedContent"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Template"/>

=20

    <class name=3D"TemplateImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ComponentImpl">

      <implements name=3D"com.peacetech.dts.Template"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"120"/>

      </inheritance>

      <field name=3D"notes">

        <column name=3D"NOTES" jdbc-type=3D"CLOB" sql-type=3D"CLOB"
length=3D"-1" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.ShareNode"/>

=20

    <class name=3D"ShareNodeImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ComponentNodeImpl=
"
>

      <implements name=3D"com.peacetech.dts.ShareNode"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"150"/>

      </inheritance>

      <field name=3D"target"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"SHARE_TARGET" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ShareNodeImpl.target"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentContent"/>

=20

    <class name=3D"DocumentContentImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ContentImpl">

      <implements name=3D"com.peacetech.dts.DocumentContent"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"220"/>

      </inheritance>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentFieldMultiValue"/>

=20

    <class name=3D"DocumentFieldMultiValueImpl"
identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.DocumentFieldImpl=
"
>

      <implements name=3D"com.peacetech.dts.DocumentFieldMultiValue"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"520"/>

      </inheritance>

      <field name=3D"values" default-fetch-group=3D"false"
null-value=3D"exception" persistence-modifier=3D"persistent">

        <extension vendor-name=3D"kodo" key=3D"externalizer"
value=3D"com.peacetech.dts.jdo.helpers.Externalizers.fromStringCollection=
"
/>

        <extension vendor-name=3D"kodo" key=3D"factory"
value=3D"com.peacetech.dts.jdo.helpers.Externalizers.toStringCollection"/=
>

        <column name=3D"VALUE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"1024" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.ShareLink"/>

=20

    <class name=3D"ShareLinkImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ShareNodeImpl">

      <implements name=3D"com.peacetech.dts.ShareLink"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"160"/>

      </inheritance>

      <field name=3D"topicExcluded" null-value=3D"exception">

        <column name=3D"IS_TOPIC_EXCLUDED" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"contentOverride" >  <!-- N-1 (ref) -->

        <column name=3D"CONTENT_ID" target=3D"CONTENT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ShareLinkImpl.contentOverride"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentSharePoint"/>

=20

    <class name=3D"DocumentSharePointImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.DocumentItemImpl"=
>

      <implements name=3D"com.peacetech.dts.DocumentSharePoint"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"420"/>

      </inheritance>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentItem"/>

=20

    <class name=3D"DocumentItemImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.DocumentNodeImpl"=
>

      <implements name=3D"com.peacetech.dts.DocumentItem"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"410"/>

      </inheritance>

      <field name=3D"referenceNumber">

        <column name=3D"REFERENCE_NUMBER" jdbc-type=3D"VARCHAR"
sql-type=3D"VARCHAR2" length=3D"16" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.SharePoint"/>

=20

    <class name=3D"SharePointImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ShareNodeImpl">

      <implements name=3D"com.peacetech.dts.SharePoint"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"170"/>

      </inheritance>

      <field name=3D"embedded" null-value=3D"exception">

        <column name=3D"IS_EMBEDDED_SHARE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.ComponentHolder"/>

=20

    <class name=3D"ComponentHolderImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ContainerImpl">

      <implements name=3D"com.peacetech.dts.ComponentHolder"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"310"/>

      </inheritance>

      <field name=3D"versions" table=3D"COMPONENT" =
mapped-by=3D"container">
<!-- 1-N -->

        <collection =
element-type=3D"com.peacetech.dts.jdo.ComponentImpl"/>

        <order column=3D"CONTAINER_SORT_ORDER"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"ComponentHolderImpl.versions"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentTopic"/>

=20

    <class name=3D"DocumentTopicImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.DocumentItemImpl"=
>

      <implements name=3D"com.peacetech.dts.DocumentTopic"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"430"/>

      </inheritance>

      <field name=3D"group" null-value=3D"exception">

        <column name=3D"IS_GROUP" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"selectedByUser">

        <column name=3D"IS_SELECTED_BY_USER" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"selectedByRule" null-value=3D"exception">

        <column name=3D"IS_SELECTED_BY_RULE" jdbc-type=3D"DECIMAL"
sql-type=3D"NUMBER" length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"originalContent" >  <!-- N-1 (ref) -->

        <column name=3D"ORIGINAL_CONTENT" target=3D"CONTENT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentTopicImpl.originalContent"/>

      </field>

      <field name=3D"content"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"CONTENT_ID" target=3D"CONTENT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentTopicImpl.content"/>

      </field>

      <field name=3D"fields" table=3D"DOCUMENT_FIELD" =
mapped-by=3D"topic">
<!-- 1-N -->

        <collection
element-type=3D"com.peacetech.dts.jdo.DocumentFieldImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"DocumentTopicImpl.fields"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.TemplateContent"/>

=20

    <class name=3D"TemplateContentImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ContentImpl">

      <implements name=3D"com.peacetech.dts.TemplateContent"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"210"/>

      </inheritance>

      <field name=3D"owner"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"OWNER" target=3D"TEMPLATE_NODE_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateContentImpl.owner"/>

      </field>

      <field name=3D"topics" table=3D"TEMPLATE_NODE" =
mapped-by=3D"content">
<!-- 1-N -->

        <collection element-type=3D"com.peacetech.dts.jdo.TopicImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateContentImpl.topics"/>

      </field>

      <field name=3D"shares" table=3D"TEMPLATE_NODE"
mapped-by=3D"contentOverride"> <!-- 1-N -->

        <collection =
element-type=3D"com.peacetech.dts.jdo.ShareLinkImpl"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TemplateContentImpl.shares"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.DocumentFieldSingleValue"/>

=20

    <class name=3D"DocumentFieldSingleValueImpl"
identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.DocumentFieldImpl=
"
>

      <implements name=3D"com.peacetech.dts.DocumentFieldSingleValue"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"510"/>

      </inheritance>

      <field name=3D"value">

        <column name=3D"VALUE" jdbc-type=3D"VARCHAR" =
sql-type=3D"VARCHAR2"
length=3D"1024" scale=3D"0"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Topic"/>

=20

    <class name=3D"TopicImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ComponentNodeImpl=
"
>

      <implements name=3D"com.peacetech.dts.Topic"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"140"/>

      </inheritance>

      <field name=3D"group" null-value=3D"exception">

        <column name=3D"IS_GROUP" jdbc-type=3D"DECIMAL" =
sql-type=3D"NUMBER"
length=3D"1" scale=3D"0"/>

      </field>

      <field name=3D"content"  null-value=3D"exception">  <!-- N-1 (ref) =
-->

        <column name=3D"CONTENT_ID" target=3D"CONTENT_ID"
jdbc-type=3D"DECIMAL" sql-type=3D"NUMBER" length=3D"12" scale=3D"0"/>

        <extension vendor-name=3D"kodo" key=3D"fetch-group"
value=3D"TopicImpl.content"/>

      </field>

    </class>

=20

    <interface name=3D"com.peacetech.dts.Folder"/>

=20

    <class name=3D"FolderImpl" identity-type=3D"application"
persistence-capable-superclass=3D"com.peacetech.dts.jdo.ContainerImpl">

      <implements name=3D"com.peacetech.dts.Folder"/>

      <inheritance strategy=3D"superclass-table">

        <discriminator value=3D"320"/>

      </inheritance>

    </class>

   </package>

</jdo>

=20

-----Original Message-----
From: Marc Prud'hommeaux [mailto:mprudhomapache@gmail.com] On Behalf Of
Marc Prud'hommeaux
Sent: Tuesday, October 17, 2006 4:34 PM
To: open-jpa-dev@incubator.apache.org
Subject: Re: Why would Kodo refuse to batch inserts in certain tables?
Big performance drop migrating to Kodo 4.1

=20

Alex-

=20

No attachment came through.

=20

Can you just paste the SQL log into a mail?

=20

=20

On Oct 16, 2006, at 6:04 PM, Roytman, Alex wrote:

=20

> Marc,

>=20

> Attached is JDBC trace and my mapping file.

>=20

> You can see how everything but DOCUMENT_NODE is batched.

>=20

> DOCUMENT_NODE is a super-class table. It has several sub-classes =20

> all but

> one mapped on the same table. The one mapped vertically uses DOCUMENT

> table. DOCUMENT_NODE have several bi- and uni-directional recursive

> associations

>=20

> The rest of the classes are related to DOCUMENT_NODE via mapped-by

>=20

> Alex

>=20

>=20

> -----Original Message-----

> From: Marc Prud'hommeaux [mailto:mprudhomapache@gmail.com] On =20

> Behalf Of

> Marc Prud'hommeaux

> Sent: Monday, October 16, 2006 7:30 PM

> To: open-jpa-dev@incubator.apache.org

> Subject: Re: Why would Kodo refuse to batch inserts in certain tables?

> Big performance drop migrating to Kodo 4.1

>=20

> Alex-

>=20

> So you are saying that batching is working OK in general, just not

> for a particular class? And that this particular class was batching

> fine with previous versions? That is odd, although there are some

> cases where we might refuse to batch a particular class (because of a

> driver bug with batching certain column types, etc).

>=20

> As a shot in the dark, we do work around a bug in the Oracle JDBC

> driver's failure to batch date/time effectively.

>=20

> Can you post the SQL log that shows the series of SQL statements that

> should have been batched, but weren't? That might help shed light =20

> on it.

>=20

> Also, database and JDBC driver type/version would be useful.

>=20

>=20

>=20

> On Oct 15, 2006, at 7:30 PM, Roytman, Alex wrote:

>=20

>> Hello,

>>=20

>>=20

>>=20

>> While migrating to Kodo 4.1 I noticed significant drop in insert

>> performance. I trace it down to some strange batching behavior. While

>> most of the PC were committed with batched inserts one particular

>> class

>> refused to batch and would insert row by row resulting in 10 times

>> performance drop.

>>=20

>>=20

>>=20

>> There is nothing special about the class. Its hierarchy is mapped on

>> base its table except for one of the lowest members which is mapped

>> vertically.

>>=20

>>=20

>>=20

>>=20

>>=20

>> Thank you very much

>>=20

>>=20

>>=20

>> Alex Roytman

>>=20

>> Peace Technology, Inc.

>>=20

>> 301-206-9696x103

>>=20

>>=20

>>=20

>=20

=20


------_=_NextPart_001_01C6F22C.27941508--