This is driving me nuts... I'm using the latest SoapUI (2.0.2) Pro. I have a property in my test suite called holdExpiration and have set it to "2008-04-01T11:11:11.111 which is the default UNIX timedate format.

When I use the UI or manually enter the property association (${#TestSuite#holdPlacement}, and then click into another field, what I type/picked using the UI disappears.

I've seen this off and on but have generally gotten around it in the past. However, I can't get it to stop today.

Ole,

Some time has passed since. Now we're seeing this EVERYWHERE. I would ask dev to declare these faults, but they're heads-down on other items and prob don't want to roll off user stories to make things more testable.

Is it possible to disable/hide these warnings?

In my organization, we run a 'swimlane' method of promoting builds from dev to test to stage to prod. This means my SoapUI tests have to be able to run against at least 4 different endpoints.

What is the best way to migrate multiple test suites from one endpoint to another? I'm not finding anything really clean or obvious in the documentation.

Thanks,

John O.

Sweet!! I finally had a chance to use this code, Ole, and it works brilliantly. Thanks very much - you made it so I can remove a ton of tedious code.

I have created a test which I expect will fail (I want it to fail). I have added a SOAP Fault assertion, and I've also added an assertion for CONTAINS and the text "does not exist" (which is the text our service returns if the element passed in doesn't exist).

When I run it, it passes as expected but I get the following warning:
Mon Jan 07 10:31:39 MST 2008:WARN:Missing matching Fault in wsdl for bindingOperation [setBirthMotherInfo]

What does this warning mean? Should the faults be contained within our WSDL?

John O.

Thanks - I will give this a try ASAP.

Hi Ole - sorry for the delay in replying; I was out for the holidays. Yes, yu are correct - if I hard-code the SQL statement and pass that into the function, it works fine. What I'm trying to do is great a simple generic function that returns the count of something.

Any other ideas, or is there any additional info I can provide you to see if there's a fix possible? Thanks!!

John O.

No, I didn't think to try it. So here is my Groovy script then:
db.eachRow("SELECT COUNT ('${entryColumnName}') from '${tableName}' WHERE '${entryColumnName}' = '${entryValue}'")
         { row -> (myCount = row[0])}

Unfortunately, it made no difference. It's almost as if soapUI cannot interpret variables in a script name - I think I mentioned that the ONLY variable I can pass in as $variableName is when it's in singlequotes - so '$variableName' works for me.

John O.

I'm working with Groovy scripts and soapUI. I have a Groovy script full of helper functions, and I've been creating a new helper function which is

SELECT COUNT (columnName) FROM tableName WHERE columnName = 'value'

As you can see in the attached code, my helper function takes the columnName, tableName, entryValue, as well as a reference to the log and a binary (whether to throw an exception or error silently). All these parameters have been inserted into the SQL statement using $tableName and the likes:
db.eachRow("SELECT COUNT ('$entryColumnName') from '$tableName' WHERE '$entryColumnName' = '$entryValue'")

I have also simply built the query string:
myQuery = "SELECT COUNT ($entryColumnName) from $tableName WHERE $entryColumnName = '$entryValue'"

In all cases, when I reference the function from within soapUI, I get a SQL exception "invalid table name". I can literally copy the SQL statement and run it in SQL Developer and it succeeds. And if I hard-code values (instead of $tableName and other variables), it succeeds.

There seems to be a problem interpreting variables when building a SQL string. It has worked consistently when it interprets '$condition' in a SQL statement substring enclosed in single-quotes; this is the first time I've tried to create an entire SQL statement this way.

Any help = much appreciated. I've banged me head against the wall all day on this one. Very frustrating.

OK, after beating my head against a wall on this for four hours, I rewrote the method with a different name. It works now. ?? I don't get it, but I'm moving ahead.

Hey Ole... Yeah, I actually have it wrapped up in a class (I neglected to copy/past that info my attachment) so that can't be the problem. Is there any way to 'debug' a script once it's been moved to a central location?

Here's my class:
class PersonInfoSharedScripts
{
   def log
   def AccountID

  def static CleanUpPerson(AccountID, log)
  {
     def db = Sql.newInstance('jdbc:oracle:thin:@server:1234:db', 'username', 'password', 'oracle.jdbc.OracleDriver')

      // If the AccountID exists, we need to delete it for cleanliness
      // conditional if - on whether there's anything in the first cell of the first row'
        def myString
      this.AccountID = AccountID

      // if (db.eachRow("SELECT AccountUserName FROM TABLE WHERE accountid = 'AccountID0002'"){ row -> log.info(row[0])}) {
        db.eachRow("SELECT AccountUserName FROM TABLE WHERE accountid = 'AccountID0002'")
           { row -> (myString = row[0])}
        
        if (myString)
        {
           // IF WE GOT HERE, WE FOUND AT LEAST ONE INSTANCE OF AccountID0002
           log.info("AccountID found - will delete it now")
   
           // first, delete all entries in sperson_sideaccountusername related to accoutID0002
           // this is a complex query - nestling a query to get the fsperson.id value within the delete state
           log.info("   deleting sidetable entries")
           db.execute("DELETE FROM fsperson_sidetable WHERE sperson_id = (select id from sperson where AccountID = 'AccountID0002')")
   
           // next, delete the row from auth_table where accountid = 'AccountID0002'
           log.info("   deleting entries in auth_table")
           db.execute("DELETE FROM auth_table where username = (select accountusername from person where accountid = 'AccountID0002')")
   
           // next, delete the entire row in the SPERSON table
           log.info("   deleting entries from person")
           db.execute("DELETE FROM person WHERE accountid = 'AccountID0002'")
        }

        else
        {
           log.info("AccountID not found - proceed to next step")
        }
  }
}

Hopefully the last low-level question... I'm moving most of my Groovy scripts into a shared Groovy script. In the process, I decided to add another layer of complexity, and code these scripts in Eclipse. So I've installed Eclipse, added the Groovy plug in, and created a new Java project with Groovy scripts.

I was able to muddle through referencing the groovy.sql.Sql. I've also seen that, in order to log, I need to pass a reference to the log:
soapUI.lds.org.qa.tools.PersonInfoSharedScripts.CleanUpPerson('AccountID0002', log)

My script is erroring, though, when I try to call it with (text, log). The error is :
java.lang.VerifyError: (class: soapUI/lds/org/qa/tools/PersonInfoSharedScripts, method: CleanUpPerson signature: (Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;) Incompatible type for getting or setting field

I've attached the .groovy file I'm using. What am I doing wrong, that I cannot reference it?

One general question: is there any easy way to debug shared scripts? I'm guessing which line is erroring, and why... I'm debugging blind. It'd be great to be able to debug and step through the code, or at least see what's happening and where the error is occuring.

Thinking forward, are there any other libraries/jars I should reference proactively (for things like accessing XML results, throwing exceptions on error, etc.)?

JTO

Thanks Ole - is there some place where the groovy script library is documented, because I'm about to do that (my backlog for the day includes 1) getting going with backups and repository and 2) moving my code out of each test into parameterized, centralized helper scripts).

Or do I just back up the \bin\scripts directory?

Folks,

Now that I actually have 8-16 hrs worth of usable work, I want to start backing up my soapUI projects in a source control repository.

If I have soapUI projects which include requests and groovy scripts, what files do I need to backup? Obvously the soapUI project file, but I need to know if anything else (esp the groovy scripts) is stored elsewhere.

Thanks in advance,

John O.

Ole thanks. This got me running!