Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 10047 invoked from network); 8 Jul 2009 01:43:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 8 Jul 2009 01:43:53 -0000 Received: (qmail 56102 invoked by uid 500); 8 Jul 2009 01:44:03 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 56040 invoked by uid 500); 8 Jul 2009 01:44:02 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 56032 invoked by uid 99); 8 Jul 2009 01:44:02 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Jul 2009 01:44:02 +0000 X-ASF-Spam-Status: No, hits=-2.8 required=10.0 tests=FS_REPLICA,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [192.18.6.24] (HELO gmp-eb-inf-2.sun.com) (192.18.6.24) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Jul 2009 01:43:50 +0000 Received: from fe-emea-10.sun.com (gmp-eb-lb-1-fe3.eu.sun.com [192.18.6.10]) by gmp-eb-inf-2.sun.com (8.13.7+Sun/8.12.9) with ESMTP id n681hT3G013324 for ; Wed, 8 Jul 2009 01:43:29 GMT MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; CHARSET=US-ASCII Received: from conversion-daemon.fe-emea-10.sun.com by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.02 64bit (built Apr 16 2009)) id <0KMF00500WFW4200@fe-emea-10.sun.com> for derby-user@db.apache.org; Wed, 08 Jul 2009 02:43:29 +0100 (BST) Received: from khepri23.norway.sun.com ([unknown] [129.159.112.235]) by fe-emea-10.sun.com (Sun Java(tm) System Messaging Server 7u2-7.02 64bit (built Apr 16 2009)) with ESMTPSA id <0KMF0049IWSGDEB0@fe-emea-10.sun.com> for derby-user@db.apache.org; Wed, 08 Jul 2009 02:43:29 +0100 (BST) Date: Wed, 08 Jul 2009 03:43:28 +0200 From: Dag.Wanvik@Sun.COM (Dag H. Wanvik) Subject: Re: Derby replication seems to be mostly useless In-reply-to: <4A535E2B.2080903@sun.com> Sender: Dag.Wanvik@Sun.COM To: Derby Discussion Message-id: References: <4A522D68.50401@sun.com> <4A532B59.2010800@sun.com> <4A535E2B.2080903@sun.com> User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.1 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org Alan Burlison writes: > I'm wondering if this chaos is being caused by the fact that the derby > database owner and the owner of the only schema in the database that > is being replicated are different users? The database is created by > user "admin", then the following DB configuration is done: > > derby.database.propertiesOnly = true > derby.authentication.provider = BUILTIN > derby.database.defaultConnectionMode = noAccess > derby.database.requireAuthentication = true > derby.user.admin = admin > derby.user.auth = CHANGEME > derby.database.fullAccessUsers = admin,auth > create schema auth authorization auth > > The application then creates its tables in the auth schema. Could > that be the issue? No, that should not matter unless there is a bug somewhere. Maybe we can best untangle these issues if you can provide a repro? Dag