Adapter : XML Doubt :Help Needed

[Former Member]

Hi

I am trying to modity the sample adpater to work as a custom jdbc adapter. When my adaptyer gets the message it gets it in an XML format :

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

<ns0:mt_jdbcrec xmlns:ns0="urn:flatfile2jdbc">

<STATEMENT>

<MyTest action="INSERT">

<TABLE>TEST_EMP</TABLE>

<access>

<EMPID>c</EMPID>

<EMPNAME>xc</EMPNAME>

<EMPPAGE>xc</EMPPAGE>

<FLAG>xc</FLAG>

</access>

</MyTest>

</STATEMENT>

</ns0:mt_jdbcrec>

To do an insert into my data base I need to know the data type for each field. Is there any way to get the datatype for each field from my incoming message???

Thanks in Advance

Jai

[justin_santhanam]

Jai,

The below statement is little bit confusing,

<i>To do an insert into my data base I need to know the data type for each field. Is there any way to get the datatype for each field from my incoming message???</i>

If you don't mind could you please explain little bit in detail!!

-raj.