Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: jdo-dev@db.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
From: Andy Jefferson <andy@datanucleus.org>
To: jdo-dev@db.apache.org
Subject: Re: DN support for derby sequences
Date: Sun, 12 Feb 2012 19:35:32 +0000
User-Agent: KMail/1.12.4 (Linux/2.6.31.13-desktop-1mnb; KDE/4.3.5; i686; ; )
References: <4F381180.9040102@akquinet.de>
In-Reply-To: <4F381180.9040102@akquinet.de>
Organization: DataNucleus
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <201202121935.32204.andy@datanucleus.org>

> Is it an issue to support sequences in the derby adapter? The derby
> database itself supports sequences since version 10.6.

Hi Michael,

you can easily contribute support.
The adapter for Derby at
http://datanucleus.svn.sourceforge.net/viewvc/datanucleus/platform/store.rdbms/trunk/src/java/org/datanucleus/store/rdbms/adapter/DerbyAdapter.java?revision=14093&view=markup
needs updating to include support for versions 10.6+ (only). 

To see an example of an adapter which has support look at
http://datanucleus.svn.sourceforge.net/viewvc/datanucleus/platform/store.rdbms/trunk/src/java/org/datanucleus/store/rdbms/adapter/HSQLAdapter.java?revision=11607&view=markup
and search for "sequence" (case-insensitive); ought to give you enough of an 
idea what is needed. Then raise a DN JIRA and attach a patch.

-- 
Andy
DataNucleus (http://www.datanucleus.org)