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

[former_member541467]

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.

[Andrzej_Filusz · Accepted solution]

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

[former_member541467 · Accepted solution]

Thanks Andrzej!

Yeah, you were right. So it would be same for Update and Insert as well?

[Andrzej_Filusz · Accepted solution]

Hello,

Yes, when you use DELETE, UPDATE or INSERT statements then you should choose action: SQL_DML.

Regards,

Andrzej