• 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

Error message with Apache Derby database connection

 
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
Bartender
Posts: 556
10
IntelliJ IDE Spring Fedora
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
It says there is a more detailed error message.  Did you look at that?
 
Rancher
Posts: 4801
50
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
Rancher
Posts: 594
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
 
You showed up just in time for the waffles! And this tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
reply
    Bookmark Topic Watch Topic
  • New Topic