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