RDBMS Integration

#RDBMS Integration[DRAFT]

NOTE: This document is a draft. The content may have big changes until the release of the RDBMS feature. Also the links cited here will refer to the RDBMS branch.

Lightblue can have its data storage in a RBMS. To archive that, the user must setup the RBMS enviroment and inform through metadata that an specific entity will use an relational database to persist entity data. projection, and sort specification.

How to configure your entity’s data be persisted on a RDBMS

To use an RDBMS to persist the entity’s data, you have to inform the datastore field that will have the JNDI for the configured JDBC datasource connection pool on the EntityInfo from Metadata. Then, you have to create an field called rdbms in the EntityInfo content following this schema so all the operations (query, projection, delete, etc) on the entity can be properly handled by the Lightblue’s RDBMS controller.

Example of a new Entity Metadata that will use RDBMS for data persistence:

TODO

RDBMS Schema

Details about why and how to fill the RDBMS schema

Update

Better descrition for each operation and example how each would look like

TODO

A Complete simple example

Write down all the required steps to create a simple RDBMS usage example using cURL.