From derby-user-return-9655-apmail-db-derby-user-archive=db.apache.org@db.apache.org Thu Aug 14 11:17:08 2008 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 5145 invoked from network); 14 Aug 2008 11:17:08 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 14 Aug 2008 11:17:08 -0000 Received: (qmail 20723 invoked by uid 500); 14 Aug 2008 11:17:06 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 20698 invoked by uid 500); 14 Aug 2008 11:17:06 -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 20687 invoked by uid 99); 14 Aug 2008 11:17:06 -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:17:06 -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.231 as permitted sender) Received: from [64.233.184.231] (HELO wr-out-0506.google.com) (64.233.184.231) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 14 Aug 2008 11:16:07 +0000 Received: by wr-out-0506.google.com with SMTP id 67so919249wri.3 for ; Thu, 14 Aug 2008 04:16:17 -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=evJXLe4NBE4xJHDp+m+C2K8ITu2slnfdBxQbfoxRS5M=; b=cVi3v1r2/Y1RLrc/D2LGViPgLOtD1KQuHv4KyuT5CxphdeKkYizm7489lxb7Sr/iR4 t2C1TSbtCEs99684WDhNJ6CSJ4r+o/bQj+ABtnesP88ORxjoC9BTSinbEAkPi4IJDCZi 5JMG84Tok4WIIzgLpT4PZh9/tpYiGAdxjR6rs= 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=s34AULZpSHnJGuVOq7UMQw4Y2dPknIu4ciZAmQqItUaqBnDp3nvJZztcfD8bKGzVAU INLTaI1pZZ4wgYJBigA3eKMnE2UfwrZQPUJ1bIrlexp684ererp5O+3cWSLjGmoxcR2a 4kCvcQGAh2H4n490ZQFVj2d350ZNRLWVF1J0s= Received: by 10.90.27.5 with SMTP id a5mr1644513aga.85.1218712577807; Thu, 14 Aug 2008 04:16:17 -0700 (PDT) Received: by 10.90.86.13 with HTTP; Thu, 14 Aug 2008 04:16:17 -0700 (PDT) Message-ID: Date: Thu, 14 Aug 2008 13:16:17 +0200 From: "Dmitri Pissarenko" To: "Derby Discussion" Subject: Re: Problem with UNIQUE constraint In-Reply-To: <48A359CB.7010302@sbcglobal.net> 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> <48A359CB.7010302@sbcglobal.net> X-Virus-Checked: Checked by ClamAV on apache.org Hello! >> { >> statement = aConnection.prepareStatement( >> MyTable.INSERT_STATEMENT); >> >> > > What is MyTable.INSERT_STATEMENT? public static final String INSERT_STATEMENT = "INSERT INTO MyTable (field01, " + "field02, field03, field04, field05, field06," + "field07, field08, field09, field10, field11, field12," + "field13, field14, field15, field16, field17, field18," + "field19, field20, field21, field22, field24, " + "field25, field26, field27, field28, field29, field30)" + " VALUES (?, ?," + "?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"; Best regards Dmitri Pissarenko -- http://www.xing.com/profile/Dmitri_Pissarenko