Search code examples
oracleautomationjmeter

Script in Oracle unsuccessful in execution - Jmeter

I have the following situation:

I want to run scripts in Oracle, using JDBC Request in Jmeter. The connection configuration is now ok.

When I run the script, I get an error. And a detail: The same script within PL/SQL is successfully executed. Error: "java.sql.SQLSyntaxErrorException: ORA-00911: invalid character".

Does anyone know why?

Script:

SELECT *FROM TBJDALRT_ALERTA_TP;

Prints below (script and error).

enter image description here

enter image description here

Thank you!

Solution

  • Remove ; from your statement. Executing several SQL statements in one JDBC Request sampler is not supported, you either need to switch to JSR223 Sampler and Groovy language and invoke Statement.executeBatch() function or go for 2 separate JDBC Request samplers.

    More information: Apache Groovy - Working with a relational database