Return-Path: Delivered-To: apmail-db-jdo-dev-archive@www.apache.org Received: (qmail 64495 invoked from network); 30 Aug 2006 01:22:41 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Aug 2006 01:22:41 -0000 Received: (qmail 78775 invoked by uid 500); 30 Aug 2006 01:22:41 -0000 Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-dev@db.apache.org Received: (qmail 78764 invoked by uid 99); 30 Aug 2006 01:22:41 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Aug 2006 18:22:41 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 29 Aug 2006 18:22:40 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id B4A7A7142D5 for ; Wed, 30 Aug 2006 01:19:22 +0000 (GMT) Message-ID: <10959869.1156900762737.JavaMail.jira@brutus> Date: Tue, 29 Aug 2006 18:19:22 -0700 (PDT) From: "Marc Prud'hommeaux (JIRA)" To: jdo-dev@db.apache.org Subject: [jira] Updated: (JDO-411) Attempt to bulk-delete Employee records without nulling foreign key references from InsurancePlan In-Reply-To: <20322343.1156900642267.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/JDO-411?page=all ] Marc Prud'hommeaux updated JDO-411: ----------------------------------- Attachment: DeletePersistentAll.patch > Attempt to bulk-delete Employee records without nulling foreign key references from InsurancePlan > ------------------------------------------------------------------------------------------------- > > Key: JDO-411 > URL: http://issues.apache.org/jira/browse/JDO-411 > Project: JDO > Issue Type: Bug > Components: tck20 > Affects Versions: JDO 2 final > Reporter: Marc Prud'hommeaux > Attachments: DeletePersistentAll.patch > > > Multiple test cases attempt to bulk delete instances of Person. However, the Employee subclass of Person might wind up having a non-nullable foreign key reference to Insurance or another Employee (via the "mentor" field). While the defaut Derby TCK schema does not have this constraint, in order to be flexible for other databases that will enforce the foreign key by default, some effort should be made to ensure that there are no relation constraints before the bulk deletes are attempted. This can be done by adding a nullForeignKeyReferences() method that will manually make sure that the relations are nulled. See the attached patch. > This affects the following tests: > org.apache.jdo.tck.query.delete.DeletePersistentAll.testNoParametersAPI > org.apache.jdo.tck.query.delete.DeletePersistentAll.testNoParametersSingleString > org.apache.jdo.tck.query.delete.DeletePersistentAll.testObjectArrayParametersAPI > org.apache.jdo.tck.query.delete.DeletePersistentAll.testObjectArrayParametersSingleString > org.apache.jdo.tck.query.delete.DeletePersistentAll.testMapParametersAPI > org.apache.jdo.tck.query.delete.DeletePersistentAll.testMapParametersSingleString > org.apache.jdo.tck.query.delete.DeleteQueryElements.testAPI > org.apache.jdo.tck.query.delete.DeleteQueryElements.testSingleString -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira