![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
See Reset the Backing Store Tutorial for various levels of reset you can do if you want to reuse this tutorial example.What happens if I change the project ontology after setting up the database schema? If you change the project ontology you must update the database schema. You must also update the schema if you add an entity that you previously excluded from the backing store. A utility is provided that can handle most changes. Certain changes require manual updates. See the section Updating an Existing Backing Store Schema, in TIBCO BusinessEvents Developer’s Guide.What are the minimum permissions for the database user? At a minimum, the user must be able to create tables and views. By default the BE_USER user created by the scripts has DBA privileges.The tutorial uses the default username (BE_USER) and password (BE_USER). You can change the username by editing the BE_HOME/bin/ initialize_databaseYourDBMS.sql script.
Running the initialize_databaseYourDBMS.sql script deletes the user before creating it again. Running the create_tables_YourDBMS.sql drops all database tables before creating them again. This means you can run these scripts again during test phases of your project development, without having to take extra cleanup steps.
1. Ensure your DBMS is running. Open a command window in BE_HOME/bin (default location of the scripts) and type the following command for Oracle (if you use the default SID you can omit @SID):Type exit to exit and commit.
Next you log on as the TIBCO BusinessEvents user, BE_USER by default, and run a script to create non-project specific tables.
1. Type exit to exit and commit.You see various harmless error messages the first time you run the script, and various messages saying Table created and Index created.
1. In TIBCO BusinessEvents Studio Explorer, right-click the FraudDetectionStore project name and select Export > TIBCO BusinessEvents > JDBC Deployment. Click Next.
2. You see the Generate JDBC deployment scripts wizard. Complete the values as follows.
c.
d.
3. Click Finish. The generated scripts appear in the directory you specified. If you are following the tutorial instructions, the following files appear in the BE_HOME/bin directory:fdstore.sqlfdstore_remove.sqlThe use of these scripts is explained in Table 62, Resources Required for JDBC Backing Store Implementation in TIBCO BusinessEvents Developer’s Guide.
1. sqlplus BE_USER/BE_USER @fdstore.sql
Congratulations! You are ready to start the FraudDetectionStore application.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |