JDBC Receiver

[Former Member]

Hi,

I have a doubt about the JDBC receiver adapter.In the communication channel of the receiver JDBC where is it that i have to specify the INSERT statementso the values coming from the sender goes to the required table in the database.

Thanks and Regards,

Jishi

[Former Member]

Hi Jishi,

When we use receiver JDBC adapter, we create the data type in such a way that it designates the query that we wish to execute.

We don't have to give any parameter at the time of configuration.

Also please go through the link that michal has provided.

There in <b>action</b> attribute we usually map it with Insert_Update

Thanks & Regards,

Varun Joshi

[Former Member]

Hi Varun,

Thanks for the reply,But i am not able to find the action attribute in the receiver adapter communication channel.

Thanks and Regards,

Jishi

[Former Member]

Just go thru the blog which i had given in which u will knoe how to make data type of recvier side.

When we make data type for Reciever side we will make <b>action</b> attribute there and then assign a value to this attribute like insert,insert_update,select.

[Former Member]

Hi

Go thru this blog

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

Hope it helps

Regards

Arpit Seth

[MichalKrawczyk]

Hi,

take a look at this:

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

if help.sap.com doesn't work try this:

http://216.239.59.104/search?q=cache:QHOELxYkEtQJ:help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d1...receiverjdbcadapter&hl=pl

BTw

you specify the Insert statement in <b>action</b> attribute

Regards,

michal

Message was edited by: Michal Krawczyk