From embedded derby server to networked derby server

[ak19]

We changed from an embedded derby server to a networked derby server in order to not have concurrent access problems.

Changesets: 29903, 29923, 29977, 29988, 30013, 30043, 30055

This ticket was opened in order to link to the documentation that helped make the derby changes possible. These links are moved here from the 3.07 release notes on the GS wiki.

Derby changes

We've moved to a Derby Network Server (db-derby-10.1.2.1-bin) from Embedded Derby for managing the user database.

​https://db.apache.org/derby/docs/10.4/adminguide/ - 10.1.2 derby admin guide

​http://db.apache.org/derby/docs/10.7/devguide/cdevdvlp17453.html

​http://db.apache.org/derby/papers/DerbyTut/embedded_intro.html

​http://db.apache.org/derby/papers/DerbyTut/ns_intro.html#ns_lookat_code

​http://db.apache.org/derby/derby_downloads.html

db-derby-10.1.2.1-bin/docs/html/adminguide/index.html

Starting the Network Server without using the script

Altering the startNetworkServer script

[ak19]

Revision numbers of other changesets related to updating the derby version:

30233, 30231, 30196, 30170

[ak19]

We'd discovered that spaces in the GS3 installation file path prevented successfully setting the admin password, both during the installer and by running ant config-admin from the commandline after installation.

Dr Bainbridge found that the page at ​https://bugs.eclipse.org/bugs/show_bug.cgi?id=152709 shows that this is an issue with the version of db derby we were using (10.1.2.1). The recommended solution to the issue was to use Derby version 10.1.3.1, which is to have fixed this issue.

Now using Derby version 10.1.3.1 (released Jun 30, 2006) from ​https://db.apache.org/derby/derby_downloads.html

Tested to work on linux and windows in a GS3 installed in a location containing spaces in its filepath. The "ant config-admin" command to (re)set the password now works.

Changeset http://trac.greenstone.org/changeset/30612