on 11-27-2008 2:44 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.