how to fetch data from two database with a single JDBC synchronous call??

[Former Member]

Hi,

i have created a scenario which fetches data from two database using two JDBC synchornous call. Now i want to fetch data form those databases using a single JDBC synchronous call. How can i do it??

[Former Member]

Hi Pinangshuk,

U will need a JOIN statement in ur SQL query to unite data from two different tables in a SINGLE database..

but about joining two different DB's...im not sure if its possible..

[Former Member]

Hi,

Probabaly you can write Stored Procedure to achieve your requirement.

[http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm|http://help.sap.com/saphelp_nw04/helpdata/en/ae/d03341771b4c0de10000000a1550b0/frameset.htm]

Regards

Bhanu.

[former_member238007]

Hi..

Is it needed to fetch the data from the two tables which reside in a single database or do you need to fetch it from differient databases if it is so then you cann't configure with a single synchronous call to fetch the data from differient databases.

clearly mention ur problem that u are facing..

regards,

Kishore