on 2010 Nov 15 5:41 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.