I am trying to run thru junit tests and tutorial examples, but ran into
few problems.
First problem was, prepare-testdb target had error when inserting
ojbcore-schema.sql. It fails in creating
CREATE TABLE OJB_DMAP_ENTRIES
(
ID NUMBER NOT NULL,
DMAP_ID NUMBER NOT NULL,
KEY_OID LONG RAW,
VALUE_OID LONG RAW
);
Because oracle allows only one column to be long raw per table. I
checked previous versions of OJB (0.9.6), same problem exists. Please
let me know what should be the fix.When I tried to ignore above problem and plow thru the unit tests, I get bunch of transactions exceptions. I think I am not setting things correctly. To walk thru these examples I am not running any application server (jboss or weblogic), is it a pre-requisite to run these examples? Please find OJB.properties and test.xml files attached. Thanks -- CP Agrawal
OJB.properties
Description: Binary data
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE descriptor-repository SYSTEM "repository.dtd" [
<!ENTITY user SYSTEM "repository_user.xml">
<!ENTITY junit SYSTEM "repository_junit.xml">
<!ENTITY internal SYSTEM "repository_internal.xml"> ]>
<!-- OJB RepositoryPersistor generated this file on Tue Oct 29 22:51:57 PST 2002 -->
<descriptor-repository
version="0.9.6"
isolation-level="read-uncommitted"
>
<!-- Descriptor for Connection jdbc:oracle:thin:@192.168.1.2:1521:mighty -->
<jdbc-connection-descriptor
platform="Oracle"
jdbc-level="1.0"
driver="oracle.jdbc.driver.OracleDriver"
protocol="jdbc"
subprotocol="oracle"
dbalias="thin:@192.168.1.2:1521:mighty"
eager-release="false"
username="ojb"
password="ojb"
/>
<!-- Mapping for Class org.apache.ojb.odmg.locking.LockEntry -->
<class-descriptor
class="org.apache.ojb.odmg.locking.LockEntry"
proxy="null"
table="OJB_LOCKENTRY"
>
<field-descriptor id="1"
name="oidString"
column="OID_"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="transactionId"
column="TX_ID"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="3"
name="timestamp"
column="TIMESTAMP_"
jdbc-type="BIGINT"
/>
<field-descriptor id="4"
name="isolationLevel"
column="ISOLATIONLEVEL"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="lockType"
column="LOCKTYPE"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.GuidTestEntity -->
<class-descriptor
class="org.apache.ojb.broker.GuidTestEntity"
proxy="null"
table="GUIDTEST"
>
<field-descriptor id="1"
name="guid"
column="GUID"
jdbc-type="VARCHAR"
primarykey="true"
conversion="org.apache.ojb.broker.accesslayer.conversions.GUID2StringFieldConversion"
/>
<field-descriptor id="2"
name="value"
column="VALUE"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.Site -->
<class-descriptor
class="org.apache.ojb.odmg.Site"
proxy="null"
table="SITE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="year"
column="YEAR"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="semester"
column="SEMESTER"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Table_2Object -->
<class-descriptor
class="org.apache.ojb.broker.Table_2Object"
proxy="null"
table="TABLE_2"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.collections.DListImpl -->
<class-descriptor
class="org.apache.ojb.odmg.collections.DListImpl"
proxy="null"
table="OJB_DLIST"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="elements"
element-class-ref="org.apache.ojb.odmg.collections.DListEntry"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.PerformanceArticle -->
<class-descriptor
class="org.apache.ojb.broker.PerformanceArticle"
proxy="null"
table="Artikel"
>
<field-descriptor id="1"
name="articleId"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="articleName"
column="Artikelname"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="supplierId"
column="Lieferanten_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="productGroupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="unit"
column="Liefereinheit"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="price"
column="Einzelpreis"
jdbc-type="FLOAT"
/>
<field-descriptor id="7"
name="stock"
column="Lagerbestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="8"
name="orderedUnits"
column="BestellteEinheiten"
jdbc-type="INTEGER"
/>
<field-descriptor id="9"
name="minimumStock"
column="MindestBestand"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.TestClassB -->
<class-descriptor
class="org.apache.ojb.odmg.TestClassB"
proxy="null"
table="TestClassB"
>
<field-descriptor id="1"
name="oid"
column="oid"
jdbc-type="VARCHAR"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="aoid"
column="aOid"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="a"
class-ref="org.apache.ojb.odmg.TestClassA"
>
<foreignkey field-id-ref="3"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.TestClassA -->
<class-descriptor
class="org.apache.ojb.odmg.TestClassA"
proxy="null"
table="TestClassA"
>
<field-descriptor id="1"
name="oid"
column="oid"
jdbc-type="VARCHAR"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value2"
column="value2"
jdbc-type="VARCHAR"
/>
<field-descriptor id="4"
name="value3"
column="value3"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="boid"
column="bOid"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="b"
class-ref="org.apache.ojb.odmg.TestClassB"
>
<foreignkey field-id-ref="5"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.GraphEdge -->
<class-descriptor
class="org.apache.ojb.broker.GraphEdge"
proxy="null"
table="GRAPH_EDGE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="sourceId"
column="SOURCE"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="sinkId"
column="SINK"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="source"
class-ref="org.apache.ojb.broker.GraphNode"
>
<foreignkey field-id-ref="2"/>
</reference-descriptor>
<reference-descriptor
name="sink"
class-ref="org.apache.ojb.broker.GraphNode"
>
<foreignkey field-id-ref="3"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.ODMGGourmet -->
<class-descriptor
class="org.apache.ojb.odmg.ODMGGourmet"
proxy="null"
table="gourmet"
>
<field-descriptor id="1"
name="gourmetId"
column="gourmetId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="favoriteFood"
element-class-ref="org.apache.ojb.broker.InterfaceFood"
indirection-table="GOURMET_FOOD"
>
<fk-pointing-to-this-class column="GOURMET_ID"/>
<fk-pointing-to-element-class column="FOOD_ID"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Project -->
<class-descriptor
class="org.apache.ojb.broker.Project"
proxy="null"
table="PROJECT"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="title"
column="TITLE"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="description"
column="DESCRIPTION"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="roles"
element-class-ref="org.apache.ojb.broker.Role"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
<collection-descriptor
name="persons"
element-class-ref="org.apache.ojb.broker.Person"
indirection-table="PERSON_PROJECT"
>
<fk-pointing-to-this-class column="PROJECT_ID"/>
<fk-pointing-to-element-class column="PERSON_ID"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.ODMGZoo -->
<class-descriptor
class="org.apache.ojb.odmg.ODMGZoo"
proxy="null"
table="zoo"
>
<field-descriptor id="1"
name="zooId"
column="zooId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="animals"
element-class-ref="org.apache.ojb.broker.InterfaceAnimal"
>
<inverse-foreignkey field-id-ref="5"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ObjectWithBlob -->
<class-descriptor
class="org.apache.ojb.broker.ObjectWithBlob"
proxy="null"
table="BLOB_TEST"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="blob"
column="BLOB_VALUE_"
jdbc-type="BLOB"
/>
<field-descriptor id="3"
name="clob"
column="CLOB_VALUE_"
jdbc-type="CLOB"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ProductGroupWithCollectionProxy -->
<class-descriptor
class="org.apache.ojb.broker.ProductGroupWithCollectionProxy"
proxy="null"
table="Kategorien"
>
<field-descriptor id="1"
name="groupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="groupName"
column="KategorieName"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="allArticlesInGroup"
element-class-ref="org.apache.ojb.broker.Article"
proxy="true"
>
<inverse-foreignkey field-id-ref="4"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.collections.DListEntry -->
<class-descriptor
class="org.apache.ojb.odmg.collections.DListEntry"
proxy="null"
table="OJB_DLIST_ENTRIES"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="dlistId"
column="DLIST_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="position"
column="POSITION_"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="oid"
column="OID_"
jdbc-type="LONGVARBINARY"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.FarAwayReference -->
<class-descriptor
class="org.apache.ojb.broker.FarAwayReference"
proxy="null"
table="FAR_AWAY_REFERENCE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.ProductGroup -->
<class-descriptor
class="org.apache.ojb.odmg.ProductGroup"
isolation-level="serializable"
proxy="null"
table="Kategorien"
>
<field-descriptor id="1"
name="groupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="groupName"
column="KategorieName"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="description"
column="Beschreibung"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="allArticlesInGroup"
element-class-ref="org.apache.ojb.odmg.Article"
>
<inverse-foreignkey field-id-ref="4"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ProductGroupWithTypedCollection -->
<class-descriptor
class="org.apache.ojb.broker.ProductGroupWithTypedCollection"
proxy="null"
table="Kategorien"
>
<field-descriptor id="1"
name="groupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="groupName"
column="KategorieName"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="description"
column="Beschreibung"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="allArticlesInGroup"
collection-class="org.apache.ojb.broker.ArticleCollection"
element-class-ref="org.apache.ojb.broker.Article"
auto-delete="true"
>
<inverse-foreignkey field-id-ref="4"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.InterfaceArticle -->
<class-descriptor
class="org.apache.ojb.broker.InterfaceArticle"
proxy="null"
>
<extent-class class-ref="org.apache.ojb.broker.Article" />
<extent-class class-ref="org.apache.ojb.broker.BookArticle" />
<extent-class class-ref="org.apache.ojb.broker.CdArticle" />
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Table_1Object -->
<class-descriptor
class="org.apache.ojb.broker.Table_1Object"
proxy="null"
table="TABLE_1"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="table2ObjectFK"
column="fk_to_related"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="table2Object"
class-ref="org.apache.ojb.broker.Table_2Object"
>
<foreignkey field-id-ref="2"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.PBAwareEntity -->
<class-descriptor
class="org.apache.ojb.broker.PBAwareEntity"
proxy="null"
table="Artikel"
>
<field-descriptor id="1"
name="id"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Fish -->
<class-descriptor
class="org.apache.ojb.broker.Fish"
proxy="null"
table="fish"
>
<field-descriptor id="1"
name="foodId"
column="foodId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="calories"
column="calories"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="typeOfWater"
column="typeOfWater"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.DetailFKinPK -->
<class-descriptor
class="org.apache.ojb.odmg.DetailFKinPK"
proxy="null"
table="MDTEST_DETAIL_FKINPK"
>
<field-descriptor id="1"
name="masterId"
column="MASTERID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="detailId"
column="DETAILID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="3"
name="detailText"
column="DETAIL_TEXT"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="master"
class-ref="org.apache.ojb.odmg.Master"
>
<foreignkey field-id-ref="1"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Reptile -->
<class-descriptor
class="org.apache.ojb.broker.Reptile"
proxy="null"
table="reptile"
>
<field-descriptor id="1"
name="animalId"
column="animalId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="age"
column="age"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="color"
column="color"
jdbc-type="VARCHAR"
/>
<field-descriptor id="5"
name="zooId"
column="zooId"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Mammal -->
<class-descriptor
class="org.apache.ojb.broker.Mammal"
proxy="null"
table="mammal"
>
<field-descriptor id="1"
name="animalId"
column="animalId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="age"
column="age"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="numLegs"
column="numLegs"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="zooId"
column="zooId"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.InterfaceFood -->
<class-descriptor
class="org.apache.ojb.broker.InterfaceFood"
proxy="null"
>
<extent-class class-ref="org.apache.ojb.broker.Salad" />
<extent-class class-ref="org.apache.ojb.broker.Fish" />
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.DetailFKnoPK -->
<class-descriptor
class="org.apache.ojb.odmg.DetailFKnoPK"
proxy="null"
table="MDTEST_DETAIL_FKNOPK"
>
<field-descriptor id="1"
name="detailId"
column="DETAILID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="masterId"
column="MASTERID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="detailText"
column="DETAIL_TEXT"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="master"
class-ref="org.apache.ojb.odmg.Master"
>
<foreignkey field-id-ref="2"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.tutorial1.Product -->
<class-descriptor
class="org.apache.ojb.tutorial1.Product"
proxy="null"
table="PRODUCT"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="price"
column="PRICE"
jdbc-type="DOUBLE"
/>
<field-descriptor id="4"
name="stock"
column="STOCK"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.collections.DSetEntry -->
<class-descriptor
class="org.apache.ojb.odmg.collections.DSetEntry"
proxy="null"
table="OJB_DSET_ENTRIES"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="dlistId"
column="DLIST_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="position"
column="POSITION_"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="oid"
column="OID_"
jdbc-type="LONGVARBINARY"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.AbstractCdArticle -->
<class-descriptor
class="org.apache.ojb.broker.AbstractCdArticle"
proxy="null"
>
<extent-class class-ref="org.apache.ojb.broker.CdArticle" />
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ProjectUnidirectional -->
<class-descriptor
class="org.apache.ojb.broker.ProjectUnidirectional"
proxy="null"
table="PROJECT"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="title"
column="TITLE"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="description"
column="DESCRIPTION"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.RelatedToContract -->
<class-descriptor
class="org.apache.ojb.broker.RelatedToContract"
proxy="null"
table="RelatedToContract"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="relatedValue1"
column="relatedValue1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="relatedValue2"
column="relatedValue2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="relatedValue3"
column="relatedValue3"
jdbc-type="TIMESTAMP"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.GraphNode -->
<class-descriptor
class="org.apache.ojb.broker.GraphNode"
proxy="null"
table="GRAPH_NODE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="locationId"
column="LOCATION"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="location"
class-ref="org.apache.ojb.broker.Point"
>
<foreignkey field-id-ref="3"/>
</reference-descriptor>
<collection-descriptor
name="outgoingEdges"
element-class-ref="org.apache.ojb.broker.GraphEdge"
orderby="id"
auto-update="true"
auto-delete="true"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
<collection-descriptor
name="incomingEdges"
element-class-ref="org.apache.ojb.broker.GraphEdge"
orderby="id"
auto-update="true"
auto-delete="true"
>
<inverse-foreignkey field-id-ref="3"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.B1 -->
<class-descriptor
class="org.apache.ojb.broker.B1"
proxy="null"
table="AB_TABLE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="ojbConcreteClass"
column="CLASS_NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="someValue"
column="VALUE_"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Article -->
<class-descriptor
class="org.apache.ojb.broker.Article"
proxy="dynamic"
table="Artikel"
>
<extent-class class-ref="org.apache.ojb.broker.BookArticle" />
<extent-class class-ref="org.apache.ojb.broker.AbstractCdArticle" />
<field-descriptor id="1"
name="articleId"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="articleName"
column="Artikelname"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="supplierId"
column="Lieferanten_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="productGroupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="unit"
column="Liefereinheit"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="price"
column="Einzelpreis"
jdbc-type="FLOAT"
/>
<field-descriptor id="7"
name="stock"
column="Lagerbestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="8"
name="orderedUnits"
column="BestellteEinheiten"
jdbc-type="INTEGER"
/>
<field-descriptor id="9"
name="minimumStock"
column="MindestBestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="10"
name="isSelloutArticle"
column="Auslaufartikel"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldConversion"
/>
<reference-descriptor
name="productGroup"
class-ref="org.apache.ojb.broker.ProductGroup"
auto-update="true"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Role -->
<class-descriptor
class="org.apache.ojb.broker.Role"
proxy="null"
table="PERSON_PROJECT"
>
<field-descriptor id="1"
name="person_id"
column="PERSON_ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="project_id"
column="PROJECT_ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="3"
name="roleName"
column="ROLENAME"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="person"
class-ref="org.apache.ojb.broker.Person"
>
<foreignkey field-id-ref="1"/>
</reference-descriptor>
<reference-descriptor
name="project"
class-ref="org.apache.ojb.broker.Project"
>
<foreignkey field-id-ref="2"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.FarAwayClass -->
<class-descriptor
class="org.apache.ojb.broker.FarAwayClass"
proxy="null"
table="FAR_AWAY"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="description"
column="DESCRIPTION"
jdbc-type="VARCHAR"
/>
<field-descriptor id="4"
name="referenceId"
column="REFERENCE_ID"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="reference"
class-ref="org.apache.ojb.broker.FarAwayReference"
proxy="true"
auto-update="true"
auto-delete="true"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.AB -->
<class-descriptor
class="org.apache.ojb.broker.AB"
proxy="null"
>
<extent-class class-ref="org.apache.ojb.broker.A" />
<extent-class class-ref="org.apache.ojb.broker.B" />
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.TreeGroup -->
<class-descriptor
class="org.apache.ojb.broker.TreeGroup"
proxy="null"
table="TREEGROUP"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="data"
column="DATA"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="parentId"
column="PARENT_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="groupId"
column="GROUP_ID"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="myParent"
class-ref="org.apache.ojb.broker.TreeGroup"
>
<foreignkey field-id-ref="3"/>
</reference-descriptor>
<reference-descriptor
name="myGroup"
class-ref="org.apache.ojb.broker.TreeGroup"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
<collection-descriptor
name="children"
element-class-ref="org.apache.ojb.broker.TreeGroup"
auto-update="true"
auto-delete="true"
>
<inverse-foreignkey field-id-ref="3"/>
</collection-descriptor>
<collection-descriptor
name="groupMembers"
element-class-ref="org.apache.ojb.broker.TreeGroup"
auto-update="true"
auto-delete="true"
>
<inverse-foreignkey field-id-ref="4"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.NamedRootsEntry -->
<class-descriptor
class="org.apache.ojb.odmg.NamedRootsEntry"
proxy="null"
table="OJB_NRM"
>
<field-descriptor id="1"
name="name"
column="NAME"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="oid"
column="OID_"
jdbc-type="LONGVARBINARY"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Tree -->
<class-descriptor
class="org.apache.ojb.broker.Tree"
proxy="null"
table="TREE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="data"
column="DATA"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="parentId"
column="PARENT_ID"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="childs"
element-class-ref="org.apache.ojb.broker.Tree"
auto-update="true"
auto-delete="true"
>
<inverse-foreignkey field-id-ref="3"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.collections.DBagImpl -->
<class-descriptor
class="org.apache.ojb.odmg.collections.DBagImpl"
proxy="null"
table="OJB_DLIST"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="elements"
element-class-ref="org.apache.ojb.odmg.collections.DListEntry"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.Master -->
<class-descriptor
class="org.apache.ojb.odmg.Master"
proxy="null"
table="MDTEST_MASTER"
>
<field-descriptor id="1"
name="masterId"
column="MASTERID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="masterText"
column="MASTER_TEXT"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="collDetailFKinPK"
element-class-ref="org.apache.ojb.odmg.DetailFKinPK"
>
<inverse-foreignkey field-id-ref="1"/>
</collection-descriptor>
<collection-descriptor
name="collDetailFKnoPK"
element-class-ref="org.apache.ojb.odmg.DetailFKnoPK"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.LockedByVersion -->
<class-descriptor
class="org.apache.ojb.broker.LockedByVersion"
proxy="null"
table="LOCKED_BY_VERSION"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value"
column="VALUE_"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="version"
column="VERSION_"
jdbc-type="INTEGER"
locking="true"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Contract -->
<class-descriptor
class="org.apache.ojb.broker.Contract"
proxy="null"
table="Contract"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="contractValue1"
column="contract_value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="contractValue2"
column="contract_value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="contractValue3"
column="contract_value3"
jdbc-type="VARCHAR"
/>
<field-descriptor id="5"
name="contractValue4"
column="contract_value4"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="6"
name="fkToRelated"
column="fk_to_related"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="relatedToContract"
class-ref="org.apache.ojb.broker.RelatedToContract"
>
<foreignkey field-id-ref="6"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.PersonUnidirectional -->
<class-descriptor
class="org.apache.ojb.broker.PersonUnidirectional"
proxy="null"
table="PERSON"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="firstname"
column="FIRSTNAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="lastname"
column="LASTNAME"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="projects"
element-class-ref="org.apache.ojb.broker.ProjectUnidirectional"
indirection-table="PERSON_PROJECT"
proxy="true"
auto-update="true"
>
<fk-pointing-to-this-class column="PERSON_ID"/>
<fk-pointing-to-element-class column="PROJECT_ID"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.collections.DMapEntry -->
<class-descriptor
class="org.apache.ojb.odmg.collections.DMapEntry"
proxy="null"
table="OJB_DMAP_ENTRIES"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="dmapId"
column="DMAP_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="keyOID"
column="KEY_OID"
jdbc-type="LONGVARBINARY"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
<field-descriptor id="4"
name="valueOID"
column="VALUE_OID"
jdbc-type="LONGVARBINARY"
conversion="org.apache.ojb.broker.accesslayer.conversions.Object2ByteArrFieldConversion"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.BookArticle -->
<class-descriptor
class="org.apache.ojb.broker.BookArticle"
proxy="null"
table="BOOKS"
>
<field-descriptor id="1"
name="articleId"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="articleName"
column="Artikelname"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="supplierId"
column="Lieferanten_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="productGroupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="unit"
column="Liefereinheit"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="price"
column="Einzelpreis"
jdbc-type="FLOAT"
/>
<field-descriptor id="7"
name="stock"
column="Lagerbestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="8"
name="orderedUnits"
column="BestellteEinheiten"
jdbc-type="INTEGER"
/>
<field-descriptor id="9"
name="minimumStock"
column="MindestBestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="10"
name="isSelloutArticle"
column="Auslaufartikel"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldConversion"
/>
<field-descriptor id="11"
name="isbn"
column="ISBN"
jdbc-type="VARCHAR"
/>
<field-descriptor id="12"
name="author"
column="AUTHOR"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="productGroup"
class-ref="org.apache.ojb.broker.ProductGroup"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Person -->
<class-descriptor
class="org.apache.ojb.broker.Person"
proxy="null"
table="PERSON"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="firstname"
column="FIRSTNAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="lastname"
column="LASTNAME"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="roles"
element-class-ref="org.apache.ojb.broker.Role"
>
<inverse-foreignkey field-id-ref="1"/>
</collection-descriptor>
<collection-descriptor
name="projects"
element-class-ref="org.apache.ojb.broker.Project"
indirection-table="PERSON_PROJECT"
auto-update="true"
>
<fk-pointing-to-this-class column="PERSON_ID"/>
<fk-pointing-to-element-class column="PROJECT_ID"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.Article -->
<class-descriptor
class="org.apache.ojb.odmg.Article"
proxy="null"
table="Artikel"
>
<field-descriptor id="1"
name="articleId"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="articleName"
column="Artikelname"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="supplierId"
column="Lieferanten_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="productGroupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="unit"
column="Liefereinheit"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="price"
column="Einzelpreis"
jdbc-type="FLOAT"
/>
<field-descriptor id="7"
name="stock"
column="Lagerbestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="8"
name="orderedUnits"
column="BestellteEinheiten"
jdbc-type="INTEGER"
/>
<field-descriptor id="9"
name="minimumStock"
column="MindestBestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="10"
name="isSelloutArticle"
column="Auslaufartikel"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldConversion"
/>
<reference-descriptor
name="productGroup"
class-ref="org.apache.ojb.odmg.ProductGroup"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Version -->
<class-descriptor
class="org.apache.ojb.broker.Version"
proxy="null"
table="Version"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="versionValue1"
column="version_value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="versionValue2"
column="version_value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="versionValue3"
column="version_value3"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="fkToContract"
column="fk_to_contract"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="contract"
class-ref="org.apache.ojb.broker.Contract"
>
<foreignkey field-id-ref="5"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.CdArticle -->
<class-descriptor
class="org.apache.ojb.broker.CdArticle"
proxy="null"
table="CDS"
>
<field-descriptor id="1"
name="articleId"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="articleName"
column="Artikelname"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="supplierId"
column="Lieferanten_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="productGroupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="unit"
column="Liefereinheit"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="price"
column="Einzelpreis"
jdbc-type="FLOAT"
/>
<field-descriptor id="7"
name="stock"
column="Lagerbestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="8"
name="orderedUnits"
column="BestellteEinheiten"
jdbc-type="INTEGER"
/>
<field-descriptor id="9"
name="minimumStock"
column="MindestBestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="10"
name="isSelloutArticle"
column="Auslaufartikel"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldConversion"
/>
<field-descriptor id="11"
name="labelname"
column="LABEL"
jdbc-type="VARCHAR"
/>
<field-descriptor id="12"
name="musicians"
column="MUSICIANS"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="productGroup"
class-ref="org.apache.ojb.broker.ProductGroup"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Point -->
<class-descriptor
class="org.apache.ojb.broker.Point"
proxy="null"
table="POINT_TABLE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="x"
column="X"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="y"
column="Y"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.InterfaceAnimal -->
<class-descriptor
class="org.apache.ojb.broker.InterfaceAnimal"
proxy="null"
>
<extent-class class-ref="org.apache.ojb.broker.Mammal" />
<extent-class class-ref="org.apache.ojb.broker.Reptile" />
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.LockedByTimestamp -->
<class-descriptor
class="org.apache.ojb.broker.LockedByTimestamp"
proxy="null"
table="LOCKED_BY_TIMESTAMP"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value"
column="VALUE_"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="timestamp"
column="TIMESTAMP_"
jdbc-type="TIMESTAMP"
locking="true"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.TestClassAWithBProxy -->
<class-descriptor
class="org.apache.ojb.odmg.TestClassAWithBProxy"
proxy="null"
table="TestClassA"
>
<field-descriptor id="1"
name="oid"
column="oid"
jdbc-type="VARCHAR"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value2"
column="value2"
jdbc-type="VARCHAR"
/>
<field-descriptor id="4"
name="value3"
column="value3"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="boid"
column="bOid"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="bp"
class-ref="org.apache.ojb.odmg.TestClassBProxy"
>
<foreignkey field-id-ref="5"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.TestClassBProxy -->
<class-descriptor
class="org.apache.ojb.odmg.TestClassBProxy"
proxy="dynamic"
table="TestClassB"
>
<field-descriptor id="1"
name="oid"
column="oid"
jdbc-type="VARCHAR"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableF -->
<class-descriptor
class="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableF"
proxy="null"
table="MultiMappedTable"
>
<field-descriptor id="1"
name="ID"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value2"
column="value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="value3"
column="value3"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="value4"
column="value4"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="value5"
column="value5"
jdbc-type="INTEGER"
/>
<field-descriptor id="7"
name="value6"
column="value6"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="8"
name="ojbConcreteClass"
column="ojbConcreteClass"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableE -->
<class-descriptor
class="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableE"
proxy="null"
table="MultiMappedTable"
>
<extent-class class-ref="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableF" />
<field-descriptor id="1"
name="ID"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value2"
column="value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="value3"
column="value3"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="value4"
column="value4"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="value5"
column="value5"
jdbc-type="INTEGER"
/>
<field-descriptor id="7"
name="value6"
column="value6"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="8"
name="ojbConcreteClass"
column="ojbConcreteClass"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableD -->
<class-descriptor
class="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableD"
proxy="null"
table="MultiMappedTable"
>
<field-descriptor id="1"
name="ID"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value2"
column="value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="value3"
column="value3"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="value4"
column="value4"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="value5"
column="value5"
jdbc-type="INTEGER"
/>
<field-descriptor id="7"
name="value6"
column="value6"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="8"
name="ojbConcreteClass"
column="ojbConcreteClass"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.BidirectionalAssociationObjectB -->
<class-descriptor
class="org.apache.ojb.broker.BidirectionalAssociationObjectB"
proxy="null"
table="BIDIR_B"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="fkToA"
column="fk_to_A"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="relatedA"
class-ref="org.apache.ojb.broker.BidirectionalAssociationObjectA"
>
<foreignkey field-id-ref="2"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.tutorial4.Product -->
<class-descriptor
class="org.apache.ojb.tutorial4.Product"
proxy="null"
table="PRODUCT"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="price"
column="PRICE"
jdbc-type="DOUBLE"
/>
<field-descriptor id="4"
name="stock"
column="STOCK"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableC -->
<class-descriptor
class="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableC"
proxy="null"
table="MultiMappedTable"
>
<field-descriptor id="1"
name="ID"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value2"
column="value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="value3"
column="value3"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="value4"
column="value4"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="value5"
column="value5"
jdbc-type="INTEGER"
/>
<field-descriptor id="7"
name="value6"
column="value6"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="8"
name="ojbConcreteClass"
column="ojbConcreteClass"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.collections.DSetImpl -->
<class-descriptor
class="org.apache.ojb.odmg.collections.DSetImpl"
proxy="null"
table="OJB_DSET"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="elements"
element-class-ref="org.apache.ojb.odmg.collections.DSetEntry"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.BidirectionalAssociationObjectA -->
<class-descriptor
class="org.apache.ojb.broker.BidirectionalAssociationObjectA"
proxy="null"
table="BIDIR_A"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="fkToB"
column="fk_to_B"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="relatedB"
class-ref="org.apache.ojb.broker.BidirectionalAssociationObjectB"
>
<foreignkey field-id-ref="2"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ProductGroupWithArray -->
<class-descriptor
class="org.apache.ojb.broker.ProductGroupWithArray"
proxy="null"
table="Kategorien"
>
<field-descriptor id="1"
name="groupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="groupName"
column="KategorieName"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="description"
column="Beschreibung"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="allArticlesInGroup"
element-class-ref="org.apache.ojb.broker.Article"
auto-delete="true"
>
<inverse-foreignkey field-id-ref="4"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableB -->
<class-descriptor
class="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableB"
proxy="null"
table="MultiMappedTable"
>
<extent-class class-ref="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableD" />
<extent-class class-ref="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableE" />
<field-descriptor id="1"
name="ID"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value4"
column="value4"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value5"
column="value5"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="value6"
column="value6"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="ojbConcreteClass"
column="ojbConcreteClass"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableA -->
<class-descriptor
class="org.apache.ojb.broker.ComplexObjectMappedToMultiMappedTableA"
proxy="null"
table="MultiMappedTable"
>
<field-descriptor id="1"
name="ID"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="value1"
column="value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="value2"
column="value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="value3"
column="value3"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="ojbConcreteClass"
column="ojbConcreteClass"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.OrderPosition -->
<class-descriptor
class="org.apache.ojb.broker.OrderPosition"
proxy="null"
table="ORDER_POSITION"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="order_id"
column="ORDER_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="3"
name="article_id"
column="ARTICLE_ID"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="article"
class-ref="org.apache.ojb.broker.Article"
>
<foreignkey field-id-ref="3"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Gourmet -->
<class-descriptor
class="org.apache.ojb.broker.Gourmet"
proxy="null"
table="gourmet"
>
<field-descriptor id="1"
name="gourmetId"
column="gourmetId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="favoriteFood"
element-class-ref="org.apache.ojb.broker.InterfaceFood"
indirection-table="GOURMET_FOOD"
auto-update="true"
>
<fk-pointing-to-this-class column="GOURMET_ID"/>
<fk-pointing-to-element-class column="FOOD_ID"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.tutorial2.Product -->
<class-descriptor
class="org.apache.ojb.tutorial2.Product"
proxy="null"
table="PRODUCT"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="price"
column="PRICE"
jdbc-type="DOUBLE"
/>
<field-descriptor id="4"
name="stock"
column="STOCK"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.D -->
<class-descriptor
class="org.apache.ojb.broker.D"
proxy="null"
table="AB_TABLE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="ojbConcreteClass"
column="CLASS_NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="someValue"
column="VALUE_"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.C -->
<class-descriptor
class="org.apache.ojb.broker.C"
proxy="null"
table="AB_TABLE"
>
<extent-class class-ref="org.apache.ojb.broker.D" />
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="ojbConcreteClass"
column="CLASS_NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="someValue"
column="VALUE_"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.B -->
<class-descriptor
class="org.apache.ojb.broker.B"
proxy="null"
table="AB_TABLE"
>
<extent-class class-ref="org.apache.ojb.broker.B1" />
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="ojbConcreteClass"
column="CLASS_NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="someValue"
column="VALUE_"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.A -->
<class-descriptor
class="org.apache.ojb.broker.A"
proxy="null"
table="AB_TABLE"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="ojbConcreteClass"
column="CLASS_NAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="someValue"
column="VALUE_"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.util.sequence.HighLowSequence -->
<class-descriptor
class="org.apache.ojb.broker.util.sequence.HighLowSequence"
proxy="null"
table="OJB_HL_SEQ"
>
<field-descriptor id="1"
name="tableName"
column="TABLENAME"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="fieldName"
column="FIELDNAME"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="3"
name="maxKey"
column="MAX_KEY"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="grabSize"
column="GRAB_SIZE"
jdbc-type="INTEGER"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Zoo -->
<class-descriptor
class="org.apache.ojb.broker.Zoo"
proxy="null"
table="zoo"
>
<field-descriptor id="1"
name="zooId"
column="zooId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="animals"
element-class-ref="org.apache.ojb.broker.InterfaceAnimal"
auto-update="true"
>
<inverse-foreignkey field-id-ref="5"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Salad -->
<class-descriptor
class="org.apache.ojb.broker.Salad"
proxy="null"
table="salad"
>
<field-descriptor id="1"
name="foodId"
column="foodId"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="name"
column="name"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="calories"
column="calories"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="color"
column="color"
jdbc-type="VARCHAR"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.collections.DMapImpl -->
<class-descriptor
class="org.apache.ojb.odmg.collections.DMapImpl"
proxy="null"
table="OJB_DMAP"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="size"
column="SIZE_"
jdbc-type="INTEGER"
/>
<collection-descriptor
name="entries"
collection-class="org.apache.ojb.broker.util.collections.ManageableHashSet"
element-class-ref="org.apache.ojb.odmg.collections.DMapEntry"
>
<inverse-foreignkey field-id-ref="2"/>
</collection-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ArticleWithStockDetail -->
<class-descriptor
class="org.apache.ojb.broker.ArticleWithStockDetail"
proxy="null"
table="Artikel"
row-reader="org.apache.ojb.broker.RowReaderTestImpl"
>
<field-descriptor id="1"
name="articleId"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor id="2"
name="articleName"
column="Artikelname"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="supplierId"
column="Lieferanten_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="productGroupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="unit"
column="Liefereinheit"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="price"
column="Einzelpreis"
jdbc-type="FLOAT"
/>
<field-descriptor id="7"
name="stock"
column="Lagerbestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="8"
name="orderedUnits"
column="BestellteEinheiten"
jdbc-type="INTEGER"
/>
<field-descriptor id="9"
name="minimumStock"
column="MindestBestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="10"
name="isSelloutArticle"
column="Auslaufartikel"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldConversion"
/>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.odmg.PersonImpl -->
<class-descriptor
class="org.apache.ojb.odmg.PersonImpl"
proxy="dynamic"
table="FAMILY_MEMBER"
>
<field-descriptor id="1"
name="id"
column="ID"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="firstname"
column="FIRSTNAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="lastname"
column="LASTNAME"
jdbc-type="VARCHAR"
/>
<field-descriptor id="4"
name="motherId"
column="MOTHER_ID"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="fatherId"
column="FATHER_ID"
jdbc-type="INTEGER"
/>
<reference-descriptor
name="mother"
class-ref="org.apache.ojb.odmg.PersonImpl"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
<reference-descriptor
name="father"
class-ref="org.apache.ojb.odmg.PersonImpl"
>
<foreignkey field-id-ref="5"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ArticleWithReferenceProxy -->
<class-descriptor
class="org.apache.ojb.broker.ArticleWithReferenceProxy"
proxy="null"
table="Artikel"
>
<field-descriptor id="1"
name="articleId"
column="Artikel_Nr"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="articleName"
column="Artikelname"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="supplierId"
column="Lieferanten_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="productGroupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
/>
<field-descriptor id="5"
name="unit"
column="Liefereinheit"
jdbc-type="VARCHAR"
/>
<field-descriptor id="6"
name="price"
column="Einzelpreis"
jdbc-type="FLOAT"
/>
<field-descriptor id="7"
name="stock"
column="Lagerbestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="8"
name="orderedUnits"
column="BestellteEinheiten"
jdbc-type="INTEGER"
/>
<field-descriptor id="9"
name="minimumStock"
column="MindestBestand"
jdbc-type="INTEGER"
/>
<field-descriptor id="10"
name="isSelloutArticle"
column="Auslaufartikel"
jdbc-type="INTEGER"
conversion="org.apache.ojb.broker.accesslayer.conversions.Boolean2IntFieldConversion"
/>
<reference-descriptor
name="productGroup"
class-ref="org.apache.ojb.broker.ProductGroup"
proxy="true"
>
<foreignkey field-id-ref="4"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.Effectiveness -->
<class-descriptor
class="org.apache.ojb.broker.Effectiveness"
proxy="null"
table="Effectiveness"
>
<field-descriptor id="1"
name="pk"
column="pk"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor id="2"
name="effValue1"
column="eff_value1"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="effValue2"
column="eff_value2"
jdbc-type="INTEGER"
/>
<field-descriptor id="4"
name="effValue3"
column="eff_value3"
jdbc-type="TIMESTAMP"
/>
<field-descriptor id="5"
name="fkToVersion"
column="fk_to_version"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="version"
class-ref="org.apache.ojb.broker.Version"
>
<foreignkey field-id-ref="5"/>
</reference-descriptor>
</class-descriptor>
<!-- Mapping for Class org.apache.ojb.broker.ProductGroup -->
<class-descriptor
class="org.apache.ojb.broker.ProductGroup"
proxy="org.apache.ojb.broker.ProductGroupProxy"
table="Kategorien"
>
<field-descriptor id="1"
name="groupId"
column="Kategorie_Nr"
jdbc-type="INTEGER"
primarykey="true"
autoincrement="true"
/>
<field-descriptor id="2"
name="groupName"
column="KategorieName"
jdbc-type="VARCHAR"
/>
<field-descriptor id="3"
name="description"
column="Beschreibung"
jdbc-type="VARCHAR"
/>
<collection-descriptor
name="allArticlesInGroup"
element-class-ref="org.apache.ojb.broker.Article"
orderby="articleId"
sort="DESC"
auto-update="true"
>
<inverse-foreignkey field-id-ref="4"/>
</collection-descriptor>
</class-descriptor>
</descriptor-repository>
-- To unsubscribe, e-mail: <mailto:ojb-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:ojb-user-help@;jakarta.apache.org>
