Hi John As I read it, only Table1 ever gets updated - correctly The output suggests that Table2 is updated but that is NOT the case
Output:- Inserted newest record:- Trading_Date/Trading_Time: 2017-5-18, 18 Oldest record:- Trading_Date/Trading_Time: 2012-02-06, 6 Deleted oldest record Adding a new trade record Number: 4101 Inserted newest record:- Trade Number: 4101 PL_Updates(penultimate-begin) = 1.0 PL_Updates(latest-begin) = 1.0 hey - we got to here - [b] !!!!!!!!!! Successfully retrieved the latest trade record from TABLE2 table: Latest trade record:- Trade No: 4102 ----- SQLException ----- SQL State: 42X04 Error Code: 20000 Message: Column 'TRADE_NO_TEMP2' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'TRADE_NO_TEMP2' is not a column in the target table. ----- SQLException ----- SQL State: 25001 Error Code: 20000 Message: Cannot close a connection while a transaction is still active. -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147394.html Sent from the Apache Derby Users mailing list archive at Nabble.com.