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(1,'Mickey Mouse',12.12);
   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 rows in the source table are inserted into the destination table, execute 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
   -----------
   1
   Mickey Mouse
   12.12

3. Verify the status messages logged for Publication Service.
   Messages similar to the following example 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 example 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.