datasink writing to mysql database problems
Hi, i tried to prepare some datadriven testsuits. To get the testdata i use an XAMMP with mysql database. Everything works, but writing back data to the database seens al litle bit 'mysterious'. ...
Forum Discussion
Hi!
the JDBC DataSinks sql statement is treated as a prepared statement, where the properties are assigned in the order they are defined, ie try changing the sql to
And then see to it that you have 6 properties in your datasink; their values need to be set before the DataSink is executed (they can also contain property-expansions which will be expanded accordingly).
Hope this helps!
regards,
/Ole
eviware.com
the JDBC DataSinks sql statement is treated as a prepared statement, where the properties are assigned in the order they are defined, ie try changing the sql to
INSERT into result_checkAddress (
test_id,
execution_id,
input_data,
output_data,
test_result,
test_comment
)
VALUES (
?,
?,
?,
?,
if (STRCMP(
'IFNULL(?,'')',
'?}'
),
'NOTOK', 'OK'
),
'Comment'
)
And then see to it that you have 6 properties in your datasink; their values need to be set before the DataSink is executed (they can also contain property-expansions which will be expanded accordingly).
Hope this helps!
regards,
/Ole
eviware.com