Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Generating the Project-Specific SQL Scripts

Ensure that you have generated the project EAR file before beginning.

Procedure
1. In TIBCO BusinessEvents Studio Explorer, right-click the `FraudDetectionStore` project name and select Export > TIBCO BusinessEvents > Backingstore Deployment.
2. Click Next.
   You will see the Deploy wizard.
3. In the Backingstore Type field, select `Relational Database (JDBC)` and click Next.
4. Complete the values as follows.
   1. In the Database Type field, select your database type. The default is `oracle`.
   2. In the Cluster Deployment Descriptor field, browse to and select the `fdstore` CDD.
   3. In the Output Directory field, browse to and select the directory where the scripts will be generated. The tutorial project uses BE_HOME`/bin`.
   4. In the Output Script Name Prefix field, type `fdstore`.
5. 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.sql
          fdstore_cleanup.sql
          fdstore_delete.sql
          fdstore_alter.sql
          fdstore_remove.sql
          fdstore.aliases

   The use of these scripts is explained in "Resources Required for JDBC Backing Store Implementation" in TIBCO BusinessEvents Developer Guide.

Did you find this helpful?

YesNo
Great!
Thanks for taking the time to give us some feedback.
Sorry about that

Why wasn't this helpful? (check all that apply)

Could not find what I was looking for
Instructions confusing or unclear
Instructions did not work

Want to tell us more?

Please select at least one option or provide details about the issue!!

Error occurred while submitting feedback.

Error2 occurred while submitting feedback.

TIBCO BusinessEvents® Enterprise Edition

Copyright © 2004-2024. Cloud Software Group, Inc. All Rights Reserved.