Re: Multiple Derby embedded engine instances - problem

2019-07-24 Thread Bob M
o far, I have had no errors involving missing drivers etc. In addition, I get a new record added to each database each hour My problem was a timing issue involving instances of derby opening while another instance was already opened I don't know how to better my 'work-around' Bob M -- Sent fro

Re: Multiple Derby embedded engine instances - problem

2019-07-23 Thread Bob M
coming from the second program is referenced Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Multiple Derby embedded engine instances - problem

2019-07-23 Thread Bob M
starting until the previous task is finished? I can see a need here for a basic scheduler Any thoughts / suggestions ? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Multiple Derby embedded engine instances - problem

2019-07-14 Thread Bob M
Hi Rick and Bryan Many, many thanks for all your good advice Off to a very good start today... My problem seems to have been a mismatch of derby.jar versions And now, I know how to setup the derby.properties file and where to put it :) Thanks again - a great forum Bob M Dunedin New

Re: Multiple Derby embedded engine instances - problem

2019-07-12 Thread Bob M
Bryan Environment Variables System Variables variable = Path value = %DERBY_INSTALL%\lib\derby.jar Is that what you are meaning? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Multiple Derby embedded engine instances - problem

2019-07-12 Thread Bob M
all copies of derby.jar come from version 10.14.2.0 On Monday I shall see what occurs :) Bob M New Zealand -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Multiple Derby embedded engine instances - problem

2019-07-12 Thread Bob M
Unable to load the JDBC driver org.apache.derby.jdbc.Embedded Driver Please check your ClASSPATH and the derby log file was as shown abve On the second hour my log file showed only the first line and no derby log file can be found Bob M -- Sent from: http://apache-database.10148.n7.nabble.com

Re: Multiple Derby embedded engine instances - problem

2019-07-12 Thread Bob M
Hi Rick added the two properties as suggested the result was dramatic ! in each program I write several lines to a file this file contains only the first of many lines that should have been outputed - then nothing what do I do now ? Bob M -- Sent from: http://apache-database.10148.n7

Re: Multiple Derby embedded engine instances - problem

2019-07-12 Thread Bob M
hutting down instance a816c00e-016b-e37a-c4d7-0b206fe8 on database directory C:\Users\b\Databases\us_copiosus_EURCAD_1010 with class loader com.dukascopy.dds2.greed.agent.a.c@31499e31 -------- Bob M -- Sent from: http://apache-d

Multiple Derby embedded engine instances - problem

2019-07-11 Thread Bob M
1 or more of the programs I have a separate copy of the driver in a different folder for each program 2) an undisclosed error (i.e. no error message) but the connection is NOT made and nothing is updated Please can somebody suggest where I might look to sort out these two problems ? Bob M -- Sent from: htt

Re: obtaining a column value from a subset of a table

2018-12-16 Thread Bob M
thanks Rick I understand now Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

obtaining a column value from a subset of a table

2018-12-15 Thread Bob M
is a column in the table but I am not getting the value from that column what am I missing? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: selecting a particular record from a derby table

2018-12-14 Thread Bob M
Hi Harm-Jan Good spotting - sloppy coding Many thanks Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: selecting a particular record from a derby table

2018-12-13 Thread Bob M
curances is : - " + (Occurances + 1)), File_Name); *** Candidate_ID_to_be_validated = 3 The last entry in the log file is "we get to here - 2" and I get a NullPointerException error - not exactly sure which line is creating this error Bob M -

selecting a particular record from a derby table

2018-12-12 Thread Bob M
*** I am getting an error on the first line of code SQL State: 42X04 Error Code: 2 Message: Column 'Candidate_ID' is either not in any table or What should I change in the first line ? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

deleting records from a table

2018-12-10 Thread Bob M
or database What do I need to do to be able to alter data in a table ? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Counting a subset of records

2018-12-04 Thread Bob M
from table_name where ID = Search_ID"); The program falters on this line and I am unclear why ? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Is this code correct ?

2018-12-03 Thread Bob M
Hello Hans Thank you - you are quite correct Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Is this code correct ?

2018-12-02 Thread Bob M
The program actions line 8 where it prints out the penultimate record Date and Time However, the next line - rs = s.executeQuery("SELECT...FOR UPDATE"); is not working I can not understand why ? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Us

Is this code correct ?

2018-11-30 Thread Bob M
ltimate record in table HOURLY_HISTORY: "); fw.writetoFile(("Updated penultimate record with p0, result0, p1 & result1"), File_Name); // commit the above transactions conn.commit(); // end of updating the penultimate record [/code] It would appear that the program is faultering d

Re: Installing Derby

2018-11-28 Thread Bob M
I have now successfully created a new database in a different folder Many thanks Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Installing Derby

2018-11-28 Thread Bob M
Hello Harm-Jan I have checked and both environmental variables are there Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: Installing Derby

2018-11-27 Thread Bob M
Also there is only 1 user account on my computer and that is me - as administrator Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Installing Derby

2018-11-27 Thread Bob M
'; Wed Nov 28 15:55:44 NZDT 2018 Thread[main,5,main] java.io.FileNotFoundException: derby.log (Access is denied) *** what have I forgotten to do ? Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Re: creating a database

2018-04-08 Thread Bob M
got it now.. many thanks :) Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

creating a database

2018-04-07 Thread Bob M
Hi when I try to create a dbase named us_copiosus_USDJPY I get the enclosed error message not sure where to go from here ? <http://apache-database.10148.n7.nabble.com/file/t3208/Derby_-_setting_up_a_dbase.png> Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache

Re: Installing Derby Database

2018-04-07 Thread Bob M
Hi all have sorted the problem :) whew Bob M -- Sent from: http://apache-database.10148.n7.nabble.com/Apache-Derby-Users-f95095.html

Installing Derby Database

2018-04-07 Thread Bob M
Hi Am trying to install the latest version 10.14.1.0 Following instructions - I get to verifying Derby I input the command - java org.apache.derby.tools.sysinfo when I enter this command, there is an extremely brief flash on the screen and that is it ? what am I doing wrong ? Bob M

Re: Updating 2 derby tables error message interpretation

2017-05-26 Thread Bob M
table2 records that my program says have been created? Thank you Bob M New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147442.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

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

Re: Updating 2 derby tables error message interpretation

2017-05-23 Thread Bob M
2 Message: Cannot close a connection while a transaction is still active. Derby finished Label: USDJPY_2352017_6 Currency Pair: USDJPY Closed Trade: USDJPY_2352017_64101 | P/L: -15.5 pips PL_updates = 1.0 Many thanks Bob M New Zealand -- View this message in context: http://apache-database.1014

Re: Updating 2 derby tables

2017-05-22 Thread Bob M
OK John I have reinitialized the data in table1, table 2 remains static. After the program has run for 2 times I should have the usual error about a duplicate key in table2 Exactly what would you wish me to post? Bob M p.s. the 2 tables are independent -- View this message in context

Re: Updating 2 derby tables

2017-05-21 Thread Bob M
tables in the same dbase Regards Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147419.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Updating 2 derby tables

2017-05-21 Thread Bob M
for "adding a new trade record" and found only a single instance - the code is within the /* */ so how can I continue to get a reference to these words in an error code? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147

Re: Updating 2 derby tables

2017-05-20 Thread Bob M
(since a trade was opened and closed on the first run The new trade number is correctly stated as 4101 At this stage the trade table has 4,100 records so why the error message regarding duplicate keys ? I don't get it ! The key is the trade number Bob M -- View this message in context

Re: Updating 2 derby tables

2017-05-20 Thread Bob M
Hi John Understanding a bit more now... I see when I look at the key to table2 it has the identifier 'SQL170412104645890' as stated in the error message -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147410.html Sent

Re: Updating 2 derby tables

2017-05-20 Thread Bob M
to in the error message, you might have to dig around in SYS.SYSCONSTRAINTS to identify it. You are way above my head here :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147409.html Sent from the Apache Derby Users mailing

Re: Updating 2 derby tables

2017-05-20 Thread Bob M
Hi John Trade_no_temp2 is a variable I do not understand why the error message relates this variable to a table? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147408.html Sent from the Apache Derby Users mailing list

Re: Updating 2 derby tables

2017-05-19 Thread Bob M
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

Re: Updating 2 derby tables

2017-05-19 Thread Bob M
Sorry Rick I may have deleted that line :( -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-2-derby-tables-tp147386p147397.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Updating 2 derby tables

2017-05-19 Thread Bob M
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

Re: Updating 2 derby tables

2017-05-18 Thread Bob M
// retrieve and output trade number of latest record from the table TABLE2 rs = s.executeQuery("SELECT * FROM TABLE2 ORDER BY Trading_No DESC FETCH FIRST ROW ONLY"); rs.next(); int trade_no_temp3 = rs.getInt("Trade_No"); fw.writetoFile(("Latest trade record:- Trade Number: "

Re: how to retrieve a number with more dec places

2017-02-28 Thread Bob M
Hi everybody My apologies(very red face) The prices I was saving in my table were only to 3 decimals My bad :( Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/how-to-retrieve-a-number-with-more-dec-places-tp147257p147264.html Sent from

Re: how to retrieve a number with more dec places

2017-02-28 Thread Bob M
the prices with 4 or 5 dec. places Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/how-to-retrieve-a-number-with-more-dec-places-tp147257p147261.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: how to retrieve a number with more dec places

2017-02-28 Thread Bob M
Hi I haven't tried BigDecimal To do that, what do you change the following to.. private double price = 0; Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/how-to-retrieve-a-number-with-more-dec-places-tp147257p147259.html Sent from the Apache

how to retrieve a number with more dec places

2017-02-27 Thread Bob M
Hi I have a derby database with records that contain a price e.g. 1.21098 I retrieve it by the following line price = rs.getDouble("price"); when I print it out I get :- 1.21 What do I need to change so that I retrieve the full price with all its decimal places? Bob M -- View th

Re: Updating several consecutive fields in a record

2016-07-06 Thread Bob M
Thank you Bryan Simple and elegant :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-several-consecutive-fields-in-a-record-tp146385p146387.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Updating several consecutive fields in a record

2016-07-06 Thread Bob M
en consecutive fields in the latest derby record What is the best way to recode the above section of code? Many thanks Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-several-consecutive-fields-in-a-record-tp146385.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Processing a subset of records correctly - again

2016-04-19 Thread Bob M
wrong! I do not know why this is happening - there seems to be no pattern but the answer MUST lie in the fact that I am reading a prediction from one record and comparing that prediction with what actually happened in the very next record Can you see where I may be going wrong ? Thanks Bob M

Processing a subset of records correctly - again

2016-04-16 Thread Bob M
) with actual )from current record) and do some maths I seem to not be getting the predicted value correct? Here is my coding If you can see what could be wrong - let me know :) Bob M * String Date5 = ""; int Time5 = 0; try { rs = s.executeQue

Re: Processing a subset of records correctly

2016-04-05 Thread Bob M
Thank you John I shall try your suggestion Functionality is more important than elegance for me :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Processing-a-subset-of-records-correctly-tp145844p145848.html Sent from the Apache Derby Users

Processing a subset of records correctly

2016-04-05 Thread Bob M
-------- If you could indicate code changes to reverse the handling direction I would be delighted Thank you Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Processing-a-subset-of-records-correctly-tp145844.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: interpreting an error message

2016-02-14 Thread Bob M
Thanks Rick Got it now :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/interpreting-an-error-message-tp145594p145596.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

interpreting an error message

2016-02-14 Thread Bob M
C:/Users/Stan/.netbeans-derby/us_copiosus_USDCAD_S 2016-02-15 02:13:28 Loaded the appropriate driver 2016-02-15 02:13:28 DerbyApp starting in embedded mode to be read upwards :) What does the top line mean ? - it seems to me that it IS connecting to the database ?? Bob M -- View

changing a field contents to

2016-02-06 Thread Bob M
Hi I am using Netbeans to view and correct some data I have in an Apache Derby Database I need to delete the contents of the odd field and replace it with How do I enter the part? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/changing-a-field-contents

Re: getting a subset from a database of records

2015-12-30 Thread Bob M
Thanks Rick oh, so obvious :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/getting-a-subset-from-a-database-of-records-tp145247p145249.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

getting a subset from a database of records

2015-12-30 Thread Bob M
into the request to get that? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/getting-a-subset-from-a-database-of-records-tp145247.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Using a SELECT FROM command correctly

2015-12-07 Thread Bob M
SC OFFSET 1 ROW FETCH NEXT 1 ROW ONLY" where is an integer field which may be Question: How can I retrieve the record with the highest (non ) value Thanks Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Using-a-SELECT-FROM-command-correctl

Using the WHERE clause in a ResultSet

2015-11-03 Thread Bob M
I wish to use the WHERE clause as follows:- Field 1 = current value of variable 1 Field 2 = current value of variable 2 etc. when I use code such as WHERE Field1 = variable1 AND Field2 = variable2 I get an error message saying that variable1 is not in any table in FROM list. How do I

Re: Using the WHERE clause in a ResultSet

2015-11-03 Thread Bob M
I am using the following code:- rs = s.executeQuery("SELECT Field1, Field2, Field3, Field4 FROM XX " + "WHERE Field1 LIKE String1 AND Field2 LIKE String2 AND Field3 LIKE String3 AND Field4 LIKE String4 " + "GROUP BY Field1, Field2, Field3, Field4"); XX - table name Field1 thru

Re: Using the WHERE clause in a ResultSet

2015-11-03 Thread Bob M
string1 thru string4 are VARCHAR variables In my particular case each of the strings can be either"Up" or "Down" but their values vary each time my program runs which is every 6 hours.. Sorry for being a bit slow, but I am still unclear as to how to ask for a subset of the

Re: pulling out a subset of records

2015-10-20 Thread Bob M
ve) (4) the sum of the contents of that field in those records I can code (1) and (3) but how to do (2) & (4) ? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144949.html Sent from the Apache Derby Users mailing li

Re: pulling out a subset of records

2015-10-20 Thread Bob M
Many thanks Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144948.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: pulling out a subset of records

2015-10-20 Thread Bob M
3 = rs.getInt(1); myConsole.getOut().println("Number of records in subset of table USDJPY_S where P/L >= 0: " + recordCount3); Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144953.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: pulling out a subset of records

2015-10-19 Thread Bob M
Hi My exposure to derby so far has only involved creating a database, adding records or deleting a record. I have not extracted a subset which which to further process Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records

pulling out a subset of records

2015-10-19 Thread Bob M
with this code much appreciated Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: pulling out a subset of records

2015-10-19 Thread Bob M
yes- correct Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/pulling-out-a-subset-of-records-tp144942p144946.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Invalid authentication - error message

2015-09-25 Thread Bob M
Many thanks Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Invalid-authentication-error-message-tp144845.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

running simultaneous java programs which access derby datases

2015-08-31 Thread Bob M
is being opened, accessed or closed... Sorry if my explanation is unclear :) Any suggestions welcome Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/running-simultaneous-java-programs-which-access-derby-datases-tp144631.html Sent from

Re: retrieving records based on a single column contents

2015-05-02 Thread Bob M
Thanks John col3 is defined as INT with no contraints but I can't do psInsert.setINT(3, NULL); NULL cannot be resolved to a variable ? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/retrieving-records-based-on-a-single-column-contents-tp143982p143986.html

Re: retrieving records based on a single column contents

2015-05-01 Thread Bob M
Thanks John I wasn't sure how to enter NULL into an integer field and so col3 has many zeroes as well as 1, 2, 3, 4, etc. and so (a) do your suggestions change at all ? (b) how do you enter NULL into an integer field ? (c) how do you set up col3 to be indexed ? Thank you Bob M -- View

retrieving records based on a single column contents

2015-04-30 Thread Bob M
in that column - many records have nothing in that column I am wishing to retrieve the latest two records where that column has a number in it How do I go about that? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/retrieving-records-based-on-a-single-column

Updating a couple of records - errors still!

2015-02-10 Thread Bob M
the last two records * Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-a-couple-of-records-errors-still-tp143778.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

updating a maximum of 2 records

2015-02-08 Thread Bob M
= 999.99); statements.add(psUpdate); psUpdate.setDouble(1, profit); psUpdate.executeUpdate(); } } // end of updating latest record * Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/updating-a-maximum-of-2

Re: Initializing a new record where field is NULL by default

2015-02-01 Thread Bob M
Thank's Bryan for that information... I have sorted it out now The profit field is a dec(5,2) field and so I am using DEFAULT 999.99 Then when I wish to update the latest record with the profit I use a WHERE profit=999.99 All good :) Thanks Bob M -- View this message in context

Re: Inserting and deleting records

2015-01-31 Thread Bob M
(); conn.prepareStatement(UPDATE FROM TABLE SET PROFIT_LOSS = profit WHERE CURRENT OF MYCURSOR).executeUpdate(); myConsole.getOut().println(Updated penultimate record); *** Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com

Re: Inserting and deleting records

2015-01-31 Thread Bob M
, ??); and if so, what do I put in ?? to get the default value there? Bob M p.s. 27 is the field number for profit -- View this message in context: http://apache-database.10148.n7.nabble.com/Inserting-and-deleting-records-tp143723p143731.html Sent from the Apache Derby Users mailing list archive

Initializing a new record where field is NULL by default

2015-01-31 Thread Bob M
Hi When creating a new record, what does one need to code to initialize a field which you wish to have the default value of NULL? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Initializing-a-new-record-where-field-is-NULL-by-default-tp143732.html Sent from

Re: Initializing a new record where field is NULL by default

2015-01-31 Thread Bob M
for the final line referring to Profit and where I wish to set it to NULL initially which is the default Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Initializing-a-new-record-where-field-is-NULL-by-default-tp143732p143735.html Sent from the Apache Derby Users

Re: Inserting and deleting records

2015-01-31 Thread Bob M
last question, if I may. After adding a new record, I should like to set the pointer to the penultimate latest record ordered by DATE and Time so that I can update the Profit field Exactly what code do I need to do that, please Bob M -- View this message in context: http://apache

Inserting and deleting records

2015-01-30 Thread Bob M
(); conn.prepareStatement(DELETE FROM TABLE WHERE CURRENT OF MYCURSOR).executeUpdate(); // commit the above transactions conn.commit(); } // end of adding new record and deleting oldest one Bob M -- View this message in context: http://apache

Re: Updating the last column in the newest record

2015-01-29 Thread Bob M
Hi I now have the following code but NO update takes place??? psUpdate = conn.prepareStatement(update TABLE SET PROFIT_LOSS=? WHERE PROFIT_LOSS=?); Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-the-last-column-in-the-newest-record

Re: Updating the last column in the newest record

2015-01-29 Thread Bob M
Thank's John... I now realise that when I create a new record I enter 0.00 into the profit/loss field I guess I should leave that field out when writing a new record and then try your suggested code to update that 'blank' field Bob M -- View this message in context

Re: Updating the last column in the newest record

2015-01-29 Thread Bob M
So.. Does the following code seem OK? // Update Profit/Loss field psUpdate = conn.prepareStatement(update TABLE SET PROFIT_LOSS=profit WHERE (TRADING_DATE + TRADING_TIME) = (SELECT MAX(TRADING_DATE + TRADING_TIME) from TABLE)); statements.add(psUpdate);

Re: Updating the last column in the newest record

2015-01-29 Thread Bob M
/inserting ONLY 26 field values leaving 27th field {Profit/Loss} out 2) later, update latest record - just updating the profit/loss field using modified code UPDATE TABLE SET PROFIT_LOSS=9000 WHERE DUE_DATE = (SELECT MAX(due_date) from TABLE) Bob M -- View this message in context: http://apache

Re: Updating the last column in the newest record

2015-01-29 Thread Bob M
and is not in the GROUP BY list. If this is a CREATE or ALTER statement then 'PROFIT is not in the TABLE profit is a double variable? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-the-last-column-in-the-newest-record-tp143710p143720.html Sent from

Updating the last column in the newest record

2015-01-28 Thread Bob M
= conn.prepareStatement(update TABLE SET PROFIT_LOSS=?); statements.add(psUpdate); psUpdate.setDouble(1, profit); psUpdate.executeUpdate(); // commit the above transactions conn.commit(); // end updating Profit Thanks for any advice Bob

Re: Storing an RSS feed news headlines in Derby

2014-10-30 Thread Bob M
Thank you Bryan That's exactly what I need to get started. Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Storing-an-RSS-feed-news-headlines-in-Derby-tp143097p143101.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Storing an RSS feed news headlines in Derby

2014-10-29 Thread Bob M
Hi Very new to RSS feeds :) I wish to store title and pubDate for each headline news item on a RSS feed in a Derby database Would appreciate some pointers as to how to achieve this Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Storing-an-RSS-feed-news

Multiple open/close of a derby database

2014-09-25 Thread Bob M
coding? Bob M Dunedin New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Multiple-open-close-of-a-derby-database-tp142454.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Another error to be explained

2014-09-22 Thread Bob M
):java.io.FileNotFoundException'. What does this error mean? Bob M Dunedin New Zealand -- View this message in context: http://apache-database.10148.n7.nabble.com/Another-error-to-be-explained-tp142334.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Derby Error message - explanation required

2014-09-22 Thread Bob M
Hi Knut Thanks for your help With respect to my latest error (see new post) I have just spotted a derby.log file in my Derby Database folder but I am unable to open it - Access is denied. I will try your pieces of code when I get some traction again :) Bob M Dunedin New Zealand

Re: Another error to be explained

2014-09-22 Thread Bob M
Hi Peter Permission or attributes - maybe. Could you spell out how I check these? What puzzles me is that I did have my application working at an earlier stage and I am having difficulty understanding why I am now getting a series of error messages Bob M -- View this message

Re: Another error to be explained

2014-09-22 Thread Bob M
. completely blank Sub-folder seg0:- similar to the above except the 'ticks' are gray - not solid black as above ?? sub-file c510.dat only Admin listed - not me Admin - all permissions ticked in black...OK I note that this file is 996KB - which is large c.f. many others which are 8KB Bob M

Re: Derby Error message - explanation required

2014-09-19 Thread Bob M
(password, ); String dbName = C:/Program Files/Derby Database/us_copiosus; // the name of the database conn = DriverManager.getConnection(protocol + dbName, props); *** Many thanks Bob M Dunedin, New Zealand -- View this message in context: http

Re: Derby Error message - explanation required

2014-09-18 Thread Bob M
Hi Knut Thanks for the advice.. My derby version is 10.11.1.1 though :) I shall come back after a trial run this evening In the meantime, a question Why is my derby.log to be found in C:\Downloads ? Bob M -- View this message in context: http://apache-database.10148.n7

Re: Derby Error message - explanation required

2014-09-18 Thread Bob M
Hi Rick and Knut Many thanks for your time and assistance :) By deleting the empty .tmp file we are in business again Should I add any code to stop this happening in the future? Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Derby-Error

Re: Derby Error message - explanation required

2014-09-17 Thread Bob M
Hi Rick Please explain in greater detail what I need to do... At the moment I am simply running my java application on Dukascopy's Forex Platform I do not know where or how to implement what you require Sorry :( Bob M -- View this message in context: http://apache

Re: Derby Error message - explanation required

2014-09-17 Thread Bob M
Hi Rick derby.log http://apache-database.10148.n7.nabble.com/file/n142209/derby.log attempting to upload derby.log Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Derby-Error-message-explanation-required-tp142183p142209.html Sent from the Apache Derby

Re: Derby Error message - explanation required

2014-09-17 Thread Bob M
Hi Dyre Dukascopy is a Swiss Forex (foreign exchange) Broker The platform I use is a java platform where I can place orders on the Swiss Forex Market I do not know about a 'bug' As I said earlier, I had this all working prior to a laptop meltdown :( Bob M -- View this message in context

  1   2   >