Return-Path: 
 <dev-return-15518-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org>
Delivered-To: apmail-openjpa-dev-archive@www.apache.org
Received: (qmail 29883 invoked from network); 9 Mar 2010 17:32:15 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 9 Mar 2010 17:32:15 -0000
Received: (qmail 97113 invoked by uid 500); 9 Mar 2010 17:31:48 -0000
Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org
Received: (qmail 97090 invoked by uid 500); 9 Mar 2010 17:31:48 -0000
Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@openjpa.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@openjpa.apache.org>
List-Post: <mailto:dev@openjpa.apache.org>
List-Id: <dev.openjpa.apache.org>
Reply-To: dev@openjpa.apache.org
Delivered-To: mailing list dev@openjpa.apache.org
Received: (qmail 96987 invoked by uid 99); 9 Mar 2010 17:31:48 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Mar 2010 17:31:47 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Mar 2010 17:31:47 +0000
Received: from brutus.apache.org (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 32F07234C4B5
	for <dev@openjpa.apache.org>; Tue,  9 Mar 2010 17:31:27 +0000 (UTC)
Message-ID: <834083718.157701268155887207.JavaMail.jira@brutus.apache.org>
Date: Tue, 9 Mar 2010 17:31:27 +0000 (UTC)
From: "Donald Woods (JIRA)" <jira@apache.org>
To: dev@openjpa.apache.org
Subject: [jira] Updated: (OPENJPA-1070) Restore support for composite
 foreign keys on MySQL
In-Reply-To: <2145845140.1241692230477.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394


     [ https://issues.apache.org/jira/browse/OPENJPA-1070?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Donald Woods updated OPENJPA-1070:
----------------------------------

    Fix Version/s: 2.0.0-M2

> Restore support for composite foreign keys on MySQL
> ---------------------------------------------------
>
>                 Key: OPENJPA-1070
>                 URL: https://issues.apache.org/jira/browse/OPENJPA-1070
>             Project: OpenJPA
>          Issue Type: Bug
>          Components: jdbc
>    Affects Versions: 1.2.1, 2.0.0-M2
>            Reporter: Martin Dirichs
>            Assignee: Pinaki Poddar
>            Priority: Minor
>             Fix For: 2.0.0-M2
>
>
> When creating the database schema for MySQL databases, OpenJPA refuses to define foreign key constraints for composite keys. Warning message is: openjpa.jdbc.Schema - The foreign key "<foreignkey>" was not added to table "[...]" The reason for this is that composite foreign key support is explicitly disabled in MySQLDictionary.
> However, composite foreign keys seem to work flawlessly in recent MySQL versions (such as 5.0.51a). Probably this limitation in MySQLDictionary thus is historic and can be removed.
> For the corresponding mailing list discussion, see here:
> http://n2.nabble.com/Composite-foreign-keys-with-MySQL-tc2772257.html

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.