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

JDBC format with schema..

43 Views

Hello,

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">

<table>ARIBAUSR.PO_RETURN</table>

- <access>

<MANDT>01</MANDT>

<EBELN>D02</EBELN>

<EBELP>00010</EBELP>

<ACTION_KEY>A</ACTION_KEY>

<CR_DATE>20051212</CR_DATE>

<CR_TIME>12000000</CR_TIME>

<SEQUENCE>1</SEQUENCE>

<TYPE>W</TYPE>

<MSGNR>083</MSGNR>

<MSGID>ME</MSGID>

<FLDNAME>DOC_TYPE</FLDNAME>

<MESSAGE>Enter Document type</MESSAGE>

<SYSID>SR1CLNT545</SYSID>

<MESSAGE_V1>Document type</MESSAGE_V1>

<MESSAGE_V2 />

<MESSAGE_V3 />

<MESSAGE_V4 />

</access>

</PO_RETURN>

</Insert1>

</ns:PO_RETURN_insert>