Skip to Content
avatar image
Former Member

JDBCDriverException: SAP DBTech JDBC: SQL statement would generate a row count.

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 20, 2017 at 04:07 PM

    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

    Add comment
    10|10000 characters needed characters exceeded