Hi Rick and others
Have moved on slightly but still cannot get the Derby example java program
to fire
The messages I get are as follows:-
2013-09-27 03:48:15 DerbyApp finished
2013-09-27 03:48:15 Message: No suitable driver found for
appreciated
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/explanation-of-errors-please-tp134695.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
);
where fields are VARCHR(10), INT, INT, VARCHAR(9), INT, VARCHAR(8),
etc..
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/explanation-of-errors-please-tp134695p134703.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
Hello Dyre
Many thanks for your suggestions...
The primary key consists of the first two columns being Date and Hours e.g.
01-01-2009, 0
01-01-2009, 6
01-01-2009, 12
01-01-2009, 18
02-01-2009, 0 etc.
Does this lead to alternative suggestions?
Bob M
--
View this message
Hi Bryan
so..
rs. = s.executeQuery(SELECT COUNT(*) FROM Table_name);
rs.next();
int recordCount = rs.getInt();
I get compilation error on last line
The method getInt(int) in the type ResultSet in not applicable for the
arguments ()
Bob M
--
View this message in context:
http
/Time + Date , + Time);
Now I wish to delete this record and the code is..
rs = s.executeQuery(DELETE from tablename WHERE );
What is the ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Retrieving-the-oldest-record-and-deleting-it-tp134915
Thanks Rick
Keeping the code 'in sync' is difficult when applying example code :)
Will the following do what I am seeking?
rs = s.executeQuery(SELECT from tablename ORDER BY Date ASC, Time, ASC
FETCH FIRST ROW ONLY);
rs.next();
String Date = rs.getString(Date);
String Date =
Hi there
The error is that my SELECT can not have For UPDATE
My current code is
***
// retrieve and output date and time of oldest record from the table
rs = s.executeQuery(SELECT * FROM tablename ORDER BY Date ASC, Time ASC
FETCH FIRST ROW ONLY);
rs.next();
String
Hi
With the following codeI have a problem when trying to delete the
'oldest' record
The SELECT query retrieves the correct record as shown by the output but I
can not
delete this record without a FOR UPDATE at the end of the SELECT query and
apparently
my current SELECT query type CAN
-
2013-10-23 17:30:55 Date/Time: 01-01-2010, 0
Can somebody throw some light on what the problem might be ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/seeking-explanation-of-SQLException-error-message-tp135002.html
Sent from the Apache Derby Users
Hi Tim
Thanks for the info - spot on!
Yes - trying to work slowly thru tutorials :)
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/seeking-explanation-of-SQLException-error-message-tp135002p135015.html
Sent from the Apache Derby Users mailing list archive
();
myConsole.getOut().println(Deleted oldest record);
***
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Commiting-several-operations-tp135841.html
Sent from the Apache Derby Users mailing list archive
My question is...
What code do I need to add to the above so that the table is updated with
the various operations I am performing ?
when I run this code on back-test - the table's contents (records) do NOT
change ?
Bob M
--
View this message in context:
http
1 Jan 2010 / 0
1 Jan 2010 / 6
1 Jan 2010 / 12 etc etc.
Any ideas on where my code is incorrect ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Commiting-several-operations-tp135841p135844.html
Sent from the Apache Derby Users mailing list archive
etc etc.
Any ideas on where my code is incorrect ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Problem-retrieving-the-oldest-record-tp135855.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
, the record is NOT being updated as I am wishing it to be ?
Any ideas ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Problem-updating-a-record-tp135856.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
in a primary key!
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Problem-retrieving-the-oldest-record-tp135855p135863.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
my original question...
Why does my code not pick up the true 'oldest' record
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Problem-retrieving-the-oldest-record-tp135855p135869.html
Sent from the Apache Derby Users mailing list archive
It would help if you could show me the additional code I need to accomplish
my task
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Problem-updating-a-record-tp135856p135870.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
= conn.prepareStatement(Update USD_JPY SET Return_predicted=?,
Class_predicted=? where Date= +Date1 +and Time= + Time1)
A final question
If one was inserting a new record using psInsert what code do you use to
execute the Insert?
Bob M
--
View this message in context:
http://apache
as
31-12-2010, 18
The code shows the 'oldest' record as 01-01-2010, 0 and the next one as
01-01-2010, 6
Any suggestions welcome
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Problems-still-in-retrieving-oldest-record-and-newest-record
Hi
I have a derby database with one table which I access using Netbeans
What is an easist way for me to export the contents of the table ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/Exporting-table-records-tp136465.html
Sent from the Apache Derby Users
100 records?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/accessing-records-problem-tp136964.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
After the rs = s.executeQuery line I try to print out a message
This message does not get printed out!
OK so if s= null is incorrect, then what should I set s to ?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/accessing-records-problem-tp136964p136969.html
yes - it should be while k 100
what value does k get to?
I am not sure but I do not seem to be able to retrieve the 100 records
correctly
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/accessing-records-problem-tp136964p136970.html
Sent from the Apache
Hi
I have a table in which the key is the first two fields viz date and time
the last two records in the table are
2014-02-14 0 ...
2014-02-14 6 ..
When I try to add a new record
2014-02-14 12
I get Error
Hello John
Table Specs:-
//s.execute(CREATE TABLE xxx_xxx(Trading_Date DATE NOT NULL, Trading_Time
INT NOT NULL,
//+ Open_price DECIMAL(6,3), High_price DECIMAL(6,3),
//+ Low_price DECIMAL(6,3), Close_price DECIMAL(6,3),
//+ DOW_numeric INT, DOW_nominal VARCHAR(9), Hour_numeric INT,
//+
connect to the database
view data
and attempt to add a new record with a new key which is NOT a duplicate
all the other fields are straight forward
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/adding-a-record-to-a-table-tp137120p137136.html
Sent from
Hi guys (John and Rick)
Thank you for your considerations (even though they are a bit above my level
of comprehension)
I have added a constraint a follows:-
CONSTRAINT tablekey_pk PRIMARY KEY(Trading Date, Trading_Time)
however, lets step back a bitafter reading your suggested
, after a tweek in the code, my newest records are being written at the
beginning of the table next to the oldest records ?
What code do I need to add, so that when any new record is added, it will
appear at the end of the table and not at the beginning ?
Thanks
Bob M
--
View this message
can somebody interpret what the problem is ?
Do I need to add further debugging code ?
I do not understand 'the time requested' can I alter this?
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/SQL-State-40XL1-tp138053.html
Sent from the Apache Derby Users
as suggested and
see if I can nail down the problem
Thanks again
Bob M
--
View this message in context:
http://apache-database.10148.n7.nabble.com/SQL-State-40XL1-tp138053p138118.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.
.greed.agent.compiler.c@2245f804, see the next exception
for details
- SQL Exception --
SQL State: XJ001
Error Code: 0
Message: Java exception:':java.lang.NullPointerException'.
Can anybody suggest what I have wrong in simple English :)
Thanks
Bob M
--
View this message in context
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
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
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
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
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
(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
):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.
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
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
. 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
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.
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
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.
= 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
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
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
();
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
();
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
, ??);
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
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
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
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
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
= 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
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.
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);
/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
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
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
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
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
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
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
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
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
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
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.
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.
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.
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.
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
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.
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
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.
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.
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
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
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.
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
--------
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.
) 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
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
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.
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.
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
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
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.
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
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
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.
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
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.
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
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
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
(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
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
1 - 100 of 133 matches
Mail list logo