Error message with Apache Derby database connection

[Bob Matthews]

After running a java program which tries to connect to an Apache Derby database (seemingly unsuccessfully)
I get the following Error when using Netbeans IDE to connect to the database

Unable to connect. Cannot establish a connection to jdbc.derby://localhost:1527/xxxxx using org.apache.derby.jdbc.ClientDriver
(DERBY SQL error: ERRORCODE:40000,
SQLSTATE: XJ040,
SQLERRMC:Failed to start database 'xxxxx' with class loader sun.misc.Launcher$AppClassLoader@266474c2, see the next exception for details.
:: SQLSTATE:XSDBC).

Please can somebody explain what this error is exactly ?

Bob M

[Al Hobbs]

It says there is a more detailed error message.  Did you look at that?

[Dave Tolls]

Can you find your derby.log file (it'll be wherever your derby system directory is located) and see what errors it's got in it?

[Bob Matthews]

Having trouble locating this file

Done a search on C:\ but nothing shows ???

Looked in folder where derby is installed - can't see ?

Bob M

[Bob Matthews]

OK

did  search of just "derby" and came up with lots of files

I shall wait until the next instance of this error and then look at the derby log file with the same date and time

Bob M

[Bob Matthews]

Hi

Five strategies (java programs) running simultaneously

3 of them - running as expected

2 of them - GBPCHF and USDJPY both show "no driver " error

Here is the log file

----------------------------------------------------------------
Fri Jul 12 00:00:02 UTC 2019:
Booting Derby version The Apache Software Foundation - Apache Derby - 10.11.1.1 - (1616546): instance a816c00e-016b-e37a-c68c-000009500118
on database directory C:\Users\64210\Desktop\2019 Trading\Databases\us_copiosus_NZDUSD_1010 with class loader com.dukascopy.dds2.greed.agent.a.c@651fbc34
Loaded from http://www.dukascopy.com/JFOREX
java.vendor=Oracle Corporation
java.runtime.version=1.8.0_152-b16
user.dir=C:\Users\64210\JForex
os.name=Windows 10
os.arch=amd64
os.version=10.0
derby.system.home=null
Database Class Loader started - derby.database.classpath=''
----------------------------------------------------------------
Fri Jul 12 00:00:08 UTC 2019: Shutting down Derby engine
----------------------------------------------------------------
Fri Jul 12 00:00:08 UTC 2019:
Shutting down instance a816c00e-016b-e37a-c4d7-00000b206fe8 on database directory C:\Users\64210\Desktop\2019 Trading\Databases\us_copiosus_EURCAD_1010 with class loader com.dukascopy.dds2.greed.agent.a.c@31499e31
----------------------------------------------------------------

Am really confused between the two programs which show "no driver" error and the 2 different databases mentioned in the log file ???

Ah.... so I have 5 instances of Derby engine
Bob M