Ticket #898 (closed defect: fixed)

Opened 4 years ago

Last modified 3 years ago

From embedded derby server to networked derby server

Reported by: ak19 Owned by: ak19
Priority: moderate Milestone: 3.07 Release
Component: Collection Building Severity: major
Keywords: derby Cc:

Description

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

Change History

Changed 4 years ago by ak19

  • status changed from new to closed
  • resolution set to fixed

Changed 3 years ago by ak19

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

30233, 30231, 30196, 30170

Changed 3 years ago by 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

Note: See TracTickets for help on using tickets.