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.
