configuring reciever JDBC adapter

[Former Member]

while configuring reciever jdbc adapter.i have defined sql statement ('SELECT') to query the database in canonical xml structure . where can i specify the location in which target xml file is to be created?

[Former Member · Accepted solution]

Hi kaushik

may this weblog will help you in configuring jdbc reciever

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

cheers

Piyush

[Former Member · Accepted solution]

Hi Kausic,

Refer this weblog for configuring synchronous JDBC receiver.

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

Regards

Anand

[Former Member]

Hi,

You need to map the response from the db to be put into a file rite???

For this create a data type and msg type which are of the same name(eg: <i>something</i>_response) for the response part.Create a new channel for the file and specify the target directory.

good Luck!!

Priyanka

[Former Member]

Hi Kausik

This is webblog giving information about response from database.

Scenario is http client request (query) database through xi and database response back to http client.

It seems it will put response at sender location for file adapater.

Request

Sender--

---

File adapter-XI-----JDBC adapter—DB

Response

Db--

---

JdbcXI

---

File--

---

Sender location

Another object you have to define with following scenario

Sender location--file---xi--

---

file Target location.

I think you will get output at desired location.

Cheers

Piyush