JDBC-Based SmartMapper Service
The JDBC-Based Service accesses a JDBC database to manage cross-referencing data. This service runs inside a TIBCO ActiveMatrix BusinessWorks engine and uses a JDBC driver to read and write data to a database.
Three databases are supported, MySQL, SQL Server, and Oracle. Besides if you want to use MySQL or Oracle, you are required to add the official drivers. See TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper Installation for more details.
JDBC Settings Tab
The JDBC Settings tab contains the following fields.
Field | Module Property? | Description |
---|---|---|
Database | No | The database type. Select the database that you want to use as the storage from the list. |
JDBC Driver Class | Yes | The fully-qualified java class name of the JDBC driver. The class name is given automatically when you select your database type. |
JDBC URL String | Yes | The appropriate URL string for the driver. |
User | Yes | The database user name. |
Password | Yes | The database password. |
Connection Pool Size | Yes | This value determines the maximum number of connections available in the pool. TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper database access always uses connection pooling. |
Login Timeout (sec) | Yes | The amount of time in seconds before the login attempt times out. |
Test Connection | No | The validation of the database connection. Click Test Connection to validate the specified database connection. |
Sync ER Model w/DB | No |
The synchronization process creates new database tables. The database user specified in the User field needs to have 'create table' privileges. At run time, the SmartMapper activity does not create any new database tables and hence you are not required to have those privileges for running the activities. Currently, TIBCO ActiveMatrix BusinessWorks Plug-in for SmartMapper requires that the user who runs activities is the same user who has done the synchronization and created the tables. See Synchronizing SmartMapper ER Model regarding the Synchronization. |
Caching Tab
The Caching tab contains the following fields.
Field | Module Property? | Description |
---|---|---|
Enable Caching | No | Select to enable caching. Clear to disable caching. |
Cache Type | No | Select a caching type from the list. Two types are available:
Note: To use TIBCO ActiveSpaces caching, ensure TIBCO ActiveSpaces is installed. Besides, add corresponding ActiveSpaces libraries to your system environment variables, see
Adding ActiveSpaces Library into Environment Variables for more details.
|
The following fields are available when Local is selected in the Cache Type field. | ||
Maximum Number Of Entries | Yes | The maximum number of entity instances to be stored in the cache.
If the number of entity instances exceeds the specified number, the excess cache entries are culled from the cache using a least-recently-used algorithm. |
Cache Synchronization Interval (sec) | Yes | The time interval, in seconds, that cache housekeeping is performed. |
The following fields are available when ActiveSpaces is selected in the Cache Type field. | ||
Metaspace Name | Yes | Specify the name of the metaspace to connect to. |
Discovery URL | Yes | Specify the discovery URL to use to discover each metaspace. |
Listen URL | Yes | Specify the URL to use to listen for the incoming connections from new members to the metaspace. |
Relationship Capacity | Yes | Specify the maximum number of relationship instances per seeder for the space.
If the number of relationship instances exceeds the specified number, the relationship instances that are not frequently used are deleted. |
Replication All | No | Specify whether to replicate all the relationship data or not. Selecting this check box means that all the relationship data are replicated on all the seeders. |
Distribution Role | No | Select the distribution role for a newly joined member from the following options: |
Export | No | Generates an XML file, which includes the ActiveSpaces parameters of all the entities and relationships in this ER Model. |
- Synchronizing SmartMapper ER Model
Synchronization creates the tables and sequences in a database that are required for storing a SmartMapper ER Model in the database. - Adding ActiveSpaces Library into Environment Variables
To use the TIBCO ActiveSpaces caching, you have to add the ActiveSpace library to the environment variables.