Re: Updating 2 derby tables error message interpretation

2017-05-27 Thread Bryan Pendleton
> So my question is: why do I not see the new 54 table2 records that my > program says have been created? > > Perhaps you didn't COMMIT the 54 records in your test program? Perhaps your test program is using a different Derby database than you're looking at with NetBeans? Perhaps your test

Re: Updating 2 derby tables error message interpretation

2017-05-26 Thread Bob M
Hi Rick, John, Bryan et al Things are a *little* clearer now :) I was a bit premature in stating that all was OK To try and rectify my problem (without understanding what was wrong) I changed the index in table2 from a single column (INT) to a 2 column index (DATE and TIME) exactly as Table1

Re: Updating 2 derby tables error message interpretation

2017-05-24 Thread Bob M
hello everybody I looked at the setup of both tables and found that the key in the first, made up of two fields, had each field NOT NULL So I applied this to the single field key in table2 - Trade Number Now - no errors :) Thanks to all, for such great advice Bob M -- View this message in

Re: Updating 2 derby tables error message interpretation

2017-05-23 Thread John English
On 23/05/2017 15:14, Bob M wrote: The error message(s): mining routine finished simulation routine commenced simulation routine finished final prediction routine commenced Prediction_Trend: 0.0 Current Trade Direction: debug: we get to here(8) final prediction routine finished Weka

Re: Updating 2 derby tables error message interpretation

2017-05-23 Thread Bob M
Hi Descriptive: My program runs every six hours. Two independent tables are setup - each with 4,100 records On the first run a trade is opened and table 1 has a new record added and the oldest one is deleted - all OK On the second run, I am expecting the TRADES table to have a new record added.