• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Rob Spoor
  • Tim Cooke
  • Junilu Lacar
Sheriffs:
  • Henry Wong
  • Liutauras Vilda
  • Jeanne Boyarsky
Saloon Keepers:
  • Jesse Silverman
  • Tim Holloway
  • Stephan van Hulst
  • Tim Moores
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Mikalai Zaikin
  • Piet Souris

how to register an error ?

 
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 4801
50
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Apologies...............

I had deleted the second occurrance of the same line

Bob M
 
Marshal
Posts: 74025
332
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 4801
50
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Whoever got anywhere by being normal? Just ask this exceptional tiny ad:
Thread Boost feature
https://coderanch.com/t/674455/Thread-Boost-feature
reply
    Bookmark Topic Watch Topic
  • New Topic