Column Type name name Length Nulls ------------------------------ ------------------ -------- ----- ID CHARACTER 10 No NAME CHARACTER 10 No BIRTHYEAR CHARACTER 4 No BIRTHMONTH CHARACTER 2 No READFLAG INTEGER 4 No 2. Insert some rows into the table t_student:ID NAME BIRTHYEAR BIRTHMONTH READFLAG ---------- ---------- --------- ---------- ----------- 0000000001 YiNing 2006 12 0 0000000002 MinMing 2006 12 0 3. Create namespace "urn:jdbcTestByYining" in the software component of Integration Repository. 4. Create Data Type DT_Student_Info_Outbound and DT_Student_Info_Inbound: 
** ** The subelements under "row" should be as the same as the column names of the database table. ** ** Since XML is case-sensitive, make sure "row" is in lowercase and it's subelement is exactly as the same as the column names of the database table. ** 
5. Create relevant Message Types MT_Student_Info_Outbound and MT_Student_Info_Inbound. 6. Create relevant Message Interfaces MI_Student_Info_Outbound and MI_Student_Info_Inbound. 7. Create Message Mapping Object MM_Student_Info 
8. Create relevant Interface Mapping Object IM_Student_Info. h5. Configure Time 1. Create a Communication Channel for Sender 0.1. 0.2. Adapter Settings 0.1. 0.2. Choose the "JDBC" as the Adapter Type. 0.3. 0.4. Choose "JDBC 2.0" as the Transport Protocal 0.5. 0.6. Choose "Integration Server" as the Adapter Engine 0.7. 0.3. 0.4. Database Connection Settings Information for this Setting is determined when configuring the JDBC Adapter after installation 0.5. 0.6. Processing Parameters Settings 0.1. 0.2. Quality of Service: Choose "Exactly Once" for asynchronous processing 0.3. 0.4. Poll Interval(secs): 5 0.5. 0.6. Query SQL Statement: SELECT * FROM t_student WHERE READ_FLAG=0 0.7. 0.8. Document Name: MT_Student_Info_Outbound 0.9. 0.10. Document Namespace: urn:jdbcTestByYining 0.11. 0.12. Update SQL Statement: UPDATE t_student set READ_FLAG=1 WHERE READ_FLAG=0 0.13. 0.7. 0.8. Check "Advanced Mode", choose "Serializable" for "Database Transaction Level". 0.9. 2. Create a Communication Channel for Receiver 3. Create Sender Agreement 4. Create Interface Determination 5. Create Receiver Agreement 6. Create Receiver Determination Mapping result: 
** ** The subelements under "row" should be as the same as the column names of the database table. ** ** Since XML is case-sensitive, make sure "row" is in lowercase and it's subelement is exactly as the same as the column names of the database table. ** 5. Create relevant Message Types MT_Student_Info_Outbound and MT_Student_Info_Inbound. 6. Create relevant Message Interfaces MI_Student_Info_Outbound and MI_Student_Info_Inbound. 7. Create Message Mapping Object MM_Student_Info 8. Create relevant Interface Mapping Object IM_Student_Info. h5. Configure Time 1. Create a Communication Channel for Sender 0.1. 0.2. Adapter Settings 0.1. 0.2. Choose the "JDBC" as the Adapter Type. 0.3. 0.4. Choose "JDBC 2.0" as the Transport Protocal 0.5. 0.6. Choose "Integration Server" as the Adapter Engine 0.7. 0.3. 0.4. Database Connection Settings Information for this Setting is determined when configuring the JDBC Adapter after installation 0.5. 0.6. Processing Parameters Settings 0.1. 0.2. Quality of Service: Choose "Exactly Once" for asynchronous processing 0.3. 0.4. Poll Interval(secs): 5 0.5. 0.6. Query SQL Statement: SELECT * FROM t_student WHERE READ_FLAG=0 0.7. 0.8. Document Name: MT_Student_Info_Outbound 0.9. 0.10. Document Namespace: urn:jdbcTestByYining 0.11. 0.12. Update SQL Statement: UPDATE t_student set READ_FLAG=1 WHERE READ_FLAG=0 0.13. 0.7. 0.8. Check "Advanced Mode", choose "Serializable" for "Database Transaction Level". 0.9. 2. Create a Communication Channel for Receiver 3. Create Sender Agreement 4. Create Interface Determination 5. Create Receiver Agreement 6. Create Receiver Determination Mapping result:
6 Comments
