Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 5954 invoked from network); 1 Feb 2011 20:41:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 1 Feb 2011 20:41:39 -0000 Received: (qmail 6831 invoked by uid 500); 1 Feb 2011 20:41:39 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 6654 invoked by uid 500); 1 Feb 2011 20:41:38 -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 6641 invoked by uid 99); 1 Feb 2011 20:41:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Feb 2011 20:41:38 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [148.87.113.121] (HELO rcsinet10.oracle.com) (148.87.113.121) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 01 Feb 2011 20:41:28 +0000 Received: from rcsinet13.oracle.com (rcsinet13.oracle.com [148.87.113.125]) by rcsinet10.oracle.com (Switch-3.4.2/Switch-3.4.2) with ESMTP id p11Kf4K2028034 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Tue, 1 Feb 2011 20:41:06 GMT Received: from acsmt353.oracle.com (acsmt353.oracle.com [141.146.40.153]) by rcsinet13.oracle.com (Switch-3.4.2/Switch-3.4.1) with ESMTP id p11Kf0s2023862 for ; Tue, 1 Feb 2011 20:41:02 GMT Received: from abhmt018.oracle.com by acsmt354.oracle.com with ESMTP id 971638151296592739; Tue, 01 Feb 2011 12:38:59 -0800 Received: from localhost (/188.113.85.108) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Tue, 01 Feb 2011 12:38:59 -0800 From: dag.wanvik@oracle.com (Dag H. Wanvik) To: "Derby Discussion" Subject: Re: Update sequence References: Date: Tue, 01 Feb 2011 21:38:57 +0100 In-Reply-To: (Brett Wooldridge's message of "Mon, 31 Jan 2011 15:23:18 +0900") Message-ID: User-Agent: Gnus/5.110011 (No Gnus v0.11) Emacs/23.1 (usg-unix-v) MIME-Version: 1.0 Content-Type: text/plain X-Virus-Checked: Checked by ClamAV on apache.org Brett Wooldridge writes: > We are currently using Hibernate with a table managed sequence scheme > (javax.persistence.GenerationType.TABLE), but now that Derby supports > Sequences we are considering migrating to real sequences > (javax.persistence.GenerationType.SEQUENCE). > > One question we have is, is it possible to ALTER a sequence? From > what I've seen, the answer is currently no, but I thought I would ask > here just in case. It is not supported. You would have to do a DROP + a new CREATE. Note that a new sequence can take a START WITH value, though. Thanks, Dag