JDBC Backing Store Configuration : JDBC Backing Store Database Setup Overview

JDBC Backing Store Database Setup Overview
A backing store enables persistent backup of the objects generated and modified at runtime. Use of a backing store enables recovery in the event of a system-wide failure.
The backing store feature requires use of Cache object management. Before you add a backing store, develop your caching solution and test it.
The JDBC backing store feature supports the DBMS products listed in the product readme file (also listed in TIBCO BusinessEvents Installation).
Ease of Maintenance
The backing store uses relational tables and SQL data types for ease of maintenance. The SQL (DDL) scripts use ANSI SQL type definitions (where supported by the target DBMS product). Because the backing store adheres to SQL standards and a straight-forward structure, standard database tools can be used to view backing store data. See Backing Store Table Reference for more on the table structures.
Backing Store Requirements
Ensure that you have access to a supported database management product and driver, and can create a user with permission to connect to the database and create tables and views. Resources Required for Setting Up the Database outlines all the resources you need to set up a backing store.
Database Location
Instructions in this chapter assume you are working with a local database for testing purposes. Adapt the instructions if you are working with a remote database. For example, in production environments, you might have to ask a database administrator to create a database user for you. You should then be able to run the other SQL scripts yourself, logged on as the user created by the administrator.
Special Cases
Certain aspects of a project ontology may require special handling. See the following sections for details on how to handle these issues.:
After You Finish Database Setup
After you finish database setup, you must configure various project properties to enable and configure backing store functionality. See Adding a JDBC Connection Resource to the Studio Project and Configuring Backing Store Properties in the CDD Editor for details.