6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan MillerThe subdirectories in this directory have samples for each supported backend RDMS for each of the following:
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller * DDL for creating the tables in the database
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller * repo.jdbc.json - query and table definition configuration for the repository service
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller * datasource.jdbc-default.json - default, pooled datasource configuration
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan MillerIn repo.jdbc.json, set the "useDataSource" parameter to the same configuration suffix as the database.jdbc-<suffix>.json
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Millerfile. For example, to create a new datasource named "mypool", create the file database.jdbc-mypool.json and set
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller "useDataSource" : "mypool"
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan MillerMultiple datasource configurations are used, but the repository will only use one of them.
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan MillerAdditionally, if you wish to configure a DataSource via JNDI, use this configuration:
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller "jndiName" : "java:comp/env/jdbc/MySQLDB",
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller "databaseName" : "openidm"
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Millerand change the jndiName to the appropriate JNDI name for your installation.
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan MillerTo use a custom OSGi bundle to provide the DataSource, use this configuration:
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller "osgiName" : "osgi:service/javax.sql.DataSource/(osgi.jndi.service.name=jdbc/openidm)",
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Miller "databaseName" : "openidm"
6fedacfa375cad51ceff9c6237ef3b0488a29792Brendan Millerand change the osgiName to the appropriate OsgiName string for your installation.