jdbc receiver adapter

[Former Member]

Hi all,

I want to insert data into two tables and want to get data from one of those tables(using SELECT in the attribute 'action') after they are inserted with the data.

So how should be my receiver jdbc datatype structure.

Can anybody please tell me?

Thanks & Regards

Radhika.

[Former Member]

Hi radhika

just check my above mention URL for Sendor

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

[Former Member]

Check this blog for Synhronous select of data froma Database,

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

/people/jegathees.waran/blog/2007/03/02/oracle-table-functions-and-jdbc-sender-adapter

Please see the below URL for logic.

http://www.flickr.com/photos/8764045@N06/549186611/

http://www.flickr.com/photos/8764045@N06/549186651/

hope it will help u ..

[Former Member]

hi

Can u pl elaborate a bit more.also tell me what data base u are using.what database that server is using.u and the server using diff. we need to deploy that jdbc drivers to server.check in the link http://<host name>:<abap http port>/AdapterFrameWork.

regards

ajai

[Former Member]

Hi,

Refer this 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

Regards,

vasanth

[former_member192892]

Hi radhika,

Can u pl elaborate a bit more. I mean are u inserting into the tables using XI??

[Former Member]

Hi,

Iam using a sender jdbc adapter to insert int o2 tables.

[former_member192892]

Hi radhika, If you are using ms sql you can create an insert trigger to do a required select * query.

For eg when you perform an insert query in your sender adapter, this trigger query will be executed an you'll get the corresponding resultset from the trigger as your message from the adapter..

Thanks

Varun