Return-Path: Delivered-To: apmail-incubator-cayenne-user-archive@locus.apache.org Received: (qmail 94416 invoked from network); 4 Oct 2006 20:11:54 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Oct 2006 20:11:54 -0000 Received: (qmail 8594 invoked by uid 500); 4 Oct 2006 20:11:53 -0000 Delivered-To: apmail-incubator-cayenne-user-archive@incubator.apache.org Received: (qmail 8579 invoked by uid 500); 4 Oct 2006 20:11:53 -0000 Mailing-List: contact cayenne-user-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cayenne-user@incubator.apache.org Delivered-To: mailing list cayenne-user@incubator.apache.org Received: (qmail 8570 invoked by uid 99); 4 Oct 2006 20:11:53 -0000 Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org) (140.211.166.84) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 04 Oct 2006 13:11:53 -0700 X-ASF-Spam-Status: No, hits=0.0 required=5.0 tests= Received: from [80.202.4.58] ([80.202.4.58:58967] helo=osl1smout1.broadpark.no) by idunn.apache.osuosl.org (ecelerity 2.1.1.8 r(12930)) with ESMTP id BD/03-20288-68514254 for ; Wed, 04 Oct 2006 13:11:52 -0700 Received: from osl1sminn1.broadpark.no ([80.202.4.59]) by osl1smout1.broadpark.no (Sun Java System Messaging Server 6.1 HotFix 0.05 (built Oct 21 2004)) with ESMTP id <0J6M005WXO3JDX10@osl1smout1.broadpark.no> for cayenne-user@incubator.apache.org; Wed, 04 Oct 2006 22:11:43 +0200 (CEST) Received: from [10.0.1.3] ([84.48.45.130]) by osl1sminn1.broadpark.no (Sun Java System Messaging Server 6.1 HotFix 0.05 (built Oct 21 2004)) with ESMTP id <0J6M00DFZO3JO7G3@osl1sminn1.broadpark.no> for cayenne-user@incubator.apache.org; Wed, 04 Oct 2006 22:11:43 +0200 (CEST) Date: Wed, 04 Oct 2006 22:11:41 +0200 From: Tore Halset Subject: Re: Problems with Derby, database generated primary keys and dataport In-reply-to: To: cayenne-user@incubator.apache.org Message-id: MIME-version: 1.0 X-Mailer: Apple Mail (2.752.3) Content-type: text/plain; charset=ISO-8859-1; delsp=yes; format=flowed Content-transfer-encoding: quoted-printable References: X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On Oct 4, 2006, at 01:38, =D8yvind Harboe wrote: > Has anyone tried to use Derby & dataport for a table that has a > database generated primary key in the destination? > > AFAICT, the primary key is not copied in this case, but rather the > database generated primary key is kept. I guess dataport does not know that it maybe should turn off the =20 generated key property while inserting. Are all the INSERT-commands =20 issued without setting a value for the generated column? I realy do not know as I do not use generated columns that often. =20 (that is mainly caused by the psql jdbc driver not supporting it..) - Tore.