on 11-20-2017 2:04 PM
Hello experts,
I have REST to JDBC connection for deletion. Deletion query is written in mapping and coming as DELETE from IPAC.IPAC_BEACON_CONTROL WHERE MINOR_ID = "5" which looks alright to me.
But when it gets to JDBC, it throws the error below. any leads? there are not much blogs on deletion query.
MessagingException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'dbTableName' (structure 'Statement'): com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: SQL statement would generate a row count.
Hello,
What value did you put into your action? The error message suggests that it's "SQL_QUERY". Am I right? But you want to execute the delete statement so your action should be 'SQL_DML' (as it's the SQL Data Manipulation Language).
Regards,
Andrzej
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.