Hi techies,
I am trying out the scenario JDBC to JDBC.
I have mapped the
CC_JDBC_SENDER
Data Base Connection
JDBC Driver oracle.jdbc.driver.OracleDriver
Connection jdbc:oracle:thin:@<<ip>>:<<port>>:<<hostname>>
User Name kiran
Passowrd *****
Processing parameters
Query SQL Statement SELECT * FROM STUDENT WHERE FLAG = 'TRUE'
Document DBExtract
Update SQL statement UPDATE STUDENT SET FLAG = 'FALSE' WHERE FLAG ='TRUE'
CC_JDBC_RECIVER
Standard configuration
Mapping
Sender
<?xml version="1.0" encoding="ISO-8859-1"?>
http://www.w3.org/2001/XMLSchema" xmlns="http://jdbc_2_jdbc" targetNamespace="http://jdbc_2_jdbc">
<xsd:element name="mt_sender" type="dt_sender" />
<xsd:complexType name="dt_sender">
<xsd:annotation>
0b0fdc6840c211e09d490000004d9c8e
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="row">
<xsd:annotation>
7eca0f413fcb11e08a2800270e0eb886
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="NAME" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
7eca6d3e3fcb11e0b9da00270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="ID" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
7eca6d3f3fcb11e0c34f00270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="ADDRESS" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
7eca6d403fcb11e0a4fa00270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="FLAG" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
7eca6d413fcb11e0a72300270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
Reciver
<?xml version="1.0" encoding="ISO-8859-1"?>
http://www.w3.org/2001/XMLSchema" xmlns="http://jdbc_2_jdbc" targetNamespace="http://jdbc_2_jdbc">
<xsd:element name="mt_reciver" type="dt_reciver" />
<xsd:complexType name="dt_reciver">
<xsd:annotation>
0b1e084240c211e08a7f0000004d9c8e
</xsd:appinfo>
</xsd:annotation>
<xsd:sequence>
<xsd:element name="STATEMENT">
<xsd:annotation>
81fd5e1d3fdb11e0980b00270e0eb886
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ROW">
<xsd:annotation>
81fd5e1e3fdb11e0c89000270e0eb886
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="action" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
81fd5e1f3fdb11e0bcea00270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="TABLE" type="xsd:string">
<xsd:annotation>
81fd5e203fdb11e0b15c00270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="access" maxOccurs="unbounded">
<xsd:annotation>
81fd5e213fdb11e0980000270e0eb886
</xsd:appinfo>
</xsd:annotation>
<xsd:complexType>
<xsd:sequence>
<xsd:element name="LIBID" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
81fd5e223fdb11e0c80500270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="LIBNAME" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
81fd5e233fdb11e0baf800270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="LIBADDRESS" type="xsd:string" maxOccurs="unbounded">
<xsd:annotation>
81fd5e243fdb11e0838400270e0eb886
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:schema>
Sender communication channel is working fine and I am able to access data from Oracle. And also I am able to change the flag status to false.
At receiver end I am having this error
com.sap.aii.utilxi.misc.api.BaseRuntimeException thrown during application mapping com/sap/xi/tf/_mm_mapping_: RuntimeException in Message-Mapping transformatio~
Exception of class CX_XMS_SYSERR_MAPPING.