I have reinitialized my system and have run my program on a testing platform
At the first time period, everything goes perfectly and it opens a trade but there is no requirement to update the second of the two derby tables (the first table is updated OK) On the second run, the first derby table is updated OK but then an error occurs I have never seen the second table having a record added Inserted newest record:- Trading_Date/Trading_Time: 2016-1-11, 12 Oldest record:- Trading_Date/Trading_Time: 2012-02-06, 6 Deleted oldest record *the above refers to table1* Adding a new trade record Number: 4101 *this refers to table2* ----- SQLException ----- SQL State: 23505 Error Code: 20000 Message: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'SQL170412104646890' defined on 'TRADES'. ----- SQLException ----- SQL State: 25001 Error Code: 20000 Message: Cannot close a connection while a transaction is still active. Derby finished ******************************************* -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147398.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
