false true ../lib/opt/hsqldb-2.4.0.jar false 5000 dbConfig jdbc:hsqldb:mem:mymemdb org.hsqldb.jdbc.JDBCDriver true 1 10000 DEFAULT 60000 SA continue false 1 1 1 1505666719000 1505666719000 false dbConfig drop PROCEDURE new_user IF EXISTS; Update Statement Store as String 0 updates Assertion.response_data false 16 dbConfig drop PROCEDURE get_users IF EXISTS; Update Statement Store as String 0 updates Assertion.response_data false 16 dbConfig drop table USERS IF EXISTS; Update Statement Store as String 0 updates Assertion.response_data false 16 dbConfig create table IF NOT EXISTS USERS ( id INT IDENTITY NOT NULL, title VARCHAR(50) NOT NULL, author VARCHAR(20) NOT NULL, submission_date DATE, PRIMARY KEY (id) ); Update Statement Store as String 0 updates Assertion.response_data false 16 dbConfig CREATE PROCEDURE new_user(title VARCHAR(50), author VARCHAR(50)) MODIFIES SQL DATA DYNAMIC RESULT SETS 1 BEGIN ATOMIC DECLARE result CURSOR FOR SELECT * FROM USERS WHERE ID = IDENTITY(); INSERT INTO USERS VALUES (DEFAULT, title, author, CURRENT_DATE); OPEN result; END ; Update Statement Store as String 0 updates Assertion.response_data false 16 dbConfig CREATE PROCEDURE get_users() MODIFIES SQL DATA DYNAMIC RESULT SETS 1 BEGIN ATOMIC DECLARE result CURSOR FOR SELECT * FROM USERS order by id FOR READ ONLY; OPEN result; END ; Update Statement Store as String 0 updates Assertion.response_data false 16 continue false 1 1 1 1505666862000 1505666862000 false dbConfig INSERT INTO USERS(title,author, submission_date) VALUES ('Mr', 'Philip K. Dick', CURRENT_DATE) Update Statement Store as String 1 updates Assertion.response_data false 16 dbConfig call new_user(?, ?) Mr,Fiodor Dostoievski VARCHAR,VARCHAR Callable Statement Store as String result id,title,author 1 Assertion.response_data false 8 variable id_1 Mr Assertion.response_data false 8 variable title_1 Fiodor Dostoievski Assertion.response_data false 8 variable author_1 1 Assertion.response_data false 8 variable author_# true import java.util.Map; def list = vars.getObject("result"); if (list.size()==1) { Map map = list.get(0); if(map.get("AUTHOR").equals("Fiodor Dostoievski")) { AssertionResult.setFailure(false); } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected first row AUTHOR to be equal to 'Fiodor Dostoievski'"); } } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected 1 row in result, got:"+list.size()); } groovy dbConfig call get_users() Callable Statement Store as String result id,title,author 0 Assertion.response_data false 8 variable id_1 Mr Assertion.response_data false 8 variable title_1 Philip K. Dick Assertion.response_data false 8 variable author_1 2 Assertion.response_data false 8 variable author_# true import java.util.Map; def list = vars.getObject("result"); if (list.size()==2) { Map map = list.get(0); if(map.get("AUTHOR").equals("Philip K. Dick")) { AssertionResult.setFailure(false); } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected first row AUTHOR to be equal to 'Philip K. Dick'"); } } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected 2 rows in result, got:"+list.size()); } groovy dbConfig select title,author,submission_date from USERS where id = 0 Select Statement Store as String result title,author,submission_date Mr Assertion.response_data false 8 variable title_1 Philip K. Dick Assertion.response_data false 8 variable author_1 ${__time(yyyy-MM-dd,)} Assertion.response_data false 8 variable submission_date_1 1 Assertion.response_data false 8 variable author_# true import java.util.Map; def list = vars.getObject("result"); if (list.size()==1) { Map map = list.get(0); if(map.get("AUTHOR").equals("Philip K. Dick")) { AssertionResult.setFailure(false); } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected first row AUTHOR to be equal to 'Philip K. Dick'"); } } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected 1 row in result, got:"+list.size()); } groovy dbConfig select title,author,submission_date from USERS where id = ? 0 INTEGER Prepared Select Statement Store as String result title,author,submission_date Mr Assertion.response_data false 8 variable title_1 Philip K. Dick Assertion.response_data false 8 variable author_1 ${__time(yyyy-MM-dd,)} Assertion.response_data false 8 variable submission_date_1 1 Assertion.response_data false 8 variable author_# true import java.util.Map; def list = vars.getObject("result"); if (list.size()==1) { Map map = list.get(0); if(map.get("AUTHOR").equals("Philip K. Dick")) { AssertionResult.setFailure(false); } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected first row AUTHOR to be equal to 'Philip K. Dick'"); } } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected 1 row in result, got:"+list.size()); } groovy dbConfig Commit Store as String false false dbConfig INSERT INTO USERS(title,author, submission_date) VALUES (?, ?, ?) Mr,Victor Hugo,${__time(yyyy-MM-dd,)} VARCHAR,VARCHAR,DATE Prepared Update Statement Store as String 1 updates Assertion.response_data false 16 dbConfig select count(1) as number_user from USERS INTEGER Select Statement Store as String number_users number_user true import java.util.Map; def list = vars.getObject("number_users"); if (list.size()==1) { Map map = list.get(0); if(map.get("NUMBER_USER").equals(3L)) { AssertionResult.setFailure(false); } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected number of Rows to be equal to 3"); } } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected 1 row in result, got:"+list.size()); } groovy dbConfig Rollback Store as String dbConfig select count(1) as number_user from USERS INTEGER Select Statement Store as String number_users number_user true import java.util.Map; def list = vars.getObject("number_users"); if (list.size()==1) { Map map = list.get(0); if(map.get("NUMBER_USER").equals(2L)) { AssertionResult.setFailure(false); } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected number of Rows to be equal to 2"); } } else { AssertionResult.setFailure(true); AssertionResult.setFailureMessage("Expected 1 row in result, got:"+list.size()); } groovy dbConfig Prepared Update Statement INSERT INTO USERS(title,author, submission_date) VALUES (?, ?, ?) Mr,Leon Tolstoi,${__time(yyyy-MM-dd,)} VARCHAR,VARCHAR,DATE Store as String 1 updates Assertion.response_data false 16 dbConfig select count(1) as number_user from USERS INTEGER Select Statement Store as String number_user_before dbConfig select count(1) as number_user from USERS INTEGER Select Statement Store as String number_user_after 2 Assertion.request_data false 8 variable number_user_before_1 3 Assertion.request_data false 8 variable number_user_after_1 1 Assertion.request_data false 8 variable number_user_before_# 1 Assertion.request_data false 8 variable number_user_after_# continue false 1 1 1 1505666862000 1505666862000 false INSERT INTO USERS(title,author, submission_date) VALUES ('Mr', 'Philip K. Dick', CURRENT_DATE) Update Statement Store as String Variable Name must not be null in JDBC_NoConfig Assertion.response_message true 16 dbConfig select title,author,submission_date USERS where id = 0 Select Statement Store as String result title,author,submission_date java.sql.SQLSyntaxErrorException: Assertion.response_message true 16 title_1 dbConfig Prepared Update Statement INSERT INTO USERS(title,author, submission_date) VALUES (?, ?, ?) Mr,Leon Tolstoi,${__time(yyyy-MM-dd,)} VARCHAR,VARCHAR,DATE Store as String 1 updates Assertion.response_data false 16 select count(1) as number_user from USERS INTEGER Select Statement Store as String number_user_before 1 Assertion.request_data false 8 variable number_user_after_# dbConfig Prepared Update Statement INSERT INTO USERS(title,author, submission_date) VALUES (?, ?, ?) Mr,Leon Tolstoi,${__time(yyyy-MM-dd,)} VARCHAR,VARCHAR,DATE Store as String 1 updates Assertion.response_data false 16 select count(1) as number_user from USERS INTEGER Select Statement Store as String number_user_after 1 Assertion.request_data false 8 variable number_user_after_# dbConfig Prepared Update Statement INSERT INTO USERS(title,author, submission_date) VALUES (?, ?, ?) Mr,Leon Tolstoi,${__time(yyyy-MM-dd,)} VARCHAR,VARCHAR,DATE Store as String 1 updates Assertion.response_data false 16 dbConfig select count(1) as number_user USERS INTEGER Select Statement Store as String number_user_before false true true false dbConfig Prepared Update Statement INSERT INTO USERS(title,author, submission_date) VALUES (?, ?, ?) Mr,Leon Tolstoi,${__time(yyyy-MM-dd,)} VARCHAR,VARCHAR,DATE Store as String 1 updates Assertion.response_data false 16 dbConfig select count(1) as number_user USERS INTEGER Select Statement Store as String number_user_after false true true false false saveConfig false false false true true true true true true false false false false false false true false false false false 0 true true JDBC_TESTS.csv false saveConfig false false false true true true true true true false true true false false true false false false false false 0 true true JDBC_TESTS.xml