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


Chapter 30 JDBC Backing Store Setup : Initialize the Database and Generate Non-Project Tables

Initialize the Database and Generate Non-Project Tables
Ensure that you have done all earlier tasks that may pertain to your case (see Cases That May Need Additional Setup).
Task F Run the Initialize Database Script as the DBA or System User
This script creates the TIBCO BusinessEvents user and initializes the database.
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.
The first time you run the create_tables_YourDBMS.sql script, you see harmless error or warning messages because there is nothing to delete.
1.
As desired, change the default TIBCO BusinessEvents user credentials: Open the initialize_databaseYourDBMS.sql script for editing and change the default username and password. The documentation uses the default username (BE_USER) and password (BE_USER)
2.
Open a command window in the BE_HOME/bin directory (default location of the scripts), and the appropriate command for your DBMS at the prompt:
For Oracle:
sqlplus sys_user/sys_user_password@SID @initialize_database_oracle.sql
Type exit to exit and commit.
If you are using SQL Server, use this instead:
osql -S Your-Server -U sys_user -P sys_user_password -n -i initialize_database_sqlserver.sql
This script creates the TIBCO BusinessEvents database user. This user must be used to run the other scripts. You see messages like the following:
   User dropped.
   User created.
   Grant succeeded.
Task G Run the Create Tables Scripts as the TIBCO BusinessEvents User
Log on as the TIBCO BusinessEvents user, BE_USER by default and run a script to create non-project specific tables.
1.
Open a command window in the BE_HOME/bin directory (default location of the scripts), and type the appropriate command for your DBMS at the prompt:
For Oracle:
sqlplus BE_USER/BE_USER@SID @create_tables_oracle.sql
Type exit to exit and commit.
If you are using SQL Server, use this instead:
osql -S Your-Server –d Your-DB -U BE_USER -P BE_USER -n -i @create_tables_sqlserver.sql
Use the credentials defined in the initialize_database_oracle.sql or initialize_database_sqlserver.sql files. By default those are: username BE_USER, with password BE_USER.
You see various harmless error messages the first time you run the script.

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