Return-Path: X-Original-To: apmail-cayenne-user-archive@www.apache.org Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8700B65C7 for ; Wed, 22 Jun 2011 06:57:24 +0000 (UTC) Received: (qmail 61428 invoked by uid 500); 22 Jun 2011 06:57:24 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 61141 invoked by uid 500); 22 Jun 2011 06:57:16 -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 61128 invoked by uid 99); 22 Jun 2011 06:57:13 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 22 Jun 2011 06:57:13 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [208.78.103.231] (HELO vorsha.objectstyle.org) (208.78.103.231) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 22 Jun 2011 06:57:07 +0000 Received: (qmail 22238 invoked from network); 22 Jun 2011 06:56:46 -0000 Received: from unknown (HELO ?192.168.1.100?) (194.158.197.10) by vorsha.objectstyle.org with SMTP; 22 Jun 2011 06:56:46 -0000 Content-Type: text/plain; charset=iso-8859-1 Mime-Version: 1.0 (Apple Message framework v1084) Subject: Re: Oracle Sequences & Cache From: Andrus Adamchik In-Reply-To: Date: Wed, 22 Jun 2011 09:56:45 +0300 Content-Transfer-Encoding: quoted-printable Message-Id: <3F4F0D25-19A1-4466-B4C5-49B419F749D1@objectstyle.org> References: <4DFA2317.7020601@holos.pt> <0E9C9D81-1535-4C9F-A6AE-3F05DEA3DAE0@objectstyle.org> To: user@cayenne.apache.org X-Mailer: Apple Mail (2.1084) There's something else at play then. As I mentioned in the earlier = message, your code example does not affect PK generation at all. Andrus On Jun 22, 2011, at 12:27 AM, Bruno Ren=E9 Santos wrote: > That did not solve the problem... Maybe the use of shared cache is a > problem? I turn off the cache alltogether and the problem did not = happen > anymore. >=20 > Regards > Bruno >=20 > On Sun, Jun 19, 2011 at 9:54 AM, Andrus Adamchik = wrote: >=20 >>=20 >> On Jun 16, 2011, at 7:49 PM, Chris Poulsen wrote: >>=20 >>> >>> ORACLE >>>=20 >> PK_CONTACT_PERSON_KEY_SEQ >>> 1 >>> >>=20 >> Yep, that's the trick to map a sequence with increment of 1. On the = Modeler >> side it is configured here: >>=20 >> http://people.apache.org/~aadamchik/sequence.png >>=20 >> Andrus >>=20 >>=20 >>=20 >=20 >=20 > --=20 > Bruno Ren=E9 Santos | brunorene@holos.pt | Gestor de Projectos | = Analista | > Programador | Investigador >=20 > Holos - Solu=E7=F5es Avan=E7adas em Tecnologias de Informa=E7=E3o S.A. > Parque de Ci=EAncia e Tecnologia de Almada/Set=FAbal . Edif=EDcio = Madan Parque > Rua dos Inventores . Quinta da Torre . 2825 - 182 Caparica . Portugal > Phone: +351 210 438 686 . Fax: +351 210 438 687 . Web: www.holos.pt >=20 > This email and any files transmitted with it are confidential and = intended > solely for the use of the individual or entity to whom they are = addressed. > If you are not the intended recipient or the person responsible for > delivering the email to the intended recipient, be advised that you = have > received this email in error and that any use, dissemination, = forwarding, > printing, or copying of this email is strictly prohibited. If you have > received this email in error please notify Bruno Ren=E9 Santos by = telephone on > +351 210 438 686