JDBC Adapter

[Former Member]

Hi All:

I need to get data from 2 diff table in two message type.

Table1 to MT_1

Table to MT_2

Can I do it by writing two SQL querry in the JDBC adapter? not

How can I achive it.

Thanks

Farooq.

[Former Member]

HI,

Yes as explained by Michal , you would have to use two CC to use sql queries on two jdbcs.

to know more about JDBC ,please see the below links may be useful..

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 - File to JDBC

JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

Regards

Chilla

[prateek]

Hi Farooq,

A very informative discussion

Hope this helps

Regards,

Prateek

[MichalKrawczyk]

Hi,

>>>>Can I do it by writing two SQL querry in the JDBC adapter?

yes you can create two message types that will be two

sql queries

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member]

Hi

Now I am selecting data from both the table by a single querry(based on conditions)--by 1 JDBC sender

for that I need to create one Message type only right? so what wil be the DT/MT fo that.

Table 1

f1

f2

f3

f4

table 2

ff1

ff2

ff3

ff4

in the Sender JDBC Select * from table1 and table2.......

suppose JDBC is giving me..

f1, f2, ff1, ff2,ff3 or All field from both the talble

so how my MT will look

Thanks

Farooq.

[Former Member]

HI,

Better to write a stored procedure and get the exact business requirement data and corresponding stricture should be created in the outbound dt,mt in same squence also.

http://help.sap.com/saphelp_nw2004s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

Regards

Chilla