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 D774F17CD2 for ; Wed, 2 Dec 2015 09:30:43 +0000 (UTC) Received: (qmail 33793 invoked by uid 500); 2 Dec 2015 09:30:38 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 33735 invoked by uid 500); 2 Dec 2015 09:30:38 -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 33721 invoked by uid 99); 2 Dec 2015 09:30:38 -0000 Received: from mail-relay.apache.org (HELO mail-relay.apache.org) (140.211.11.15) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Dec 2015 09:30:38 +0000 Received: from Aristedess-MacBook-Pro.local (ppp59-167-140-203.static.internode.on.net [59.167.140.203]) by mail-relay.apache.org (ASF Mail Server at mail-relay.apache.org) with ESMTPSA id 7D30E1A0056 for ; Wed, 2 Dec 2015 09:30:37 +0000 (UTC) To: user@cayenne.apache.org From: Aristedes Maniatis Subject: using database generated PK Message-ID: <565EBA37.5060805@apache.org> Date: Wed, 2 Dec 2015 20:30:31 +1100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:42.0) Gecko/20100101 Thunderbird/42.0 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit I've always used the AUTO_PK_SUPPORT approach to PK generation, all the way back from WebObject EOF days many many years ago. However a recently discovered bug in this approach [1] and how it intersects with transactions may require use to think about going over to database generated primary keys with a auto-increment column. For developers not using an ORM this is pretty common I understand. What are the downsides to that approach? Is performance, reliability and everything else just the same? What problem was AUTO_PK_SUPPORT originally designed to solve? Cheers Ari [1] https://issues.apache.org/jira/browse/CAY-2040 -- --------------------------> Aristedes Maniatis GPG fingerprint CBFB 84B4 738D 4E87 5E5C 5EFA EF6A 7D2E 3E49 102A