Copyright © TIBCO Software Inc. All Rights Reserved |
For specific database products and versions supported, see the readme file, which is in the TIBCO_HOME/release_notes directory.The table below lists resources required and sections following explain the procedures for setting up backing store tables.
BE_HOME/lib/ext/tcplNote Also copy the database-specific JDBC driver Required for backing store functionality to this directory. The base_types.xml file is used by the deployment utility. Do not edit this file. be-jdbcdeploy executable Executable and property files used to generate SQL scripts (see Generated SQL Scripts below). Use the appropriate SQL (DDL) script for your DBMS. This script creates the tables that are used to maintain the metadata. This file contains mappings to handle words used in the TIBCO BusinessEvents project that are database reserved words. See Ontology Identifiers that Use Database Key Words for details. Note This script drops the user (and therefore all the tables) and adds the user again.By default the user is called BE_USER with the password BE_USER and the user has DBA rights. Edit the script if you want the user to have a different name or different rights.For SQL Server, this script also creates the default database, with the name BE_USER and makes it the default database for the user BE_USER. These scripts are generated when you run the be-jdbcdeploy executable. Provide a value for yourname when you generate the scripts.They are located in the same directory where you run be-jdbcdeploy. yourname.sql yourname.aliases This script has entries if the database table identifiers are longer than the DBMS maximum character limit. See and Task J, Check the Aliases File and Modify Aliases as Desired. The yourname_alter.sql script is for use in schema migration. See Updating an Existing Backing Store Schema. yourname_cleanup.sql yourname_delete.sql This script is used for deleting entities that have been marked as deleted (applies only if write-behind database write strategy is used). yourname_remove.sql For use as needed. This script removes the database schema. You can use it to reset the project.
Copyright © TIBCO Software Inc. All Rights Reserved |