Message 'Operation must use an updateable query.' while using JDBC_ODBC

[danilo_adam]

Hi all,

i've read the both blogs about using the JDBC-Adaptor for writing data into an MS Access DB. Now, i'm tying to implement such a scenario but have problems with an unexpected error messsage of my JDBC-Adaptor:

Configured at 17:02:25 2006-06-23
Last message processing started 17:18:19 2006-06-23, Error: TransformException error in xml processor class, rollback: 
Error processing request in sax parser: Error when executing statement for table/stored proc. 'Tabelle1': java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query. 
at com.sap.aii.adapter.jdbc.xml2sql.service(xml2sql.java:230) 
at com.sap.aii.adapter.jdbc.XI2JDBC.onInternalMessage(XI2JDBC.java:390) 
at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter_i(SapAdapterServiceFrameImpl.java:173) 
at com.sap.aii.adapter.jdbc.SapAdapterServiceFrameImpl.callSapAdapter(SapAdapterServiceFrameImpl.java:149) 
at com.sap.aii.af.modules.CallAdapterWithMessageBean.process_receiver(CallAdapterWithMessageBean.java:204) 
at com.sap.aii.af.modules.CallAdapterWithMessageBean.process(CallAdapterWithMessageBean.java:159) 
at com.sap.aii.af.mp.module.ModuleLocalLocalObjectImpl1.process(ModuleLocalLocalObjectImpl1.java:103) 
at com.sap.aii.af.mp.ejb.ModuleProcessorBean.process(ModuleProcessorBean.java:227) 
at com.sap.aii.af.mp.processor.ModuleProcessorLocalLocalObjectImpl0.process(ModuleProcessorLocalLocalObjectImpl0.java:103) 
at com.sap.aii.af.listener.AFWListenerBean.onMessage(AFWListenerBean.java:241) 
at com.sap.aii.af.listener.AFWListenerLocalObjectImpl0.onMessage(AFWListenerLocalObjectImpl0.java:103) 
at com.sap.aii.af.ra.ms.impl.ServicesImpl.deliver(ServicesImpl.java:282) 
at com.sap.aii.adapter.xi.ms.XIEventHandler.onDeliver(XIEventHandler.java:742) 
at com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.invokeHandler(ReceiveConsumer.java:385) 
at com.sap.aii.af.ra.ms.impl.core.queue.ReceiveConsumer.onMessage(ReceiveConsumer.java:100) 
at com.sap.aii.af.ra.ms.impl.core.queue.Queue.run(Queue.java:447) 
at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37) 
at java.security.AccessController.doPrivileged(Native Method) 
at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:95) 
at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:159)

In my oppinion the XML-Request message looks fine:

<?xml version="1.0" encoding="UTF-8"?>
<ns:MT_JDBC_ACCESS_RECEIVER xmlns:ns="http://gisa.de/xi/jdbc-to-msaccess-example">
<STATEMENT>
  <TEST action="insert">
    <TABLE>Tabelle1</TABLE>
      <access>
        <Feld1>1</Feld1>
        <Feld2>String</Feld2>
        <Feld3>Memo</Feld3>
    </access>
  </TEST>
</STATEMENT>
</ns:MT_JDBC_ACCESS_RECEIVER>

I tried also an update and an update_insert query with the same error message.

Does someone know where the problem is?

Best regards,

Danilo

[moorthy]

Hi,

Is your JDBC Adapter configuration is correct ? Check this -

And is your table name is TEST ? just wanted to confirm.. based on the xml structure..

REgards,

Moorthy

[danilo_adam]

Hi Moorthy,

i checked the threads but didn't found new information. My Adapter is working without DSN and the connection seems to be established. The message 'Operation not implemented' as described in the second thread is reconstructable by changing the transactionisolation.

Unfortunely all other options generate my error message.

So after a restart of the Adapter everything is green and no failure appears.

My table name ist 'Tabelle1'. TEST is just someting like a statement identification?!

Regards,

Danilo

[Former Member]

Hi Danilo,

Try giving the action attribute as INSERT. Your exception points that operation is not determined.Check whether this option works.You can also try giving UPDATE_INSERT as action.

Regards,

Sudharshan

[danilo_adam]

Hi Sudharshan,

i tried both options for the action attribute without success. The Adapter monitoring gives me the same message:

<i>Last message processing started 08:12:54 2006-06-26, Error: TransformException error in xml processor class, rollback:

Error processing request in sax parser: Error when executing statement for table/stored proc. 'Tabelle1': java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.</i>

Are there any known problems or dependencies/restrictions to the MS Access Version?

Regards,

Danilo