Open topic with navigation

TIBCO BusinessEvents® Enterprise Edition 6.3.1

# Run the Project Schema Script (as BE_USER)

In this step, you log in as the user you created and run a script to create the project related part of the database schema.

Procedure
1. Open the command prompt and navigate to theBE_HOME/bin directory (the default location of the scripts).
2. Run the `yourname.sql` script. (For example, `@acme.sql`). You can log in with the username `BE_USER`, password `BE_USER` or whatever username and password you have set up).
3. On the command prompt, type the appropriate command for running project schema scripts for your backing store. For complete details on these commands, such as to enable SSL authentication or enable client-side and server-side encryption, see the documentation of your backing store.
   - For Oracle:

         sqlplus BE_USER/BE_USER @ yourname.sql

   - For SQL Server:

         osql -S Your-Server –d Your-DB -U BE_USER -P BE_USER -n -i @yourname.sql

   - For MySQL:

         mysql -u BE_USER -p database_name < yourname.sql

   - For PostgreSQL:

         psql -U username -d database_name -f yourname.sql

   - For ActiveSpaces:

         tibdg -g <grid_name> -r <FTL_realm_URL> -s <yourname>.tibdg

   - For Cassandra:

         cqlsh -k <keyspaceName> -u <username> -p <pwd> -f <yourname>.cql

Result

If there are no errors, then your database tables are now configured for use. But, if there are errors, then you may need to add some mappings to the key word mapping file.

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.