Choose database engine ?

OK, so I'm new to Serviio, but have been reading through this thread with great interest. I'm trying to connect to the Derby database with SQuirreL SQL, but must be making some stupid mistake, as I keep getting the error: Serviio: A communications error has been detected: Read timed out. My connection URL is set as follows: jdbc:derby://localhost:23423/C:\Program Files (x86)\Serviio\library\db . I set this port since this is what Serviio appears to be listening on based upon a netstat -a as well as reviewing the port exception that Serviio created for Windows Firewall. I've tried using APP for the user ID with no password, but it complains that the password must be between 1 and 255. I've also put junk in the password (i.e. test, etc.), but then I get the timed out error.

Can someone help put me on the right path for the connection information? I want to be able to edit the metadata information on my recordings since a majority of the 1200+ videos either came in as unknown, or incorrectly categorized.

On a side note, I noticed that even though I pulled the latest version of Serviio, it does not appear to be using the latest version derby.jar. I pulled the latest from their website, and the files are dated in November as opposed to September. Don't know if they have made further performance enhancements, but thought it worth mentioning.

Thanks for any help that you can provide.
Kevin

[WildRushSykes]

where is the derby release the latest i see is october 24th 2011?

Sorry, my bad. You are correct, October is the latest. But the version delivered in Serviio is September.

[zip]

OK, so I'm new to Serviio, but have been reading through this thread with great interest. I'm trying to connect to the Derby database with SQuirreL SQL, but must be making some stupid mistake, as I keep getting the error: Serviio: A communications error has been detected: Read timed out. My connection URL is set as follows: jdbc:derby://localhost:23423/C:\Program Files (x86)\Serviio\library\db .

It's jus tfile based. Should be something like:

  Code:

jdbc:derby://C:/Program Files (x86)/Serviio/library/db

[kairoh]

  Code:

jdbc:derby:C:/Program Files (x86)/Serviio/library/db

should also work.

But you need to stop Serviio first!
Or you'll get an error :

  Code:

Caused by: java.sql.SQLException: Another instance of Derby may have already booted the database

Unlike H2, Derby does not allow multiple connection (maybe you should enable the "network server" mode?).

OK, well that did it. I had to use Kairoh's connection string though to make it work. I did run into the multiple connection problem, however. I saw reference to the network server mode earlier in this thread, but was not able to glean enough details to know how to set it up or configure it. If someone could point me in the right direction, that would be great.

I was very pleased with SQirreL SQL. At first I started running queries and updates completely manually, but then discovered that not only can you make updates directly within the GUI, but you can select multiple records and update them all at once. I found this great for the one or two like genre updates, as well as the 60 record updates for an entire series. Everything worked perfectly and was extremely responsive. I know that the tool may not be as elegant as some of the other that they are used to, but it isn't half bad if you give it a chance.

Next I'll try and tackle my missing series info. After scanning all of my videos, I was a little surprised to find that 0 files turned up in the series folder. So....

Thanks for the help. If there is anything that I can do to help with the database engine testing, just let me know.

Thanks,
Kevin

[kairoh]

I didn't test everything with h2 db : you're right about Derby incompatibility.
Derby supports "FETCH FIRST" sql syntax since a few weeks only and H2 will supports compat mode in the next release (see this ticket).
DB2 compatibility is needed, but creates new bugs...
We should wait for the next H2 release.

New H2 release (1.3.162) seems to work really fine!
I've only had to set the fixed "script-0.6.sql" file for some indexes creation, and enabled Derby Mode (AUTO_SERVER is for multiple connection) :

  Code:

jdbc:h2:./library2/serviio;AUTO_SERVER=TRUE;MODE=Derby

I was very pleased with SQirreL SQL. At first I started running queries and updates completely manually, but then discovered that not only can you make updates directly within the GUI, but you can select multiple records and update them all at once. I found this great for the one or two like genre updates, as well as the 60 record updates for an entire series. Everything worked perfectly and was extremely responsive. I know that the tool may not be as elegant as some of the other that they are used to, but it isn't half bad if you give it a chance.

You may also use H2 console (included in H2 jar), which is simple but effective OR Oracle's SQL Developer, which is easy, complete and still free .

[Xmantium]

I'm reading many benchmarks H2 database works so much faster than Derby. And a big bonus is it's CPU efficient.
Zip if your waiting for a good time to release it when every Serviio user have to restart their library is your version 1.0

[Cerberus]

I'm reading many benchmarks H2 database works so much faster than Derby. And a big bonus is it's CPU efficient.
Zip if your waiting for a good time to release it when every Serviio user have to restart their library is your version 1.0

second that