Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved


Chapter 30 JDBC Backing Store Setup : Resources Required for Setting Up the Database

Resources Required for Setting Up the Database
Provided Configuration Resources
The table below lists resources required and sections following explain the procedures for setting up backing store tables.
The base_types.xml file is used by the deployment utility. Do not edit this file.
be-jdbcdeploy executable
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.
Note: Use a different user (and schema) for every TIBCO BusinessEvents project that needs a backing store. This script drops the user (and therefore all the tables) and adds the user again.
These scripts are generated when you use the File > Export > JDBC Deployment wizard. The value for yourname is specified in the Output Script Name Prefix setting. You specify the location of the scripts in the wizard
You can manually execute the be-jdbcdeploy executable. You specify script name prefix at the command line. Scripts are generated in the same directory where you run be-jdbcdeploy.
yourname.aliases
yourname_alter.sql
The yourname_alter.sql script is for use in schema migration. Generated only after updates are made to the be-jdbcdeploy.tra file. See Updating an Existing Backing Store Schema.
yourname_cleanup.sql
yourname_delete.sql
yourname_remove.sql

Copyright © TIBCO Software Inc. All Rights Reserved
Copyright © TIBCO Software Inc. All Rights Reserved