Skip to Content
0

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

Nov 20, 2017 at 02:04 PM

45

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Andrzej Filusz Nov 20, 2017 at 04:07 PM
0

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thanks Andrzej!

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

0

Hello,

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

Regards,

Andrzej

0