bug in "Message Content Assetrion" with dates
I have a step that runs JDBC request to query an Oracle table and then validates the result using Message Content Assertion and Xpath. When I run the step on my machine (win) it works fine, but when ...
Forum Discussion
SmartBear_Suppo
Alumni
AlumniHi again,
How about you try to set these environment variables in your Oracle system:
And then, use the exact same formats in SoapUI to read the dates as Strings in a Groovy Script:
Regards,
Renato
SmartBear Software
How about you try to set these environment variables in your Oracle system:
// replace with the values you want
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P15
export NLS_DATE_FORMAT="dd/mon/yyyy hh24:mi:ss"
And then, use the exact same formats in SoapUI to read the dates as Strings in a Groovy Script:
String responseDate = context.expand( ... ) // get the date String from the response
Date date = Date.parse( "d/M/yyyy H:m:s", responseDate ) // this format is the same as shown above but in Java syntax
// compare with expected value
Regards,
Renato
SmartBear Software