Church Historical Timeline Database

Church Historical Timeline Index edit

For development, the Timeline Web Services use the Oracle XE database

Database setup

Before you start this process make sure you have checked out the timeline project according to the instructions in Getting Started. We are using the Oracle VM for timelines development. Please use those instructions.

Oracle VM Check

A simple test to make sure the Oracle VM is working as expected is to ping it from your host machine.


You should get a response.

Install Oracle-XE on your development machine

This section contains information that may be out-of-date due to later decisions or developments.
We have migrated to the Oracle VM for development and the standalone Oracle instance will no longer work for development unless you set up an Oracle server of your own with an IP address of

Make sure that you choose the Oracle-XE Universal Edition, not Western European, so that you can have save data in Unicode for multi-language support. You do not need to install the SQL*Plus Client. Follow the specific instructions during the installation for your operating system. The TNS service should be listening on port 1521 (the default).

Set up timeline user

You can use the Oracle Web Application Express to do create a database user.

  1. Oracle Web Application Express should be running on http://localhost:7000/apex.
  2. Sign in as system, using the password that you created during installation.
  3. Once you have signed in, select Administration->Database Users->Create User.
  4. Create a user called timeline with a password of timeline.

Run the database installation script

Right now, the easiest way to do this is via command line. There are plans to have a GUI interface for database migration in the LDS-IDE, but we don't have that yet. So open up a command prompt or shell, navigate to the timelines/db directory in you workspace, and type:

mvn stack-db:migrate

or simply:

mvn install

This will run the database migrate plugin, and prompt you to migrate the database. If you have setup everything properly, it should work! If you check Oracle Web Application Express, logging in as timeline, you should now have some tables and sample data. If you have problems at this step and can't figure out what is wrong, contact a member of the timeline team, and we will be happy to help you.

Create the timeline database

This section contains information that may be out-of-date due to later decisions or developments.
We have migrated to Oracle-XE for development and the MySQL Development Environment instructions should no longer be used for Timeline development.

Timeline database configuration

Database Name: timeline

Create database user

We will assume that you have a MySQL database running on your system and that you can access it via a port on the local machine. The default port for MySQL is 3306, and you may use another one if you desire, but you will need to update (in the schema-versions directory) to reflect that.

We now need to create a database (see IMPORTANT below for the reason why we must do this manually) called 'timeline'. This can be done by the following DDL:


Then we need to create the user. Something like this should work on a development machine:

GRANT ALL ON timeline.* TO 'timeline-user'@localhost IDENTIFIED BY 'timli9Ne';

Again, you are welcome to use another username and password; just update the file, the file in the deploy project, and the applicationContext-test.xml file in the web project.

IMPORTANT: Because of a limitation in the stack-db-migrator, when using MySQL, you will need to manually execute the following script in order for it to work. The stack-db-migrator tool tries to create the SCHEMA_INFO table, but it uses SQL code designed for Oracle, and it does not work on MySQL. It does not appear to be possible to override this without changing the library code. If anyone has come up with a way to do this, please let Robert Husted know! For now, you must create the table manually, and then the migrator tool works. Here is the script you must execute:

USE timeline;

Run the stack-db-migrator

Once you have created your user and added the schema_info table, you can run the stack-db-migrator to bring your database up to the current version. For a development environment, run this command in a shell inside the db directory (C:\LDSTech\workspace\timelines\db):

mvn stack-db:migrate

This page was last modified on 24 February 2011, at 21:52.

Note: Content found in this wiki may not always reflect official Church information. See Terms of Use.