Skip to Content
avatar image
Former Member

SOAP, webservice and JAVA

Hi, all,

If there are two different business systems need to exchange data, after sending and receiving messages, they both have to update their database. Do you think directly using JDBC adapter to insert/update each other's tables is a secure and effient way? Or using JAVA/APAB proxy to send out data, then using SOAP adapter to receive the data, and then using Java program to update database is much better? Can anybody provide any sample scenario and Java programs for the later? Any comment will be highly appreciated!

Marea

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 15, 2006 at 02:02 PM

    Hi Marea,

    I am slightly confused with your question... Anyways i have given you all the info regarding JDBC Adapter and how it actually works...

    A JDBC sender adapter has 2 essential fields,

    1. SQL Statement

    2. Update Statement

    Your SQL statement will contain your SELECT statement and once your SQL statement is executed, UPDATE statement is executed. This is done so that records that have been selected by the SQL statement should not be selected again as the JDBC sender adapter will poll over the database for every poll interval.

    If you want to SELECT something from your Database, then you will have to go for a JDBC sender adapter.

    But, if you want to insert/update your Database, then you can go for a JDBC receiver adapter.

    Multiple insertions are possible for a JDBC receiver, but multiple Selection queries (different select queries) are not possible for a single JDBC sender adapter.

    Just check these links to understand how JDBC adapters work,

    If you wanna do update/insert you will have to follow the

    Document" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter

    For Configuring the Receiver JDBC Adapter refer:

    Configuring" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm">Configuring the Receiver JDBC Adapter

    For Configuring the Sender JDBC Adapter refer:

    Configuring" target="_blank">http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm">Configuring the Sender JDBC Adapter

    To access any Database from XI, you will have to install the corresponding Driver on your XI server.

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f1a10

    Or on the JDBC end you can write a stored procedure to make your data update more efficient.

    Go through this blog for stored procedures.

    /people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

    Please go through this blog and see if it helps you.

    /people/prasadbabu.nemalikanti3/blog/2006/02/27/collecting-and-bundling-vendor-records-from-different-multiple-interfaces-file-systempeoplesoft-and-sending-to-sap-r3-system-part-2

    For more info, just take a look at these links also,

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    I would suggest you to go through the following documents for use of JAVA in relation to database.....

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-code-samples/xi%20mapping%20lookups%20rfc%20api.pdf

    /people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

    Please go through the steps mentioned in all of these links.

    Regards,

    Abhy

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi, Abhy,

      Thank you for taking time to provide me some many information. And I am so sorry for making you confuse. I really want a sample scenario which soaps out a message to a webservice. And I want to know how webservice takes care of the message, and how java program processes the message and uses it to update a database. I don't know if I make sense this time. Thank you for asking me again.

      Marea

  • Aug 15, 2006 at 07:19 AM

    Hi Marea,

    >>>> Do you think directly using JDBC adapter to insert/update each other's tables is a secure and effient way?

    Yes, why not. Seems to be much easier than the other way. Synchronous message flow design will be secure (you can be shure that you will notice errors) but may be a bad performance. Asynchronous message flow using acknowledgements (exception branch in BPM) can solve that but this way is not so easy to implement.

    Regards,

    Udo

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks Udo!

      Is there anybody can provide any sample scenario and Java programs for SOAP receiver and JAVA program to update database? Or provide links I can learn? Thanks!

      Marea