FILE to JDBC error

[former_member460664]

I got following error while doing FILE to JDBC scenario.

Message processing failed. Cause: com.sap.engine.interfaces.messaging.api.exception.MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'example' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'example'.

Error processing request in sax parser: Error when executing statement for table/stored proc. 'example' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'example'.

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'example' (structure 'StatementName'): com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'example'.

My receiver structure is.....

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

- <ns0:mt_jdbcreceiver xmlns:ns0="urn:filetojdbc">

- <StatementName>

- <test action="INSERT">

<TABLE>example</TABLE>

- <access>

<Name>xxx</Name>

<Address>xxx</Address>

<Telephone>xxx</Telephone>

<FLAG>x</FLAG>

</access>

</test>

</StatementName>

</ns0:mt_jdbcreceiver>

Please help me.

Thanks in advance.

[former_member192238]

Ashok,

Check with your DB team whether the table 'example' exsist or not also.

Regards

Praveen

[MichalKrawczyk]

Hi,

>>>Error when executing statement for table/stored proc. 'example

this means that there's not table with a name "example" on your database

so the statement cannot work,

put the correct table name and it will start working,

Regards,

Michal Krawczyk

[former_member460664]

could you please explain receiver jdbc structure and how to map all elements in that structure...

Thanking you

[MichalKrawczyk]

hi,

no

as there are too many blogs on that on SDN already - please have a look at them first,

Thank you,

Regards,

Michal Krawczyk