Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 43650 invoked from network); 7 May 2009 10:31:02 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 7 May 2009 10:31:02 -0000 Received: (qmail 9875 invoked by uid 500); 7 May 2009 10:31:01 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 9773 invoked by uid 500); 7 May 2009 10:31:01 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 9762 invoked by uid 99); 7 May 2009 10:31:01 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 07 May 2009 10:31:01 +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; Thu, 07 May 2009 10:30:51 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 74CB1234C044 for ; Thu, 7 May 2009 03:30:30 -0700 (PDT) Message-ID: <2145845140.1241692230477.JavaMail.jira@brutus> Date: Thu, 7 May 2009 03:30:30 -0700 (PDT) From: "Martin Dirichs (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-1070) Restore support for composite foreign keys on MySQL MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org 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 Reporter: Martin Dirichs Priority: Minor 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 "" 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.