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: Updating 2 derby tables
Date Fri, 19 May 2017 20:13:40 GMT
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.

Mime
View raw message