Jaikoz Startup-Problem: No suitable driver found for jdbc:derby ...

[jore]

Jaikoz 7.1.1
Mac OS X 10.9.4

Hi,

I can’t start Jaikoz on OS X Mavericks.
I get an startup-error message (in German language, my OS language) (screenshot attached): Database error, jaikozdb cannot be created

This error appears also in Jaikoz 6 versions, but NOT in Jaikoz 5.

When starting Jaikoz 7 from command line in debug mode, I get the following output:

02/09/2014 13.17.02:com.jthink.jaikoz.MainWindow:setupOnFirstTime:SCHWERWIEGEND: osLanguage5:null
02/09/2014 13.17.02:com.jthink.jaikoz.MainWindow:setupOnFirstTime:SCHWERWIEGEND: osLanguage6:de
02/09/2014 13.17.03:com.jthink.jaikoz.MainWindow:setLocale:SCHWERWIEGEND: Setting Locale:de
02/09/2014 13.17.03:com.jthink.acoustid.query.AbstractAcoustidQuery:performBasicSubmissionQuery:SCHWERWIEGEND: Posting to url:http://api.acoustid.org/v2//user/lookup?format=xml&client=8XaBELgH&user=1RwD5L1X
02/09/2014 13.17.06:com.jthink.jaikoz.db.Db:printSQLException:SCHWERWIEGEND: Err:Connections could not be acquired from the underlying database!:ErrCode:0:State:null
java.sql.SQLException: Connections could not be acquired from the underlying database!
\tat com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
\tat com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:529)
\tat com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
\tat com.jthink.jaikoz.db.Db.createConnection(Db.java:337)
\tat com.jthink.jaikoz.db.Db.(Db.java:85)
\tat com.jthink.jaikoz.db.Db.getInstance(Db.java:115)
\tat com.jthink.jaikoz.MainWindow.setupFirstTimeOrUpgrade(MainWindow.java:462)
\tat com.jthink.jaikoz.MainWindow.setupWindow(MainWindow.java:295)
\tat com.jthink.jaikoz.Jaikoz.main(Jaikoz.java:114)
Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
\tat com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1319)
\tat com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:557)
\tat com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
\tat com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
\t… 7 more
Creating a New Database:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb
Exception with creating New Database:No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true
java.sql.SQLException: No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true
\tat java.sql.DriverManager.getConnection(DriverManager.java:596)
\tat java.sql.DriverManager.getConnection(DriverManager.java:187)
\tat com.jthink.jaikoz.db.Db.createNewDatabase(Db.java:260)
\tat com.jthink.jaikoz.db.Db.(Db.java:95)
\tat com.jthink.jaikoz.db.Db.getInstance(Db.java:115)
\tat com.jthink.jaikoz.MainWindow.setupFirstTimeOrUpgrade(MainWindow.java:462)
\tat com.jthink.jaikoz.MainWindow.setupWindow(MainWindow.java:295)
\tat com.jthink.jaikoz.Jaikoz.main(Jaikoz.java:114)
02/09/2014 13.17.06:com.jthink.jaikoz.db.Db:printSQLException:SCHWERWIEGEND: Err:No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true:ErrCode:0:State:08001
02/09/2014 13.17.06:com.jthink.jaikoz.MainWindow:setupWindow:SCHWERWIEGEND: Datenbank /Users/jomb/Library/Preferences/Jaikoz/jaikozdb kann nicht erstellt werden, weil No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true
java.lang.RuntimeException: Datenbank /Users/jomb/Library/Preferences/Jaikoz/jaikozdb kann nicht erstellt werden, weil No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true
\tat com.jthink.jaikoz.db.Db.createNewDatabase(Db.java:324)
\tat com.jthink.jaikoz.db.Db.(Db.java:95)
\tat com.jthink.jaikoz.db.Db.getInstance(Db.java:115)
\tat com.jthink.jaikoz.MainWindow.setupFirstTimeOrUpgrade(MainWindow.java:462)
\tat com.jthink.jaikoz.MainWindow.setupWindow(MainWindow.java:295)
\tat com.jthink.jaikoz.Jaikoz.main(Jaikoz.java:114)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true
\tat java.sql.DriverManager.getConnection(DriverManager.java:596)
\tat java.sql.DriverManager.getConnection(DriverManager.java:187)
\tat com.jthink.jaikoz.db.Db.createNewDatabase(Db.java:260)
\t… 5 more
java.lang.RuntimeException: Datenbank /Users/jomb/Library/Preferences/Jaikoz/jaikozdb kann nicht erstellt werden, weil No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true
\tat com.jthink.jaikoz.db.Db.createNewDatabase(Db.java:324)
\tat com.jthink.jaikoz.db.Db.(Db.java:95)
\tat com.jthink.jaikoz.db.Db.getInstance(Db.java:115)
\tat com.jthink.jaikoz.MainWindow.setupFirstTimeOrUpgrade(MainWindow.java:462)
\tat com.jthink.jaikoz.MainWindow.setupWindow(MainWindow.java:295)
\tat com.jthink.jaikoz.Jaikoz.main(Jaikoz.java:114)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:derby:/Users/jomb/Library/Preferences/Jaikoz/jaikozdb;create=true
\tat java.sql.DriverManager.getConnection(DriverManager.java:596)
\tat java.sql.DriverManager.getConnection(DriverManager.java:187)
\tat com.jthink.jaikoz.db.Db.createNewDatabase(Db.java:260)
\t… 5 more

---

my Java Version:

java -version
java version “1.7.0_67”
Java™ SE Runtime Environment (build 1.7.0_67-b01)
Java HotSpot™ 64-Bit Server VM (build 24.65-b04, mixed mode)

What can I do?

Regards, Joachim Rensing

[jore]

I upgraded java to version 8.

The problem persists!

java -version
java version “1.8.0_20”
Java™ SE Runtime Environment (build 1.8.0_20-b26)
Java HotSpot™ 64-Bit Server VM (build 25.20-b23, mixed mode)

[paultaylor]

Jaikoz is bundled with its own version of Java anyway, but this is very curious. Is there anything unusual about your machine because currently Im stumped.

[jore]

It’s a standard Mavericks installation on a Mac mini. (a second installation on another Mac gives the same error).

One thing was noticeable for me: when starting Jaikoz from the command line, I couldn’t execute jaikoz.sh

I did:

cd /Applications/Jaikoz.app/Contents/Java
./jaikoz.sh

I got: -bash: ./jaikoz.sh: Permission denied

So I executed the code inside jaikoz.sh directly:
java -Xms150m -Xmx800m -Xdock:name=“Jaikoz” -Dapple.laf.useScreenMenuBar=true -Dapple.awt.brushMetalLook=false -jar jaikoz.jar -l2 -m2 -f

and then got the error message, I reported

when listing /Applications/Jaikoz.app/Contents/Java, I get:

total 65024
-rw-r–r--@ 1 jomb admin 7,8K 1 Sep 22:03 AppleScriptEngine.jar
-rw-r–r--@ 1 jomb admin 262K 1 Sep 22:03 Filters.jar
drwxr-xr-x@ 61 jomb admin 2,0K 1 Sep 22:03 Help
-rw-r–r--@ 1 jomb admin 429K 1 Sep 22:03 MultipleGradientPaint.jar
-rw-r–r--@ 1 jomb admin 81K 1 Sep 22:03 SuperCSV-1.52.jar
-rw-r–r--@ 1 jomb admin 3,5K 1 Sep 22:03 acknowledgement.html
-rw-r–r--@ 1 jomb admin 58K 1 Sep 22:03 acoustid-1.0.jar
-rw-r–r--@ 1 jomb admin 54K 1 Sep 22:03 activation.jar
-rw-r–r--@ 1 jomb admin 596K 1 Sep 22:03 c3p0-0.9.1.2.jar
-rw-r–r--@ 1 jomb admin 57K 1 Sep 22:03 commons-codec.jar
-rw-r–r--@ 1 jomb admin 240K 1 Sep 22:03 commons-lang-2.3.jar
-rw-r–r--@ 1 jomb admin 59K 1 Sep 22:03 commons-logging.jar
-rw-r–r--@ 1 jomb admin 707B 1 Sep 22:03 create_itunes_model.scpt
-rw-r–r--@ 1 jomb admin 2,5M 1 Sep 22:03 derby.jar
-rw-r–r--@ 1 jomb admin 103K 1 Sep 22:03 forms-1.2.1.jar
-rw-r–r--@ 1 jomb admin 381B 1 Sep 22:03 get_playlist_folder.scpt
-rw-r–r--@ 1 jomb admin 1,8M 1 Sep 22:03 guava.jar
-rw-r–r--@ 1 jomb admin 343K 1 Sep 22:03 httpclient.jar
-rw-r–r--@ 1 jomb admin 177K 1 Sep 22:03 httpcore.jar
-rw-r–r--@ 1 jomb admin 205K 1 Sep 22:03 index.jar
-rw-r–r--@ 1 jomb admin 1,9K 1 Sep 22:03 itunes_dragdrop.scpt
-rw-r–r--@ 1 jomb admin 2,0K 1 Sep 22:03 itunes_dragplaylist.scpt
-rw-r–r--@ 1 jomb admin 1,3K 1 Sep 22:03 itunes_getplaylist.scpt
-rw-r–r--@ 1 jomb admin 252K 1 Sep 22:03 jai_codec.jar
-rw-r–r--@ 1 jomb admin 1,8M 1 Sep 22:03 jai_core.jar
-rw-r–r--@ 1 jomb admin 5,4M 1 Sep 22:03 jaikoz.jar
-rw-r–r--@ 1 jomb admin 83K 1 Sep 22:03 jaikoz.properties
-rw-r–r--@ 1 jomb admin 139B 1 Sep 22:03 jaikoz.sh
-rw-r–r--@ 1 jomb admin 85K 1 Sep 22:03 jaikoz_da.properties
-rw-r–r--@ 1 jomb admin 94K 1 Sep 22:03 jaikoz_de.properties
-rw-r–r--@ 1 jomb admin 310K 1 Sep 22:03 jaikoz_el.properties
-rw-r–r--@ 1 jomb admin 82K 1 Sep 22:03 jaikoz_en.properties
-rw-r–r--@ 1 jomb admin 97K 1 Sep 22:03 jaikoz_es.properties
-rw-r–r--@ 1 jomb admin 102K 1 Sep 22:03 jaikoz_fr.properties
-rw-r–r--@ 1 jomb admin 251K 1 Sep 22:03 jaikoz_hi.properties
-rw-r–r--@ 1 jomb admin 89K 1 Sep 22:03 jaikoz_it.properties
-rw-r–r--@ 1 jomb admin 171K 1 Sep 22:03 jaikoz_ja.properties
-rw-r–r--@ 1 jomb admin 140K 1 Sep 22:03 jaikoz_ko.properties
-rw-r–r--@ 1 jomb admin 88K 1 Sep 22:03 jaikoz_nl.properties
-rw-r–r--@ 1 jomb admin 84K 1 Sep 22:03 jaikoz_no.properties
-rw-r–r--@ 1 jomb admin 96K 1 Sep 22:03 jaikoz_pl.properties
-rw-r–r--@ 1 jomb admin 94K 1 Sep 22:03 jaikoz_pt.properties
-rw-r–r--@ 1 jomb admin 89K 1 Sep 22:03 jaikoz_sv.properties
-rw-r–r--@ 1 jomb admin 257K 1 Sep 22:03 jaikoz_th.properties
-rw-r–r--@ 1 jomb admin 109K 1 Sep 22:03 jaikoz_tr.properties
-rw-r–r--@ 1 jomb admin 917K 1 Sep 22:03 jaudiotagger.jar
-rw-r–r--@ 1 jomb admin 102K 1 Sep 22:03 jaxb-api.jar
-rw-r–r--@ 1 jomb admin 848K 1 Sep 22:03 jaxb-impl.jar
-rw-r–r--@ 1 jomb admin 26K 1 Sep 22:03 jgoodies-common.jar
-rw-r–r--@ 1 jomb admin 576K 1 Sep 22:03 jhall.jar
-rw-r–r--@ 1 jomb admin 112K 1 Sep 22:03 jl1.0.jar
-rw-r–r--@ 1 jomb admin 124K 1 Sep 22:03 jmock-1.1.0RC1.jar
-rw-r–r--@ 1 jomb admin 1,1M 1 Sep 22:03 js.jar
-rw-r–r--@ 1 jomb admin 45K 1 Sep 22:03 jsr173_1.0_api.jar
-rw-r–r--@ 1 jomb admin 16K 1 Sep 22:03 jthinksearch-client-1.0.jar
-rw-r–r--@ 1 jomb admin 297B 1 Sep 22:03 layout.properties
-rw-r–r--@ 1 jomb admin 7,0K 1 Sep 22:03 license.txt
-rw-r–r--@ 1 jomb admin 385K 1 Sep 22:03 looks.jar
-rw-r–r--@ 1 jomb admin 1,5M 1 Sep 22:03 lucene-analyzers-common.jar
-rw-r–r--@ 1 jomb admin 2,1M 1 Sep 22:03 lucene-core.jar
-rw-r–r--@ 1 jomb admin 377K 1 Sep 22:03 lucene-queryparser.jar
-rw-r–r--@ 1 jomb admin 331K 1 Sep 22:03 mac_widgets.jar
-rw-r–r--@ 1 jomb admin 106K 1 Sep 22:03 mb.jar
-rw-r–r--@ 1 jomb admin 82K 1 Sep 22:03 mmd2-2.0.0.jar
-rw-r–r--@ 1 jomb admin 1,5M 1 Sep 22:03 poi-3.5-beta5-20090219.jar
-rw-r–r--@ 1 jomb admin 1,9M 1 Sep 22:03 quaqua.jar
-rw-r–r--@ 1 jomb admin 40K 1 Sep 22:03 settings.jai
-rw-r–r--@ 1 jomb admin 75K 1 Sep 22:03 settings.xsd
-rw-r–r--@ 1 jomb admin 40K 1 Sep 22:03 settingsdefaults.jai
-rw-r–r--@ 1 jomb admin 44K 1 Sep 22:03 splash.png
-rw-r–r--@ 1 jomb admin 119K 1 Sep 22:03 spring-core-1.2.8.jar
-rw-r–r--@ 1 jomb admin 724K 1 Sep 22:03 spring-richclient.jar
-rw-r–r--@ 1 jomb admin 155K 1 Sep 22:03 swing-layout.jar
-rw-r–r--@ 1 jomb admin 13K 1 Sep 22:03 swing-worker.jar
-rw-r–r--@ 1 jomb admin 1,2M 1 Sep 22:03 swingx.jar
-rw-r–r--@ 1 jomb admin 370K 1 Sep 22:03 twelvemonkeys-core-2.2.jar
-rw-r–r--@ 1 jomb admin 28K 1 Sep 22:03 twelvemonkeys-imageio-core-2.2.jar
-rw-r–r--@ 1 jomb admin 63K 1 Sep 22:03 twelvemonkeys-imageio-pict-2.2.jar
-rw-r–r--@ 1 jomb admin 938B 1 Sep 22:03 upgrade.txt

You can see, jaikoz.sh is not executable.

Could this be the reason?

I can chmod the files as you like, to test. Tell me how.

Regards, Joachim

[paultaylor]

Have you actually tried running Jaikoz normally by just double-clicking within Applications folder in Finder ?

[jore]

Sure, I did this first after installation.

Then came the error-Popup from Jaikoz, what started my research for a solution (also in this forum, where I saw the hint, to start from command line)