Generating the Project-Specific SQL Scripts
Ensure that you have generated the project EAR file before beginning.
Procedure
- In TIBCO BusinessEvents Studio Explorer, right-click the FraudDetectionStore project name and select Export > TIBCO BusinessEvents > JDBC Deployment.
-
Click
Next.
You will see the Generate JDBC deployment scripts wizard.
-
Complete the values as follows.
- In the Database Type field, select your database type. The default is oracle.
- In the Cluster Deployment Descriptor field, browse to and select the fdstore CDD.
- In the Output Directory field, browse to and select the directory where the scripts will be generated. The tutorial project uses BE_HOME/bin.
- In the Output Script Name Prefix field, type fdstore.
-
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 Table 62, Resources Required for JDBC Backing Store Implementation in TIBCO BusinessEvents Developer’s Guide.
Copyright © TIBCO Software Inc. All Rights Reserved.