JDBC error while SELECT

[Werner_Magerl]

Hello,

I have implmented a RFC to JDBC scenario.

But during the call I get the error:

JDBC Message processing failed, due to Error processing request in sax parser: Error when executing statement for table/stored proc. 'cexair.terrores_pb' (structure 'stmt'): java.sql.SQLException: FATAL ERROR in structure 'stmt': SQL queries are not supported in batch mode

When using SQL Client to do the same select statement it works.

My statement in monitoring looks like this:

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

- <ns1:ZSICEX_GET_DATA_TEST_MT xmlns:ns1="http://spares.airbus.com/sicex">

- <stmt>

- <CEXAIR_TERRORES_PB action="SQL_QUERY">

<table>cexair.terrores_pb</table>

<access>select codmen from cexair.terrores_pb where cexair.terrores_pb.codmen = 'S005';</access>

- <key>

<CODMEN>123</CODMEN>

</key>

</CEXAIR_TERRORES_PB>

</stmt>

</ns1:ZSICEX_GET_DATA_TEST_MT>

What does this mean in BATCH MODE????

best regards

WErner

[Former Member · Accepted solution]

Hi

From: http://help.sap.com/saphelp_nwpi711/helpdata/en/44/747eda12dd3676e10000000a114a6b/frameset.htm

Batch processing is not supported for the following statements:

- SELECT

- UPDATE_INSERT

- EXECUTE

- SQL_QUERY

Please remove the flag "Batch Mode" in Receiver JDBC Channel Configuration.

Francesco