Rhonda_Ward
14 years agoOccasional Contributor
Unable to insert properties into database using Datasink
Hi,
I am Unable to insert properties into database using Datasink. An "java.lang.Exception: SQL problem occured" exception is thrown when I try to do so.
Steps
1) Datasink step has the following properties
Property Name Value
duration = ${=testRunner.results[testRunner.results.size()-1].getTimeTaken()}
result_reason=${=testRunner.results[testRunner.results.size()-1].status}
target_name=${engineDataSource#endpoint}
test_case=engineSeverEST
test_result=0
test_run_id=1
test_step=${=testRunner.results[testRunner.results.size()-1].testStep.name}
test_suite=Engine EST
SQL Query:
insert into test_run_details(duration,result_reason,target_name,test_case,test_result,test_run_id,test_step,test_suite) values (?,?,?,?,?,?,?
,?);
When the test step is executed the "java.lang.Exception: SQL problem occured" exception was thrown.
Note:
I did try the sql query with quotes too
insert into test_run_details(duration,result_reason,target_name,test_case,test_result,test_run_id,test_step,test_suite) values ('?','?','?','?','?','?','?'
,'?');
Can you please help me determine the cause of failure?
Thanks
I am Unable to insert properties into database using Datasink. An "java.lang.Exception: SQL problem occured" exception is thrown when I try to do so.
Steps
1) Datasink step has the following properties
Property Name Value
duration = ${=testRunner.results[testRunner.results.size()-1].getTimeTaken()}
result_reason=${=testRunner.results[testRunner.results.size()-1].status}
target_name=${engineDataSource#endpoint}
test_case=engineSeverEST
test_result=0
test_run_id=1
test_step=${=testRunner.results[testRunner.results.size()-1].testStep.name}
test_suite=Engine EST
SQL Query:
insert into test_run_details(duration,result_reason,target_name,test_case,test_result,test_run_id,test_step,test_suite) values (?,?,?,?,?,?,?
,?);
When the test step is executed the "java.lang.Exception: SQL problem occured" exception was thrown.
Note:
I did try the sql query with quotes too
insert into test_run_details(duration,result_reason,target_name,test_case,test_result,test_run_id,test_step,test_suite) values ('?','?','?','?','?','?','?'
,'?');
Can you please help me determine the cause of failure?
Thanks