cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC

Former Member
0 Kudos

I am inserting rows into a database from an r/3 system. and I want to know how many rows got inserted into a database and how can I achieve that?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Mohan,

A JDBC sender adapter has 2 essential fields,

1. SQL Statement

2. Update Statement

Your SQL statement will contain your SELECT statement and once your SQL statement is executed, UPDATE statement is executed. This is done so that records that have been selected by the SQL statement should not be selected again as the JDBC sender adapter will poll over the database for every poll interval.

If you want to SELECT something from your Database, then you will have to go for a JDBC sender adapter.

But, if you want to insert/update your Database, then you can go for a JDBC receiver adapter.

Multiple insertions are possible for a JDBC receiver, but multiple Selection queries (different select queries) are not possible for a single JDBC sender adapter.

Just check these links to understand how JDBC adapters work,

If you wanna do update/insert you will have to follow the

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm">Document Formats for the Receiver JDBC Adapter</a>

For Configuring the Receiver JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm">Configuring the Receiver JDBC Adapter</a>

For Configuring the Sender JDBC Adapter refer:

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm">Configuring the Sender JDBC Adapter</a>

Please go through this blog and see if it helps you.

/people/prasadbabu.nemalikanti3/blog/2006/02/27/collecting-and-bundling-vendor-records-from-different-multiple-interfaces-file-systempeoplesoft-and-sending-to-sap-r3-system-part-2

For more info, just take a look at these links also,

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

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

Please go through the steps mentioned in these links, compare it with what you have done and see if it helps you solve your problem.

Regards,

Abhy

Message was edited by: Abhy Thomas

former_member187339
Active Contributor
0 Kudos

Hi,

Create a scenario RFC(sync/async) -> XI -> JDBC(sync). In XI you can go for BPM also. The response from JDBC will contain the number of rows effected.

Regards

Suraj

Former Member
0 Kudos

Hi Suraj,

In my scenario I am having Syn. RFC sending data to JDBC. I want to get no. of rows updated in DATABASE.Can u please tell me what will be the steps used in BPM to receive the JDBC response.

Or If i am not using BPM where shoul i map the response.

Regards,

Keith.

former_member187339
Active Contributor
0 Kudos

Hi,

Go thru the thread given in my previous reply.

A synchrounous JDBC adapter call will return the number of rows affected.

If you are trying an INSERTION, then it will return the number of rows in which it is inserted.

If you are doinf an INSERT|UPDATE, it wil return number of insertions and also number of updations.

I would suggest that you read this cooments section of this documentation ,

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

>>If i am not using BPM where should i map the response

to the response of RFC (ie. rfc.response)

Regards

Suraj

Former Member
0 Kudos

Hi Mohan,

I am working on similar scenario, I think following link might be helpful for u.

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm">http://help.sap.com/saphelp_nw2004s/helpdata/en/4d/8c103e05df2e4b95cbcc68fed61705/frameset.htm</a>

Regards.