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
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.
  • 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.