Configuring CDD for Special Cases (As Needed)

This section summarizes CDD configuration that may be required to handle special cases.

See Ontology Identifiers that Exceed the DBMS Maximum Column Length.

The CDD file is only required during backing store setup if configured for these special cases. Other aspects of CDD configuration are ignored. Do this aspect of CDD configuration before you use the be-jdbcdeploy utility.

Procedure

  1. In TIBCO BusinessEvents Studio, open the project’s CDD file and select Backing Store from the list on the left.
  2. In the tree on the left, click Overrides and click Add.
  3. Select the entity or entities you want to customize and click OK.
  4. In the tree on the left, select the /uri entry for each selected entity in turn, and configure the settings on the right:
    • To exclude an entity from the backing store, uncheck the Has Backing Store checkbox.
      Note: In Memory Only mode, if you configure any entity override Mode setting as Memory Only, then backing store is disabled for that entity.
    • To specify a short table name for entities whose table names would exceed the database product’s maximum length, check the Has Backing Store check box, and enter the name in the Table Name field. See Ontology Identifiers that Exceed the DBMS Maximum Column Length for details, and for an alternative way to handle long names.
      Tip: It is recommended that you specify table names that start with "D_" to match the standard naming convention.
    • To specify the length of string properties that exceed 255 characters (that is the actual contents stored in the column is more than 255 characters), check the Has Backing Store check box, and in the Properties Metadata section, Max Length setting, specify the expected maximum length for all such properties. See String Properties that Exceed the DBMS Maximum Column Length for details.
  5. Save the CDD.