Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 18683 invoked from network); 14 Aug 2008 11:39:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Aug 2008 11:39:14 -0000 Received: (qmail 51306 invoked by uid 500); 14 Aug 2008 11:39:12 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 51033 invoked by uid 500); 14 Aug 2008 11:39:12 -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 51022 invoked by uid 99); 14 Aug 2008 11:39:11 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Aug 2008 04:39:11 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=SPF_PASS,WHOIS_NETSOLPR X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of dmitri.pissarenko@gmail.com designates 64.233.184.238 as permitted sender) Received: from [64.233.184.238] (HELO wr-out-0506.google.com) (64.233.184.238) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Aug 2008 11:38:13 +0000 Received: by wr-out-0506.google.com with SMTP id 67so934845wri.3 for ; Thu, 14 Aug 2008 04:38:23 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type :content-transfer-encoding:content-disposition:references; bh=/E+E2zuIuGM6CskgN8PSZBW3z5ZOxW2WGqdAAlhSN3M=; b=l5MVM/+AOLdmHiT0sDWrjmSeEiu9OzcBPs9NQiXNP3pnroDfjPx+GZUxZUbpMUlTcS nxJVhA2gGl03ashfmwwZHrpoQevllCOG0hShx0QS35jMpzn/8LUNYn4qXLfVq/HdyaYI buGFSkXoaVXZDtCnC98VVDMydy1Rusjq6PTiE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:content-transfer-encoding:content-disposition :references; b=Nv94eh9E0tu2lYPR8HbUp4xk5NVarcHp6xYW0Ynjlp4rmmYlDEzE03k8BxvEj8aOmn +0KrgWaADr+wKDvqb+VY24TkH1deU7lFLaSn37JnS0z2qLiKtrBkLig8EWwNPpybIrz+ AsEFWdj3DJm9XH1MioNrNRH8JATQrXDdpWgU0= Received: by 10.90.35.9 with SMTP id i9mr1677838agi.77.1218713903569; Thu, 14 Aug 2008 04:38:23 -0700 (PDT) Received: by 10.90.86.13 with HTTP; Thu, 14 Aug 2008 04:38:23 -0700 (PDT) Message-ID: Date: Thu, 14 Aug 2008 13:38:23 +0200 From: "Dmitri Pissarenko" To: "Derby Discussion" Subject: Re: Problem with UNIQUE constraint In-Reply-To: <15516722-1EBE-4E58-BF31-5B483F3658DB@SUN.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <27AC242A-F71A-42F9-BD42-11C80310EEDC@SUN.com> <15516722-1EBE-4E58-BF31-5B483F3658DB@SUN.com> X-Virus-Checked: Checked by ClamAV on apache.org Hello! On Thu, Aug 14, 2008 at 12:38 AM, Craig L Russell wrote: > The two Timestamp columns have resolution of nanoseconds, which you might > not see depending on how you format the columns. I don't think that there is a problem with timestamp because I explicitly call timestamp.setNanos(0); before inserting a timestamp into the database. Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko