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 65D3992C6 for ; Tue, 3 Apr 2012 10:23:48 +0000 (UTC) Received: (qmail 78603 invoked by uid 500); 3 Apr 2012 10:23:48 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 78548 invoked by uid 500); 3 Apr 2012 10:23:47 -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 78274 invoked by uid 99); 3 Apr 2012 10:23:47 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2012 10:23:47 +0000 X-ASF-Spam-Status: No, hits=0.9 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: 216.139.236.26 is neither permitted nor denied by domain of coolyunus1986@gmail.com) Received: from [216.139.236.26] (HELO sam.nabble.com) (216.139.236.26) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 03 Apr 2012 10:23:42 +0000 Received: from ben.nabble.com ([192.168.236.152]) by sam.nabble.com with esmtp (Exim 4.72) (envelope-from ) id 1SF0tV-0004mJ-N9 for user@cayenne.apache.org; Tue, 03 Apr 2012 03:23:21 -0700 Date: Tue, 3 Apr 2012 03:23:21 -0700 (PDT) From: yunus To: user@cayenne.apache.org Message-ID: <1333448601689-3880428.post@n3.nabble.com> In-Reply-To: <05E6C923-76A4-41B7-9702-419379AAD951@objectstyle.org> References: <4EBD0DC7.1050802@gmail.com> <1333013942631-3867223.post@n3.nabble.com> <05E6C923-76A4-41B7-9702-419379AAD951@objectstyle.org> Subject: Re: Cayenne with JSF 2 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org hi Andrus, I have two queries related to cayenne- 1- I have a table "registration" in which there is a primary key "EnrolmentId" which is autogenerated after successfully registration. Other attributes are "Name" and "PAN ID".(PAN ID can belong to more than one member of a family).So i want to know how i can find that a person cannot register more than once.I want to find through combined search of (Name & PAN ID) but these are not composite key as Enrolment id is already a primary key.Now can you tell me how it can be done using Cayenne. 2-How can i restrict cayenne to autogenerate the primary key.The scenario is that i have a table "LOGIN" in which "UserID" is primary key and i dont want it to be generated automatically.It is upto the user to create his "userID" so how can i do that? -- View this message in context: http://cayenne.195.n3.nabble.com/Cayenne-with-JSF-2-tp3499495p3880428.html Sent from the Cayenne - User mailing list archive at Nabble.com.