Database Configuration

Owned by Former user (Deleted)
Last updated: Dec 05, 2015 by AnisB

 

 

Please Note:

The following executable tables are designed with a header row of 2 columns. This is just design. You can create tables with e.g. 3x3 cells.

LivingDoc has its own database to store multiple data such as executions results, references and so on.
There are two different ways to install LivingDoc:

Quick Install

This will automatically setup an embedded database.
This configuration is not recommended for a production environment. It should only be used for an evaluation/tryout purpose.

Custom Install

This will allow you to setup LivingDoc to use an external DBMS via a JNDI name. You need to have the JDBC drivers installed first.
 

The LivingDoc installation includes an embedded HSQLDB database, supplied for the purpose of evaluating LivingDoc.

 

If you are using the embedded database, the database files are stored in the \database directory under your Confluence Home and other important directories.

 

Note: The embedded HSQLDB database is not suitable for production environment.

 

Database setup 

 

LivingDoc supports all external databases which are currently supported by Confluence. For more information, check out their latest List Of Supported Databases. 
Here are the setup instructions for the supported databases:

Supported JDBC Drivers

This page provides the download links for the JDBC drivers for all databases currently supported by LivingDoc. You will need to make the driver available to your application server, as described in the appropriate setup guide.

Note: Some JDBC drivers are bundled with Confluence, as shown below. If you are using a direct JDBC connection, you do not need to download or install the drivers that are bundled. If you are connecting via a datasource, or if you are using a database whose driver is not bundled, you will need to download and install the drivers manually.

 

Database

JDBC driver bundled with Confluence?

JDBC drivers

Notes

PostgreSQL

(tick)

9.2-1004 JDBC 4 driver download

 

 

The JDBC 4 driver will work under the 1.7 JVM. If you want to use other drivers, you can download it from the PostgreSQL website. However, we recommend that you use the bundled JDBC 4 driver.

Microsoft SQL Server

(tick)

jTDS 1.2.2 driver download

 

The above version is the version bundled with Confluence. All our testing is done on that version. We do not know of any issues with later versions, so you are free to use them if you have tested them and find there are no issues in your environment. However, later versions are technically not supported. That means that if you do run into any problems, Atlassian Support may require you to move back to the above fully- tested version for troubleshooting.

MySQL

(error)

Connector\J 5.1.30 driver download

 

Note: In Confluence 5.1 and later, the MySQL drivers are no longer included in the Confluence distribution. For more information please refer to the Confluence 5.1 Upgrade Notes.

Oracle

(error)

JDBC driver downloads

  • For Oracle 11.1, use the 10.2.0.4 or 11.1.0.7.0 driver (Java 6 ojdbc6.jar).
  • For Oracle 11.2, use the 11.2.0.1.0 driver (Java 6 ojdbc6.jar).

We recommend using the thin drivers only.

Tip: Search for the JAR file name on the download site.

See the Oracle JDBC driver FAQ.

 

Database Setup for Oracle

Atlassian has a great guide for setting up an Oracle database for Confluence. You can use this guide to setup your Oracle database for LivingDoc as well.

Atlassian Database Setup for Oracle

Database Setup for MySQL

Atlassian has a great guide for setting up an MySQL database for Confluence. You can use this guide to setup your MySQL database for LivingDoc as well.

Atlassian Database Setup for MySQL

Database Setup for PostgreSQL

Atlassian has a great guide for setting up an PostgreSQL database for Confluence. You can use this guide to setup your PostgreSQL database for LivingDoc as well.

Atlassian Database Setup for PostgreSQL

Database Setup for SQL Server

Atlassian has a great guide for setting up an Microsoft SQL Server database for Confluence. You can use this guide to setup your Microsoft SQL Server database for LivingDoc as well.

Atlassian Database Setup for Microsoft SQL Server

Selecting an external database in LivingDoc Configuration

 
  1. Select "Custom Install" as the Installation Type. 
  2. Choose your Database. 
  3. Enter your JNDI Name. If " java:comp/env/jdbc/DataSourceName " doesn't work, try "jdbc/DataSourceName" (or vice-versa).
  4. Now you can
    1. test your database connection with the "Test" button or
    2. save your external database configuration with the "Save" button.
      Note: You can only save your database configuration if LivingDoc is able to connect to your external database.