Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 12516 invoked from network); 27 Apr 2009 13:16:10 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 27 Apr 2009 13:16:10 -0000 Received: (qmail 77481 invoked by uid 500); 27 Apr 2009 13:16:09 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 77469 invoked by uid 500); 27 Apr 2009 13:16:09 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 77459 invoked by uid 99); 27 Apr 2009 13:16:09 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Apr 2009 13:16:09 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [68.142.237.94] (HELO n9.bullet.re3.yahoo.com) (68.142.237.94) by apache.org (qpsmtpd/0.29) with SMTP; Mon, 27 Apr 2009 13:15:58 +0000 Received: from [68.142.237.88] by n9.bullet.re3.yahoo.com with NNFMP; 27 Apr 2009 13:15:37 -0000 Received: from [216.252.111.169] by t4.bullet.re3.yahoo.com with NNFMP; 27 Apr 2009 13:15:37 -0000 Received: from [127.0.0.1] by omp104.mail.re3.yahoo.com with NNFMP; 27 Apr 2009 13:15:37 -0000 X-Yahoo-Newman-Id: 319029.56838.bm@omp104.mail.re3.yahoo.com Received: (qmail 27030 invoked from network); 27 Apr 2009 13:15:37 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.de; h=Received:X-Yahoo-Newman-Property:Message-ID:Date:From:User-Agent:MIME-Version:To:Subject:References:In-Reply-To:Content-Type:Content-Transfer-Encoding; b=KFGKfzeDlOGfdVfT9DaX1y/KMb6u4jvhmlb9neATZLD6n4TiOfswiNOXpdruXz00uV32QZhmfAjn4NhbKf2eGUsqSWas13vXE16jNWTJ0GGo1eZWcJ8wPTeImH/rMCE+hFBTRaG5/TKttgde7rX+n8nZT4xH+DRIXTXc3KdeRA8= ; Received: from unknown (HELO ?132.180.195.31?) (peathal@132.180.195.31 with plain) by smtp115.plus.mail.re1.yahoo.com with SMTP; 27 Apr 2009 13:15:36 -0000 X-Yahoo-Newman-Property: ymail-3 Message-ID: <49F5AFF8.2010900@yahoo.de> Date: Mon, 27 Apr 2009 15:15:36 +0200 From: Peter User-Agent: Thunderbird 2.0.0.21 (Windows/20090302) MIME-Version: 1.0 To: user@cayenne.apache.org Subject: Re: Hibernate Migration References: <49F2FB72.3090208@yahoo.de> <49F37F32.7010003@yahoo.de> <49F4EECE.7080209@yahoo.de> <5adb61290904270555m53973097le594b4a51cfb49d2@mail.gmail.com> In-Reply-To: <5adb61290904270555m53973097le594b4a51cfb49d2@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi Michael! See comments inline. > You'll want to set the two FKs in the many-to-many join table to be > PKs in the model. Cayenne will treat this as a compound key (which is > what it really is). These links might also help: > > http://cayenne.apache.org/doc/many-to-many-relationships.html > > http://cayenne.apache.org/doc/cayennemodeler-flattened-relationships.html Thanks - I will look into this! > I've not heard of liquibase before, sorry. Okay. It is an open source database schema migration tool: http://liquibase.org/ (It comes with hibernate support ... although ... I couldn't make it working ;-)) Regards, Peter.