• 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

Error message with Apache Derby database connection

 
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Master Rancher
Posts: 451
6
IntelliJ IDE Spring Fedora
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It says there is a more detailed error message.  Did you look at that?
 
Rancher
Posts: 4116
47
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 259
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!