Return-Path: 
 <user-return-7849-apmail-cayenne-user-archive=cayenne.apache.org@cayenne.apache.org>
X-Original-To: apmail-cayenne-user-archive@www.apache.org
Delivered-To: apmail-cayenne-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 6C42C672C
	for <apmail-cayenne-user-archive@www.apache.org>;
 Wed, 18 May 2011 23:55:55 +0000 (UTC)
Received: (qmail 45798 invoked by uid 500); 18 May 2011 23:55:55 -0000
Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org
Received: (qmail 45738 invoked by uid 500); 18 May 2011 23:55:54 -0000
Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@cayenne.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@cayenne.apache.org>
List-Post: <mailto:user@cayenne.apache.org>
List-Id: <user.cayenne.apache.org>
Reply-To: user@cayenne.apache.org
Delivered-To: mailing list user@cayenne.apache.org
Received: (qmail 45730 invoked by uid 99); 18 May 2011 23:55:54 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 May 2011 23:55:54 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: local policy)
Received: from [208.78.103.231] (HELO vorsha.objectstyle.org) (208.78.103.231)
    by apache.org (qpsmtpd/0.29) with SMTP; Wed, 18 May 2011 23:55:47 +0000
Received: (qmail 24191 invoked from network); 18 May 2011 23:55:26 -0000
Received: from unknown (HELO ?IPv6:::1?) (127.0.0.1)
  by localhost with SMTP; 18 May 2011 23:55:26 -0000
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0 (Apple Message framework v1084)
Subject: Re: Help or sample on vertical inheritance
From: Andrus Adamchik <andrus@objectstyle.org>
In-Reply-To: <afc1a739-3d9b-4b26-bbaf-24b743cd69f3@gondor.welinux.cl>
Date: Wed, 18 May 2011 19:55:26 -0400
Content-Transfer-Encoding: quoted-printable
Message-Id: <AFEFEB50-3D9B-4BBA-B590-1766FF7693C8@objectstyle.org>
References: <afc1a739-3d9b-4b26-bbaf-24b743cd69f3@gondor.welinux.cl>
To: user@cayenne.apache.org
X-Mailer: Apple Mail (2.1084)

Ok, here is a modified version of that DataMap that has vertical =
inheritance mapped correctly. Per =
http://cayenne.apache.org/doc30/modeling-vertical-inheritance.html =
v-inheritance in Cayenne is the same as single-table, only with =
flattened attributes to child tables. So the main change that I made was =
mapping Programmer to ARTIST table, and then flattenning "languages" =
attribute to "programmer.LANGUAGES".=20

Also removed ObjRelationships between Artist and Programmer. That should =
be it.=20

Sorry for delayed reply.

Cheers,
Andrus


<?xml version=3D"1.0" encoding=3D"utf-8"?>
<data-map xmlns=3D"http://cayenne.apache.org/schema/3.0/modelMap"
  xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation=3D"http://cayenne.apache.org/schema/3.0/modelMap =
http://cayenne.apache.org/schema/3.0/modelMap.xsd"
  project-version=3D"3.0.0.1">
	<property name=3D"defaultPackage" =
value=3D"org.apache.cayenne.tutorial.persistent"/>
	<db-entity name=3D"ARTIST">
		<db-attribute name=3D"DATE_OF_BIRTH" type=3D"DATE"/>
		<db-attribute name=3D"ID" type=3D"INTEGER" =
isPrimaryKey=3D"true" isMandatory=3D"true"/>
		<db-attribute name=3D"NAME" type=3D"VARCHAR" =
length=3D"200"/>
		<db-attribute name=3D"TIPO" type=3D"CHAR" =
isMandatory=3D"true" length=3D"1"/>
	</db-entity>
	<db-entity name=3D"GALLERY">
		<db-attribute name=3D"ID" type=3D"INTEGER" =
isPrimaryKey=3D"true" isMandatory=3D"true"/>
		<db-attribute name=3D"NAME" type=3D"VARCHAR" =
length=3D"200"/>
	</db-entity>
	<db-entity name=3D"PAINTING">
		<db-attribute name=3D"ARTIST_ID" type=3D"INTEGER"/>
		<db-attribute name=3D"GALLERY_ID" type=3D"INTEGER"/>
		<db-attribute name=3D"ID" type=3D"INTEGER" =
isPrimaryKey=3D"true" isMandatory=3D"true"/>
		<db-attribute name=3D"NAME" type=3D"VARCHAR" =
length=3D"200"/>
	</db-entity>
	<db-entity name=3D"PROGRAMMER">
		<db-attribute name=3D"ID" type=3D"INTEGER" =
isPrimaryKey=3D"true" isMandatory=3D"true"/>
		<db-attribute name=3D"LANGUAGES" type=3D"VARCHAR" =
length=3D"256"/>
	</db-entity>
	<obj-entity name=3D"Artist" =
className=3D"org.apache.cayenne.tutorial.persistent.Artist" =
dbEntityName=3D"ARTIST">
		<obj-attribute name=3D"dateOfBirth" =
type=3D"java.util.Date" db-attribute-path=3D"DATE_OF_BIRTH"/>
		<obj-attribute name=3D"name" type=3D"java.lang.String" =
db-attribute-path=3D"NAME"/>
		<obj-attribute name=3D"tipo" type=3D"java.lang.String" =
db-attribute-path=3D"TIPO"/>
	</obj-entity>
	<obj-entity name=3D"Gallery" =
className=3D"org.apache.cayenne.tutorial.persistent.Gallery" =
dbEntityName=3D"GALLERY">
		<obj-attribute name=3D"name" type=3D"java.lang.String" =
db-attribute-path=3D"NAME"/>
	</obj-entity>
	<obj-entity name=3D"Painting" =
className=3D"org.apache.cayenne.tutorial.persistent.Painting" =
dbEntityName=3D"PAINTING">
		<obj-attribute name=3D"name" type=3D"java.lang.String" =
db-attribute-path=3D"NAME"/>
	</obj-entity>
	<obj-entity name=3D"Programmer" superEntityName=3D"Artist" =
className=3D"org.apache.cayenne.tutorial.persistent.Programmer" =
dbEntityName=3D"ARTIST">
		<qualifier><![CDATA[tipo =3D "P"]]></qualifier>
		<obj-attribute name=3D"languages" =
type=3D"java.lang.String" db-attribute-path=3D"programmer.LANGUAGES"/>
	</obj-entity>
	<db-relationship name=3D"paintings" source=3D"ARTIST" =
target=3D"PAINTING" toMany=3D"true">
		<db-attribute-pair source=3D"ID" target=3D"ARTIST_ID"/>
	</db-relationship>
	<db-relationship name=3D"programmer" source=3D"ARTIST" =
target=3D"PROGRAMMER" toDependentPK=3D"true" toMany=3D"false">
		<db-attribute-pair source=3D"ID" target=3D"ID"/>
	</db-relationship>
	<db-relationship name=3D"paintings" source=3D"GALLERY" =
target=3D"PAINTING" toMany=3D"true">
		<db-attribute-pair source=3D"ID" target=3D"GALLERY_ID"/>
	</db-relationship>
	<db-relationship name=3D"artist" source=3D"PAINTING" =
target=3D"ARTIST" toMany=3D"false">
		<db-attribute-pair source=3D"ARTIST_ID" target=3D"ID"/>
	</db-relationship>
	<db-relationship name=3D"gallery" source=3D"PAINTING" =
target=3D"GALLERY" toMany=3D"false">
		<db-attribute-pair source=3D"GALLERY_ID" target=3D"ID"/>
	</db-relationship>
	<db-relationship name=3D"artist" source=3D"PROGRAMMER" =
target=3D"ARTIST" toMany=3D"false">
		<db-attribute-pair source=3D"ID" target=3D"ID"/>
	</db-relationship>
	<obj-relationship name=3D"paintings" source=3D"Artist" =
target=3D"Painting" deleteRule=3D"Cascade" =
db-relationship-path=3D"paintings"/>
	<obj-relationship name=3D"paintings" source=3D"Gallery" =
target=3D"Painting" deleteRule=3D"Nullify" =
db-relationship-path=3D"paintings"/>
	<obj-relationship name=3D"artist" source=3D"Painting" =
target=3D"Artist" deleteRule=3D"Nullify" db-relationship-path=3D"artist"/>=

	<obj-relationship name=3D"gallery" source=3D"Painting" =
target=3D"Gallery" deleteRule=3D"Nullify" =
db-relationship-path=3D"gallery"/>
</data-map>