Problem in the receiver JDBC channel

[chitti_prakash]

hi,

I am facing some problem with the receiver JDBC channel which is trying to insert some data in ORACLE DB. My sample input XML file is,

<root>

<statement>

<table>EBILL_CUST_STATE_AGE_HDR2</table>

<CUST_CODE>BA001</CUST_CODE>

<CUST_ADDR>Rental Customer Name 1+Name 2street01+TEL: 0331694100

FAX:0331694103</CUST_ADDR>

<CRD_LMT>1000000.00</CRD_LMT>

<BG_AMT>1000000.00</BG_AMT>

</statement>

</root>

Error stack is,

Exception caught when executing statement for table/stored proc. 'EBILL_CUST_STATE_AGE_HDR2' (structure 'Statement_CUST_STATE_AGE_HDR2'):

java.sql.SQLException: ORA-00917: missing comma

Please help me in solving the issue ASAP.

Thanks,

Soorya

[prateek · Accepted solution]

You have to add "access"> node also before column names. See this.

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/frameset.htm

Regards,

Prateek

[chitti_prakash · Accepted solution]

Hi,

It is included. It looks like this,

<root>

<statement>

<table>EBILL_CUST_STATE_AGE_HDR2</table>

<access>

<CUST_CODE>BA001</CUST_CODE>

<CUST_ADDR>Rental Customer Name 1+Name 2street01+TEL: 0331694100

FAX:0331694103 </CUST_ADDR>

<CRD_LMT>1000000.00</CRD_LMT>

<BG_AMT>1000000.00</BG_AMT>

</access>

</statement>

</root>

.

Thanks,

Soorya

[Former Member]

Hi,

It works like this

<ROOT>

<STATEMENT>

<TABLENAME ACTION="INSERT">

<TABLE>EBILL_CUST_STATE_AGE_HDR2</TABLE>

<ACCESS>

<CUST_CODE>BA001</CUST_CODE>

<CUST_ADDR>Rental Customer Name 1+Name 2street01+TEL: 0331694100

FAX:0331694103</CUST_ADDR>

<CRD_LMT>1000000.00</CRD_LMT>

<BG_AMT>1000000.00</BG_AMT>

</ACCESS>

</TABLENAME>

</STATEMENT>

</ROOT>

Please refer the link.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/ae/d03341771b4c0de10000000a1550b0/frameset.htm

Abid Mazhar

[chitti_prakash]

Hi,

Even though if i give the input file as,

<root>

<StatementName1>

<dbTableName action="INSERT">

<table>EMPLOYEE</table>

<access>

<NAME>Rental Customer Name 1+Name 2street01+TEL: 0331694100 FAX:

0331694103</NAME>

<ID>295</ID>

<FLAG>NO</FLAG>

</access>

</dbTableName>

</StatementName1>

</root>

Still the issue occurs,

Please help me.

Thanks,

Soorya

[former_member200962]

<root>
<statement>
<table>EBILL_CUST_STATE_AGE_HDR2</table>
<access>
<CUST_CODE>BA001</CUST_CODE> 
<CUST_ADDR>Rental Customer Name 1++Name 2++street01++TEL: 0331694100 
FAX:0331694103 </CUST_ADDR> 
<CRD_LMT>1000000.00</CRD_LMT> 
<BG_AMT>1000000.00</BG_AMT> 
</access>
</statement>
</root>

Attribute Action is missing.....you need to create the structure accordingly only making a change in XML wont work.....your structure itself is not according to the standard JDBC receiver format.

Regards,

Abhishek.

[Former Member]

Hi,

what's the error?

Abid