java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; exception thrown upon runnin-CodePudding

I am trying to execute below SQL statements after running the JMeter test plan. But it is always throwing me the exception mentioned in the title of this post.

delete from
  request
where
  user_id = 9000;

update
  s_session
set
  total_hours_used = 0
where
  user_id = 9000;

I tested these queries in MySQL workbench but they are executing correctly. What could be the cause of this problem?

CodePudding user response：

One statement - one PostProcessor, you can only run a single SQL Statement with JMeter's JDBC Test Element given you use Update statement.

If you need to run 2 queries at once consider coming up with a relevant stored procedure and invoke it using Callable statement.

More information: Using JDBC Sampler in JMeter