scenario regarding fetching data from database

[Former Member]

Hi,

i am trying to create a scenario which will have a source file in XML format that contain only the primary key of a table that exists in SQL server. inside IP, a synchronous call is made to JDBC and the records corresponding to the primary key will be fetched and finally will be written to a output file(XML). I need help for designing the IP.

[Former Member · Accepted solution]

Hi,

Choose the Quality of service : "Best effort" in your JDBC receiver communication channel to create synchronous flow.

With receiver JDBC adapter you can use it as Synchronus way.

You need to create the statement with Select as an SQL query along with the primary Key as selection criteria

SAP Network Blog: JDBC Receiver Adapter -- Synchronous Select – Step by Step

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

Thanks

Swarup

[Former Member]

From XI you can send data to database and get the response from JDBC to xi back using these two weblogs:

/people/siva.maranani/blog/2005/09/16/xi-how-to-on-jdbc-receiver-response

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

*******************Reward points,if found useful

[former_member192892]

Hi,

Using java mapping plus JDBC look up will avoid the usage of BPM in this scenario. This would be more performance effective.

[Former Member]

hi,

check the sender side configurtion using below link and receiver should be File

JDBC to JDBC

https://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

Reagards