Thank's Ole for your quick answer,

your solution works fine.

The option with the data sink is no solution in this case, because i'm working with multiple environments and i have no idea how the connection string of the database step can be parameterized.

Thanks a lot

Juergen

Hello,

is there a simple way to log soap-requests and soap-responses with a groovy script?
Unfortunately I found no example to the topic. The goal is to store the complete Requests and Responses in a data base.

Thanks

Juergen

Hi Ole,

thanks for that great Tool.

But now my Question.
We use SoapUi Pro und have created an Regressiontest (with serveral testcases) for a Application.
After the execution of the Regressiontest it is possible to create an Testcase Report, but that report contains only Name of the Testcase, Status and Time.
It is possible to create a TestCase Report automatically with more Content (Informations) like Requests and Responces and other attributes.


Thank's

Juergen

Hallo I have a solution for that problem:

#########
SELECT TRANSACTION_ID_SEQ.nextval as TRANSACTION_ID_SEQ  from dual
#########


Now it works fine.

Regards

Juergen

I have the following problem I liked to select from a data bank a Sequence TEST_CASE_ID_SEQ and write this afterwards
in another table. Unfortunately, the handing over of the variable TEST_CASE_ID_SEQ into the variable TEST_CASE_ID does not work.
However, I get only the value 'null' I have written the following script.

What do I make wrong ??

##########################
import java.sql.Connection
import java.sql.DriverManager
import javax.sql.DataSource
import groovy.sql.Sql
import oracle.jdbc.driver.OracleTypes
import groovy.sql.DataSet


def driver = oracle.jdbc.driver.OracleDriver
def sql = Sql.newInstance ('jdbc:oracle:thin:pt_xxx/pt_xxx@localhost:31521:pt_xxx')

def TEST_CASE_ID_SEQ
def TEST_CASE_ID

//READ next Value of TEST_CASE_ID_SEQ
TEST_CASE_ID = sql.eachRow("SELECT TEST_CASE_ID_SEQ.nextval as TEST_CASE_ID_SEQ from dual")
{
}

println TEST_CASE_ID
// result null

//Write Value TEST_CASE_ID
//TEST_CASE_ID = "2345"
sql.execute("Insert into log TEST_CASE_ID values (?)", [TEST_CASE_ID])
#####################

Thanks and best regards

Juergen

Hi all,

I have a problem using ORA-SEQUENCEs as a datasource in soapUI.
I using the following driver => oracle.jdbc.driver.OracleDriver.
The database is up and running, connection OK.

Now the problem.
I have created a database-sequence and a datasource in soapUI.
Now I want to recieve the next Value from the sequence and I have created the following sql-statement. But nothing happens.

SELECT TRANSACTION_ID_SEQ.nextval from dual


Please help !!!

Thanks and best regrads
Juergen