![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |
The Oracle-only (Oracle Types) backing store is not supported in 5.0.0 If you were using this backing store implementation in your prior version of TIBCO BusinessEvents, implement a JDBC backing store and migrate your data to it as explained in this section.
If you plan to make any schema changes, make them after the backing store data is migrated successfully, following directions in TIBCO BusinessEvents Developer’s Guide.Task A All Versions
3. Login to the Oracle server as be_user, password be_user (or whatever username and password you are using, as set in the initialize_database.sql script).
4. Navigate to the location of the scripts (by default in BE_HOME/bin) and open an SQLPlus prompt. Identify yourself as the user you logged in as.Running this script does not affect any existing tables (therefore there is no need to run be-oradeploy.exe). Your database tables are now configured.Import the project into TIBCO BusinessEvents Studio and ensure that the migrated project is configured correctly. See Migrating 3.x Projects for full details.Task D Add a JDBC Backing StoreIn this task, you set up a new backing store, including creation of a new JDBC Connection resource.
1. Add the JDBC backing store, following instructions in Chapter 30, JDBC Backing Store Setup, which is in TIBCO BusinessEvents Developer’s Guide.Open the BE_HOME/bin/be-migration.tra file and specify appropriate values for the properties shown below, with example values. For notes on the properties see Backing Store Data Migration Property Reference.
1. be-migration -copy -ear EARFile
2. If you set the property be.migration.objecttable=false in Task E then you must manually migrate OBJECTTABLE table contents. (Use your DBMS product documentation for this task.)
When this property is set to false, the migration process ignores the data contained in OBJECTTABLE table. Skipping this table can shorten the migration time considerably.If you skip migration of the OBJECTTABLE table, you must then copy this table from the Oracle to the JDBC backing store database using other tools (or simple SQL scripts). jdbc: The JDBC backing store schema. Use this value for migrating from an Oracle backing store to a JDBC backing store (the procedure documented in this section).oracle: No longer valid as an option.
![]() |
Copyright © TIBCO Software Inc. All Rights Reserved |