jdbc reciever error

[Former Member]

hi,

My scenario is rfc to jdbc.Reciever shows the follwing error.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'TBLTSEMPLOYEES_INTRA' (structure 'StatementName'): java.sql.SQLException: FATAL ERROR document format in structure 'StatementName': expected 'access' tag(s) not found.

Pls help me.

[dharamveer_gaur2 · Accepted solution]

clearly mentioned error

in receiver structure use access tag

your receiver structure should be in format

<StatementName>

<dbTableName action=”INSERT”>

<table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2</col2>

</access>

</dbTableName>

</StatementName>

[Former Member · Accepted solution]

Hi,

My structure is

recevier_DT

StatementName

EMPTABLE

action='INSERT'

access

empno

empname.

I create these for reciever side.Pls help this is perfect r erro.

[prateek · Accepted solution]

Paste ur xml structure here. It would be helpful to ans then. U may get it from message mapping test tab -> source.

Regards,

Prateek

[Former Member · Accepted solution]

HI Ravi,

Have u created the Receiver JDBC structure like in this blog.

And also can you paste the xml format of the Receiver structure...

Regards

Goli Sridhar

[Former Member · Accepted solution]

Hi,

This is my structure.

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID>

</EMPID>

<REASON>

</REASON>

<CATEGORY>

</CATEGORY>

</EMP</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName>

</ns1:mes_emp_info>

Pls help me.

[Former Member · Accepted solution]

hi check wether u have of below format

<root>

  <StatementName1>

<dbTableName action=u201DUPDATEu201D | u201CUPDATE_INSERTu201D>

    <table>realDbTableName</table>

<access>

<col1>val1</col1>

<col2>val2new</col2>

</access>

<key1>

<col2>val2old</col2>

<col4>val4</col4>

</key1>

<key2>

<col2>val2old2</col2>

</key2>

</dbTableName>

  </StatementName1>
<root/>

rgds

srini

[Former Member · Accepted solution]

Hi Ravi,

Check the tag in bold. There is something wrong:

Hi,

This is my structure.

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID>

</EMPID>

<REASON>

</REASON>

<CATEGORY>

</CATEGORY>

</EMP</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName>

</ns1:mes_emp_info>

Regards,

Carlos

[Former Member · Accepted solution]

Hi,

This is your structure.

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID>

</EMPID>

<REASON>

</REASON>

<CATEGORY>

</CATEGORY>

</EMP</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName>

</ns1:mes_emp_info>

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID></EMPID>

<REASON></REASON>

<CATEGORY></CATEGORY>

<EMP></EMP>

</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName>

</ns1:mes_emp_info>

you are missing the tag <EMP> .

Also put some values in the parameters,

like,

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID>001</EMPID>

<REASON>xyz</REASON>

<CATEGORY>abc</CATEGORY>

<EMP>abcdef</EMP>

</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName>

</ns1:mes_emp_info>

The resultant query will be,

insert into TBLTSEMPLOYEES_INTRA values('001','xyz','abc','abcdef')

Assuming all the fields are String type.

Urs,

Soorya.

[Former Member · Accepted solution]

I miss tag in structure.AGAIN I past here.pls help me.

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID>

</EMPID>

<REASON>

</REASON>

<CATEGORY>

</CATEGORY>

</EMP>

</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName></ns1:mes_emp_info>

[Former Member · Accepted solution]

Hi Ravi,

Please check this format,

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID>001</EMPID>

<REASON>xyz</REASON>

<CATEGORY>abc</CATEGORY>

<EMP>abcdef</EMP>

</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName>

</ns1:mes_emp_info>

You are missing <EMP></EMP> in the input file.

PLease check and correct it.

Urs,

SOorya

[dharamveer_gaur2]

Hi

look again bold tag that dont have any open tag

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

<ns1:mes_emp_info xmlns:ns1="http://saphrandhrmas.com">

<StatementName>

<TBLTSEMPLOYEES_INTRA action="INSERT">

<access>

<EMPID>

</EMPID>

<REASON>

</REASON>

<CATEGORY>

</CATEGORY>

</EMP>

</access>

</TBLTSEMPLOYEES_INTRA>

</StatementName></ns1:mes_emp_info>

[dharamveer_gaur2]

Hi

What is </EMP> Node before access check your XML structure again

[Former Member]

Hi Ravi,

It is giving error clearly that you didn't added the 'access' in the Receiver JDBC Structure.

Regards

Goli Sridhar