S.V S.V - 3 years ago 206
SQL Question

Jmeter java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

I am trying to delete a record from my database using Jmeter and I am having some difficulties. I can query just fine, but when it comes to DELETE, I am getting an error. I enter the following code in my Jmeter:

delete from DATA_RECORDS where DATA_RECORDS_ID = (select id from DATA_RECORDS_STORE where RESOURCE_IDENTIFIER='somevalue');

delete from DATA_RECORDS_STORE where RESOURCE_IDENTIFIER='somevalue';


After running the test in Jmeter I get the following error:


java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended


However when I enter that same code in my SQLDeveloper, SQL actually runs the script and it deletes the appropriate data.

The Query Type is set to: Update Statement and I have nothing in the remaining fields: Parameter values, Parameter types, Variable names, etc. I would also like to mention that I am running Jmeter 3.2 GUI mode. If you could help me out that would greatly be appreciated. Thanks!

Answer Source

Separate to 2 jdbc requests:

 delete from DATA_RECORDS where DATA_RECORDS_ID = (select id from DATA_RECORDS_STORE where RESOURCE_IDENTIFIER='somevalue')


  delete from DATA_RECORDS_STORE where RESOURCE_IDENTIFIER='somevalue'
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download