Skip to Content
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: image ** ** 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. ** image 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 image 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: image
To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Natalia Maslova
    Dear YiNing Mao,

    Thank you very much for your blog!
    Your blog is very understandable, brevity, powerful and useful! I understand how to set and use Sender JDBC Adapter. Excellent work!

    But little misprint: in part Configure Time in first item (in SQL Statements) must be READFLAG instead of READ_FLAG.

    Thanks a lot!
    With the best regards,
    Natalia Maslova
    n.maslova@b-retail.com.ua

    (0) 
  2. Natalia Maslova
    Dear YiNing Mao,

    Thank you very much for your blog!
    Your blog is very understandable, summary, powerful and useful! I understand how to set and use Sender JDBC Adapter. Excellent work!

    But little misprint: in part Configuration Time in item 1 (in SQL Statements) must be READFLAG instead of READ_FLAG.

    Thanks a lot!
    With the best regards,
    Natalia Maslova.
    n.maslova@b-retail.com.ua

    (0) 
  3. Julián Carmona
    Hi,

    I configure the sender adapter with serializable and  appear this error:

    The JDBC driver returned the following error message: ‘java.sql.SQLException: ORA-08177: can’t serialize access for this transaction ‘. For details, contact your database server vendor.

    (0) 

Leave a Reply