JDBC reciver error - urgent

[Former Member]

Hi All,

I am using the JDBC receiver to insert data into Microsoft access but I am encountering the following error though my JDBC structure and connection to the database is proper.

Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'BRS' (structure 'FLIGHT'): java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

Following is payload message.

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

- <ns0:AIP_MT_Flight_BRS xmlns:ns0="http://receiver_interfaces.com">

- <FLIGHT>

- <STATEMENT ACTION="INSERT">

<TABLE>BRS</TABLE>

- <ACCESS>

<MessageName>FLIGHT</MessageName>

<ActionType>U</ActionType>

<Origin>UFIS</Origin>

<Version>1</Version>

<SDATE>20080209</SDATE>

<STIME>063000</STIME>

<FLNB>S2 611</FLNB>

<FLDIR>A</FLDIR>

<TERMINAL>1</TERMINAL>

</ACCESS>

</STATEMENT>

</FLIGHT>

</ns0:AIP_MT_Flight_BRS>

Please help on this.

Thanks in advance.

Best Regards,

Sugeet Patinge.

[Former Member]

Hello ,

Check this thread....

*******Please reward points,if found useful

[Former Member]

Hi,

Check this webpage : http://support.microsoft.com/kb/175168

Though it is not related to XI or SAP, it gives possible reasons for such error msg (permission, write mode, etc). With your dba, you should be able to check that all conditions are met to insert rows in your table

Hope this helps

Chris

Sugeet,

PS: you can set the logSQLStatement to true in the advanced properties of your JDBC adapter, then you will see the actual statement using Message Display tool in the audit log section

Edited by: Christophe PFERTZEL on May 2, 2008 12:43 PM

[Former Member]

>Error when executing statement for table/stored proc. 'BRS' (structure 'FLIGHT'): java.sql.SQLException: >MicrosoftODBC Microsoft Access Driver Operation must use an updateable query.

Put EXECUTE under ACTION instead of INSERT.

[prateek]

Compare the same payload with the output of Test tab in message mapping. Are u using stored proc? If yes, then ur action should be "Execute"

Regards,

Prateek

[Former Member]

HI Sugeet

Check out This Thread

url[ JDBC Receiver Adapter |;

This may helps u

[Former Member]

hi

use the exact message struct

<YourMsgType>

<StatementName>

<storedProcedureName action=” EXECUTE”>

<table>realStoredProcedureeName</table>

<param1 [isInput=”true”] [isOutput=true] type=SQLDatatype>val1</param1>

</storedProcedureName >

</StatementName>

</YourMsgType>

Response message struct must be

<YourMsgType_response>

<StatementName_response>

....

rgds,

Arun