Juergen
Occasional Contributor
Joined 18 years ago
User Profile
User Widgets
Contributions
Re: Log SOAP-Requests and Responses ?
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 Juergen1.2KViews0likes0CommentsCreate a Testcase Report with more Content
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 Juergen2.8KViews0likes1CommentGroovy Script SQL - Problems with the assignment of variables
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 Juergen4KViews0likes1CommentProblem with SEQUENCES
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 Juergen4.1KViews0likes3Comments