Forum Discussion

peti2005's avatar
peti2005
Occasional Contributor
6 years ago

CREATE TABLE does not work from JDBC test step

Hello SoapUI community I have SQL Server DB. When I execute the following JDBC test step it runs without any error: drop table if exists ##GTA_PFile100_Precondition_Result; create table ##GTA_...
  • JHunt's avatar
    JHunt
    6 years ago
    Try creating separate test steps for each statement.

    Each statement you send may produce a result set, so when SoapUI gets a result from the first statement, it stores it as the result of the test step and stops.
JHunt's avatar
JHunt
Community Hero
Try creating separate test steps for each statement.

Each statement you send may produce a result set, so when SoapUI gets a result from the first statement, it stores it as the result of the test step and stops.
peti2005's avatar
peti2005
Occasional Contributor
6 years ago

My fault. I was creating global temporary table which exists only until the current session is open. I will close this topic.