accessing serviio db (derby) from remote

[mbil74]

Hi.
I would like to enable network connection to derby db running on serviio (I would like to start a jdbc connection from another pc).
Can this be done? How? Is there a tutorial available?

regards.

[zip]

I dont think it's possible as it's enbedded DB and doesn't run derby server. You'd have to access is locally only (by pointing the jdbc driver at the library folder)

[mbil74]

ok... waiting for serviio to support mySQL, then...

regards

[jabrown0604]

Could you map a network drive to the location of the db and the access it locally from the remote client?

We do this all the time at work for access databases.

http://db.apache.org/derby/docs/dev/getstart/ has a tutorial how to set up a server for a derby db

  Code:

C:\Program Files\Serviio\library>java -jar %DERBY_HOME%\lib\derbyrun.jar server start


You can then acces the DB from e.g. the associated ij client using:

  Code:

ij> CONNECT 'jdbc:derby://localhost:1527/db';


However this is only possble while Serviio Service is not running. While Serviio is running the database can not be mounted/changed from another program. Depending on your use case you might consider to copy the db to a sepeare folder and work on copied image.