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.Migration steps depend on whether you are migrating from 3.0.0, or from a later 3.x release, or from a 4.x release, as indicated in the tasks below.
During migration, you must keep the JDBC Connection resource for the existing Oracle-only backing store, and you must be able to connect to it.The data migration process uses two backing stores, the legacy backing store and the new JDBC backing store. However after migration, you'll have one backing store. Use of two backing stores is limited to migration procedures.If you plan to make any schema changes, make them after the backing store data is migrated successfully, following directions in TIBCO BusinessEvents Administration.Task A All VersionsNew TIBCO BusinessEvents metadata tables were added to the backing store schema in version 3.0.1. If you are upgrading from version 3.0.0, you first must upgrade to the latest 3.x version before you migrate data to a JDBC backing store.
2. If the deployed application is running, gracefully shut down all agents and cache servers before you proceed.
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.
Do not remove the JDBC Connection resource for the Oracle-only backing store database from your project until you have completed all migration tasks.
1. Add the JDBC backing store, following instructions in Chapter 15, JDBC Backing Store Setup, which is in TIBCO BusinessEvents Administration.
2. It's a good idea to open your project again in TIBCO BusinessEvents Studioand test both the JDBC connections. If you need to make corrections to the connections, do so before you build the EAR.
3. When you have set up the new backing store, including the JDBC connection and CDD settings, Rebuild the EAR file.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.
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.)
3. You can now start the TIBCO BusinessEvents engine and use the JDBC backing store with the migrated data.When you have tested the migration and are sure that all is working well, you can remove the legacy backing store JDBC connection and archive, or otherwise remove, the legacy backing store files.
Defines the database batch size to be used during the migration process. The best size depends on the database configuration. Defines how many concurrent threads to use during the migration process. Set to the number of processors available. If the existing Oracle backing store contains a large amount of data, the migration process can take many hours to complete. If this is the case, you can shorten the process using this property.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.