title: SOAPUI & Groovy Scripts, executing multiple SQL statements in one go
body: <p>I've got some soapUI tests, that use groovy scripts to first insert some data into a table</p>
  
  <p>Previously, I've been using the following snippet of code to do this : </p>
  
  <pre><code>      def conn = context.dbConnEtopup
        conn.execute( "INSERT INTO A(ID, NAME) VALUES (1, "Johnny")" )
  </code></pre>
  
  <p>This works fine, however I have many test scripts that now do a similar (if not the same) SQL statements, so I'm trying to approach this by loading it in from a properties file, so my actual SQL statement is only in one place, for easier editing</p>
  
  <p>However, my SQL statement that I'm trying to use is actually 2 inserts(or deletes), so the property being loaded in is : </p>
  
  <pre><code>DELETE * FROM TABLE_A; DELETE * FROM TABLE_B;
  </code></pre>
  
  <p><code>conn.execute()</code> can't handle the <code>;</code>, which means I could only use the first <code>DELETE</code> statement</p>
  
  <p>How can I get around this? I don't want to have to load each property separately and execute them. Ideally I just want one property, so I can add further delete statements in the future</p>