Name Date Size

.. 2015-12-17 05:14:07 17

db2 2015-12-17 01:45:27 4

h2 2015-12-17 01:45:27 4

mssql 2015-12-17 01:45:27 4

mysql 2015-12-17 01:45:27 4

oracle 2015-12-17 01:45:27 4

postgresql 2015-12-17 05:14:07 4

README 2015-11-04 22:03:41 1.2 KiB

README

The subdirectories in this directory have samples for each supported backend RDMS for each of the following:

 * DDL for creating the tables in the database
 * repo.jdbc.json - query and table definition configuration for the repository service
 * datasource.jdbc-default.json - default, pooled datasource configuration

In repo.jdbc.json, set the "useDataSource" parameter to the same configuration suffix as the database.jdbc-.json
file.  For example, to create a new datasource named "mypool", create the file database.jdbc-mypool.json and set

    "useDataSource" : "mypool"

in repo.jdbc.json.

Multiple datasource configurations are used, but the repository will only use one of them.

Additionally, if you wish to configure a DataSource via JNDI, use this configuration:

    {
        "jndiName" : "java:comp/env/jdbc/MySQLDB",
        "databaseName" : "openidm"
    }

and change the jndiName to the appropriate JNDI name for your installation.

To use a custom OSGi bundle to provide the DataSource, use this configuration:

    {
        "osgiName" : "osgi:service/javax.sql.DataSource/(osgi.jndi.service.name=jdbc/openidm)",
        "databaseName" : "openidm"
    }

and change the osgiName to the appropriate OsgiName string for your installation.