[SOLVED] No suitable driver for jdbc:derby:db

See the SOLUTION to this problem in the second reply.

In a Mac OS X 10.8.2 system up to date, freshly booted and with Apple's Java 6 JDK installed plus Oracle's Java 7 plugin for web browsers:

  Code:

$ java -version
java version "1.6.0_37"
Java(TM) SE Runtime Environment (build 1.6.0_37-b06-434-11M3909)
Java HotSpot(TM) 64-Bit Server VM (build 20.12-b01-434, mixed mode)

I'm getting An unexpected error that kills the server with a NullPointerException a few seconds after every time I try to start the Serviio 1.1 server.

I can see the following in the DEBUG log:

  Code:

2013-01-20 21:28:39,602 DEBUG [ApplicationInstanceManager] Listening for application instances on socket 44331
2013-01-20 21:28:39,607 INFO  [MediaServer] ------------------------------------------------------------------------
2013-01-20 21:28:39,607 INFO  [MediaServer] Serviio DLNA media streaming server v 1.1 (rev. 6ba0dd933a8e+)
2013-01-20 21:28:39,608 INFO  [MediaServer] Petr Nejedly 2009-2012
2013-01-20 21:28:39,608 INFO  [MediaServer] http://www.serviio.org
2013-01-20 21:28:39,608 INFO  [MediaServer]
2013-01-20 21:28:39,608 INFO  [MediaServer] Java 1.6.0_37-Apple Inc.
2013-01-20 21:28:39,608 INFO  [MediaServer] OS Mac OS X x86_64 10.8.2
2013-01-20 21:28:39,608 INFO  [MediaServer] File encoding: UTF-8
2013-01-20 21:28:39,608 INFO  [MediaServer] Headless mode enabled: true
2013-01-20 21:28:39,608 INFO  [MediaServer] User: myuser
2013-01-20 21:28:39,608 INFO  [MediaServer] User home dir: /Users/myuser
2013-01-20 21:28:39,608 INFO  [MediaServer] Temp dir: /var/folders/lr/rnv4gjw52dz73c37m079rdg00000gn/T/
2013-01-20 21:28:39,608 INFO  [MediaServer] ------------------------------------------------------------------------
2013-01-20 21:28:39,695 INFO  [WebServer] Socket buffer set to 65535 bytes
2013-01-20 21:28:39,697 INFO  [RestletServer] Starting Restlet server (/rest) exposed on port 23423
2013-01-20 21:28:39,723 INFO  [RestletServer] Starting Restlet server (/cds) exposed on port 23424
2013-01-20 21:28:39,724 INFO  [RestletServer] Starting Restlet server (/mediabrowser) exposed on port 23424
2013-01-20 21:28:39,732 INFO  [DBSchemaUpdateExecutor] Checking if DB schema needs to be updated
2013-01-20 21:28:39,737 DEBUG [DBLogDAOImpl] Checking if script 'script-0.1.sql' has been run
2013-01-20 21:28:39,740 WARN  [DBConnectionPool] Can't create a new connection for jdbc:derby:db;create=true
java.sql.SQLException: No suitable driver found for jdbc:derby:db;create=true
   at java.sql.DriverManager.getConnection(DriverManager.java:602)
   at java.sql.DriverManager.getConnection(DriverManager.java:207)
   at org.serviio.db.DBConnectionPool.newConnection(DBConnetionPool.java:186)
   at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:123)
   at org.serviio.db.DBConnectionPool.getConnection(DBConnetionPool.java:149)
   at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:66)
   at org.serviio.db.DatabaseManager.getConnection(DatabaseManager.java:59)
   at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:49)
   at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:57)
   at org.serviio.MediaServer.main(MediaServer.java:110)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at apple.launcher.LaunchRunner.run(LaunchRunner.java:116)
   at apple.launcher.LaunchRunner.callMain(LaunchRunner.java:51)
   at apple.launcher.JavaApplicationLauncher.launch(JavaApplicationLauncher.java:52)
2013-01-20 21:28:41,745 ERROR [MediaServer] An unexpected error occured. Ending the application. Message: null
java.lang.NullPointerException
   at org.serviio.update.dao.DBLogDAOImpl.isScriptPresent(DBLogDAOImpl.java:50)
   at org.serviio.update.DBSchemaUpdateExecutor.updateDBSchema(DBSchemaUpdateExecutor.java:57)
   at org.serviio.MediaServer.main(MediaServer.java:110)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at apple.launcher.LaunchRunner.run(LaunchRunner.java:116)
   at apple.launcher.LaunchRunner.callMain(LaunchRunner.java:51)
   at apple.launcher.JavaApplicationLauncher.launch(JavaApplicationLauncher.java:52)

Maybe it's this: No suitable driver found for jdbc:derby:db;create=true ?

GateKeeper is set to allow applications downloaded from anywhere.

derby.jar is part of Serviio.app at Serviio.app/Contents/Resources/Java/derby.jar
The tarball from which I extracted Serviio.app has the correct MD5 checksum as per Serviio's Download webpage (93051e796b6428c7ca87194fe53e92bb). The MD5 checksum of Serviio.app/Contents/Resources/Java/derby.jar is 000702c96fa81afad91ba1be32ff0a08

Regarding permissions,
All directories and files inside Serviio.app are 755 and 644, respectively, with myuser:staff as owners. Being myuser the user I'm using to execute Serviio.app.
I also run the Repair Permissions procedure in the Disk Utility of Mac OS X just to be sure everything else is OK.
And I tried

  Code:

$ sudo open /Applications/Serviio.app

which produced the same warning and error as always, so I'd really say it's not a permissions problem.

Any hint?

Thanks

Miguel

I've tried the same on another Mac OS X 10.8.2 with the same Java version and it works well.

The problem is the No suitable driver found for jdbc:derby:db;create=true thing.

The question is. Why am I getting this error if I have derby.jar inside the Java folder and the checksum of the tarball used to install is correct (no corruption of files)????

How can I get more detailed logs of this? I'm already using the DEBUG log level as defined in log4j.xml

Any hint of what could be the reason for the failure??

Thanks

I solved the problem by removing fmjdbc.jar from ~/Library/Extensions/