Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (athena.apache.org: domain of Dyre.Tjeldvoll@oracle.com
 designates 141.146.126.69 as permitted sender)
Message-ID: <5326B712.7030601@oracle.com>
Date: Mon, 17 Mar 2014 09:49:22 +0100
From: Dyre Tjeldvoll <Dyre.Tjeldvoll@oracle.com>
Organization: Oracle
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:24.0) Gecko/20100101 Thunderbird/24.2.0
MIME-Version: 1.0
To: derby-user@db.apache.org
Subject: Re: Adding a new record to a table
References: <1394992481692-138004.post@n7.nabble.com>
In-Reply-To: <1394992481692-138004.post@n7.nabble.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

On 03/16/2014 06:54 PM, Bob M wrote:
> On a regular basis I add a new record and delete the oldest record in my
> table
> The records have a key and up until recently were listed by date/time order
> as I wish to have them
>
> I understand that this is unnecessary but it is great to always find the
> latest records at the end of the table
>
> Now, after a tweek in the code, my newest records are being written at the
> beginning of the table next to the oldest records ?????
>
> What code do I need to add, so that when any new record is added, it will
> appear at the end of the table and not at the beginning ?

At the risk of sounding somewhat pedantic: A database table is NOT an 
array on disk. You do NOT control where (physically) your records end 
up. The order in which you SEE records is determined by the ORDER BY 
clause you use for your query.

If you don't specify an ORDER BY clause it may appear that the order is 
predictable and that it corresponds to the chronological order in which 
records were inserted, but this is merely a coincidence, and cannot be 
relied upon.

Derby does not, unlike some other databases, automatically add a rowid 
column to your table that is always increased when adding records to the 
table. You can create such a column manually - see

https://builds.apache.org/job/Derby-docs/lastSuccessfulBuild/artifact/trunk/out/ref/index.html

-- 
Regards,

Dyre