• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Jeanne Boyarsky
  • Devaka Cooray
  • Paul Clapham
Sheriffs:
  • Tim Cooke
  • Knute Snortum
  • Bear Bibeault
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Piet Souris
  • Ganesh Patekar
Bartenders:
  • Frits Walraven
  • Carey Brown
  • Tim Holloway

how to register an error ?

 
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

Output as expected:-
File Name: C:/Dukascopylog/USD_JPY 2019_7_10_2.txt
DOW: 4, Hour: 2
date_current: 2019-7-10; time_current: 2
Open_price: 108.901
High_price: 108.933
Low_price: 108.883
Close_price: 108.899
DerbyApp starting in embedded mode
Loaded the appropriate driver
Connected to database C:/Users/aaaa/us_copiosus_USDJPY_1525
Number of records in table HOURLY_HISTORY: 21922
Number of records in table PROTOTYPES: 3823
***********************************************************
Output - not as expected
File Name: C:/Dukascopylog/GBP_CHF 2019_7_10_2.txt
DOW: 4, Hour: 2
date_current: 2019-7-10; time_current: 2
Open_price: 1.23774
High_price: 1.23786
Low_price: 1.23721
Close_price: 1.23721
DerbyApp starting in embedded mode
Loaded the appropriate driver
**********************************************************


The above code is used to connect to an Apache derby database

In the first output above, all is well
But in the second example - output is halted with no line saying "Connected to database................

BUT I don't get any error messages ???

How do I find out what is going wrong ?

Bob M
 
Rancher
Posts: 4116
47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
That output does not match the logging lines in the code.
In the code you have two lines that output "DerbyApp starting in...", both of which have to come out if the loadDriver call works (and it has in both).

That they haven't come out in either runs indicates that the code provided is not hte cod that was executed to produce that output.
 
Bob Matthews
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Apologies...............

I had deleted the second occurrance of the same line

Bob M
 
Marshal
Posts: 64654
225
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Bob Matthews wrote: . . . I had deleted the second occurrance of the same line . . .

Please don't; editing posts after a response can make the reponse look like nonsense. I shall reinstate the missing line.
 
Bob Matthews
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
as a further confusing issue..............

After a reboot, the output may come right again

It may last for 1 or 2 or 3 hours (the program activates on the hour) but then we go back to restricted output again

Bob M
 
Dave Tolls
Rancher
Posts: 4116
47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So can you post the actual code, and the output?
As a new post (don't edit the first post).

That way we can see exactly where it thinks it is going wrong.
As it stands I cannot tell what is happening at all.

Also, can you include in that the whole of the try/catch/finally block, not just the first bit of the try part?
 
Bob Matthews
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Example of output - good !
File Name: C:/Dukascopylog/USD_JPY 2019_7_10_2.txt
DOW: 4, Hour: 2
date_current: 2019-7-10; time_current: 2
Open_price: 108.901
High_price: 108.933
Low_price: 108.883
Close_price: 108.899
DerbyApp starting in embedded mode
Loaded the appropriate driver
Connected to database C:/Users/zzzzUSDJPY.....
Number of records in table HOURLY_HISTORY: 220
Number of records in table PROTOTYPES: 38
then follows evidence of calculations being done and database records being updated

Example of output - not good !
File Name: C:/Dukascopylog/GBP_CHF 2019_7_10_2.txt
DOW: 4, Hour: 2
date_current: 2019-7-10; time_current: 2
Open_price: 1.23774
High_price: 1.23786
Low_price: 1.23721
Close_price: 1.23721
DerbyApp starting in embedded mode
Loaded the appropriate driver

Bob M
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!