Page 1 of 1

accessing serviio db (derby) from remote

PostPosted: Sat May 12, 2012 8:27 am
by 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.

Re: accessing serviio db (derby) from remote

PostPosted: Sat May 12, 2012 3:39 pm
by 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)

Re: accessing serviio db (derby) from remote

PostPosted: Sun May 13, 2012 7:53 am
by mbil74
:(
ok... waiting for serviio to support mySQL, then... ;)

regards :)

Re: accessing serviio db (derby) from remote

PostPosted: Wed May 16, 2012 9:08 pm
by 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.

Re: accessing serviio db (derby) from remote

PostPosted: Wed Dec 05, 2012 12:22 pm
by KrisDech
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.