Skip to Content
0
Nov 15, 2010 at 05:41 PM

JDBC error while SELECT

61 Views

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" ?>

- 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