cancel
Showing results for 
Search instead for 
Did you mean: 

insert using sender jdbc adapter

Former Member
0 Kudos

Dear Experts,

Is it possible to insert into database using sender jdbc ? we need to get the response from a webservice back to the sender jdbc. it is a jdbc to soap synch scenario ..

Thanks,

Aju

Accepted Solutions (0)

Answers (4)

Answers (4)

dharamveer_gaur2
Active Contributor
0 Kudos

Hi

Is it possible to insert into database using sender jdbc?

If you are talking about JDBC-XI-SOAP scenario then JDBC sender is used for select data from database. After selecting data using JDBC sender if you want to send it to another database then use JDBC receiver instead of

SOAP receiver.

You can get response from JDBC receiver adapter and can capture response in file.JDBC sender can not capture response due to Async behaviour.

If you want to use JDBC-XI-SOAP then can capture response in a file.

prateek
Active Contributor
0 Kudos

If the amount of data to be retrieved from web sevrice is less, then you may create JDBC to JDBC scenario with SOAP lookup. Otherwise you will have to use BPM with Sync-Async bridge concept. However, your receiver would also be sync in this case.

Regards,

Prateek

pedro_baroni3
Active Contributor
0 Kudos

Hi Aju,

Solution A: Use BPM

1 - JDBC Sender Async

2 - SOAP Receiver Sync

3 - JDBC Receiver Async

See Threads:

Solution B: JDBC to JDBC Asynchronous

JDBC Sender

SOAP call in Mapping

JDBC Receiver

See Blog:

Webservice Calls From a User Defined Function.

Former Member
0 Kudos

Hi,

Have a look here.

http://help.sap.com/saphelp_nw04s/helpdata/en/22/b4d13b633f7748b4d34f3191529946/frameset.htm

Query SQL Statement

You have the following options:

· Specify a valid SQL SELECT statement to select the data to be sent from the specified database.

· Specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.

The expression must correspond to the SQL variant supported by the relevant JDBC driver. It can also contain table JOINs.

Update SQL Statement

You have the following options:

· Enter a valid SQL statement that is to be applied to the database once the data (determined from the Query SQL Statement) has been successfully sent to the Integration Server/PCK.

It must be an INSERT, UPDATE, or DELETE statement.

· In place of the SQL statement, you can also enter . Once the data determined from Query SQL Statement has been successfully sent, the data in the database remains unaltered.

This is recommended if the data has not only been read, but also changed by a stored procedure entered under Query SQL Statement.

Edited by: Arman Eker on Nov 27, 2008 3:51 PM