db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bob M <rgmatth...@orcon.net.nz>
Subject Re: Commiting several operations
Date Mon, 02 Dec 2013 08:02:11 GMT
Thanks Bryan

A simple conn.commit(); has done the job !

However.........strange results - not what I was expecting :)

My 4,100 records have a date range from 6 Jan 2009 to 10 Dec 2012 and a Time
range going 0, 6, 12, 18, 0 etc.
The primary key is Date & Time fields

i.e. the oldest record is 6 Jan 2009 / 0
then 6 Jan 2009 / 6, 6 Jan 2009 / 12, 6 Jan 2009 / 18, 7 Jan 2009 / 0 etc.

In my code I am expecting to add a new record and delete the oldest record
each time the process is run
However the results I get are :-

1) no new records are added
2) the deleted records are as follows................

1 Jan 2010 / 0
1 Jan 2010 / 6
1 Jan 2010 / 12 etc etc.

Any ideas on where my code is incorrect ?

Bob M



--
View this message in context: http://apache-database.10148.n7.nabble.com/Commiting-several-operations-tp135841p135844.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.

Mime
View raw message