JDBC receiver - Update problem

[Former Member]

Hi,

Scenario: JDBC - RFC - JDBC scenario.

1. JDBC to RFC part-

A select statement from the JDBC sender, is mapped to the RFC in the ECC system)

2. RFC response is then mapped to an Update query using a receiver JDBC adapter.

(Please note: Only the RFC is synchronous. JDBC adpter is configured to be aynchronous here.)

3. The scenario is working fine, with regard to XI (All chequered flags.)

Problem: The DB does not get updated.

The response we get from the DB has <update_count> of 0

4. The same query, (taken from XI's audit log) and executed in the DB executes fine.

5. We are using the same user id, to update the table through XI(in the communication channel) and while executing the query manually.

Hence a user permission problem, could be ruled out.

6. DB used is Oracle 8i.

Any hints on what the problem might be?

Thanks,

Smitha.

[MichalKrawczyk · Accepted solution]

Hi,

>>>>3. The scenario is working fine, with regard to XI (All chequered flags.)

Problem: The DB does not get updated.

The response we get from the DB has <update_count> of 0

I guess the easiest way to identify this issue would be to check the DB log in this operation

(not adapter log on XI)

then you will know exactly what is getting executed by the adapter and why it fails

Regards,

michal

[Former Member · Accepted solution]

Hi Michal,

We donot have access to the DB logs.

The DB Administrator, mentions that a DB log is not maintained due to technical/business reasons.

Are there any problems, we would face, in case we use standard DB users, like, scot?

Thanks,

Smitha.

Edited by: Smitha Rao on Jul 15, 2008 11:25 AM