Skip to Content
Former Member
Apr 13, 2005 at 04:51 PM

JDBC format with schema..



I'm attempting to insert into a table using the JDBC adapter and I need to specify the schema. Below is the format of my resulting xml mapped to insert into the table.

1. Am I missing something to make it specify ARIBAUSR.PO_RETURN as the table as opposed to just PO_RETURN? I'm using a different user for the JDBC connection in the adapter.

2. Is there somewhere I can look inside XI to see if this is really a SQL/database error? In the monitoring tool, it says it was successful everywhere I look. Only there's no insert into my table. I have tried to run a mannual SQL insert with the data in this file and it works perfectly.

<?xml version="1.0" encoding="UTF-8" ?>

- <ns:PO_RETURN_insert xmlns:ns="urn:test_sap-ariba-PO:staging">

- <Insert1>

- <PO_RETURN action="INSERT">


- <access>












<MESSAGE>Enter Document type</MESSAGE>


<MESSAGE_V1>Document type</MESSAGE_V1>