Skip to Content
0
Former Member
Feb 25, 2011 at 10:24 AM

JDBC to JDBC scenario error

35 Views

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>

http://sap.com/xi/TextID">

0b0fdc6840c211e09d490000004d9c8e

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="row">

<xsd:annotation>

http://sap.com/xi/TextID">

7eca0f413fcb11e08a2800270e0eb886

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="NAME" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

7eca6d3e3fcb11e0b9da00270e0eb886

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="ID" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

7eca6d3f3fcb11e0c34f00270e0eb886

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="ADDRESS" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

7eca6d403fcb11e0a4fa00270e0eb886

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="FLAG" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

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>

http://sap.com/xi/TextID">

0b1e084240c211e08a7f0000004d9c8e

</xsd:appinfo>

</xsd:annotation>

<xsd:sequence>

<xsd:element name="STATEMENT">

<xsd:annotation>

http://sap.com/xi/TextID">

81fd5e1d3fdb11e0980b00270e0eb886

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="ROW">

<xsd:annotation>

http://sap.com/xi/TextID">

81fd5e1e3fdb11e0c89000270e0eb886

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="action" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

81fd5e1f3fdb11e0bcea00270e0eb886

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="TABLE" type="xsd:string">

<xsd:annotation>

http://sap.com/xi/TextID">

81fd5e203fdb11e0b15c00270e0eb886

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="access" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

81fd5e213fdb11e0980000270e0eb886

</xsd:appinfo>

</xsd:annotation>

<xsd:complexType>

<xsd:sequence>

<xsd:element name="LIBID" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

81fd5e223fdb11e0c80500270e0eb886

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="LIBNAME" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

81fd5e233fdb11e0baf800270e0eb886

</xsd:appinfo>

</xsd:annotation>

</xsd:element>

<xsd:element name="LIBADDRESS" type="xsd:string" maxOccurs="unbounded">

<xsd:annotation>

http://sap.com/xi/TextID">

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.