Inserting Data into the Source Table

After starting the adapter configurations, you can insert data into the source table and test the adapter services.

1. Run the following SQL statements or the demo1ins_ora.sql script and commit the inserts.

   SQL> insert into ITEM_TABLE values(111,'Oak Table',499.95);
   SQL> commit;

   Note: You can insert additional data rows if you want to. If you do, ensure that the value of the first column is unique within a table because the first column is a primary key. If the value is not unique, it is inserted into the exceptions table.
2. To verify whether the row in the source table is inserted into the destination table, run the following query SQL statement:
   SQL> select * from SUB_ITEM;
   The following example result confirms that the data has been inserted:

   ITEM_ID
   ----------
   ITEM_DESCRIPTION
   ---------------------------------------------------
   ITEM_PRICE
   -----------
   111
   Oak Table
   499.95

3. Verify the status messages logged for Publication Service.
   Messages similar to the following are displayed in the Console view when Publication Service confirms the data.

   

4. Verify the status messages logged for Subscription Service.
   Messages similar to the following are displayed in the Console view when Subscription Service receives new data.

   

5. To stop both the subscriber and publisher adapters, click the stop button on the top left of the Console view of each running adapter.