Contributions
Re: How to execute script before all load tests
I found the solution for my case, but it isn't veryevident. I decide to use Load Script on the project level. For my it'ssolution. If somebody knows another way to configure beforeAll or afterAll script for load tests, please, write hear.1.1KViews0likes0CommentsHow to execute script before all load tests
Hello, community. I have a bunch of the load tests that I run from console on the TeamCity side. Now I need to execute one preset groovy script to configure environment before running all load tests. Is it possible in the SOAPUI open source platform?Solved1.1KViews0likes1CommentIs it possible to connect to SQL DB from JavaScript?
Is it possible to connect to SQL DB from JavaScript? I found a lot of examples how to connect from soapui scripts to sql via Groove, but no examples via javaScript. All scripts in my project are written on javascript, that is why I cannot use groove in this case. For JS all option how to connect to db contain 'require' command to connect external library, and when I tried it I had "ERROR:org.mozilla.javascript.EcmaError: ReferenceError: "require" is not defined" What is my general reason to do it? I want insert Load test results into DB, to build performance graphs. Could anybody suggest the solution? Thank you in advance.656Views0likes0CommentsRe: How to parse JSON in javascript
Hello,Helen. I thought about it as a first solution. But I needcustomer property to be incremented. I couldn't find any option to increment value from JSONpath. That is why i decided that Script Assertion will be the best solution. For now I did it by adding one additional Script step, in which I take customer property, increment it and write back. Then I take it and compare as you show. But I want to use javascript because it can simplify a lot of things.7KViews0likes2CommentsHow to parse JSON in javascript
Hello, community. I couldn't find a way to parse JSON in javascript. Could anybody help me? I casual JS I can use JSON.parse. But it is invalid case for SOAPUI. I know that for grove it's a lot of examples with JsonSlurper, in my case I'm using only javascript. My scenario: I have REST request which returns we JSON. To this request I have added Script Assertion in which I want to check value from JSON response and value from custom property. Thanks in advance.Solved7.1KViews0likes6CommentsRe: [Solved] [JDBC] Cannot connect to a MS SQL database
Hello, nkpalli. Try to revert slash in your connection string. Your connection string jdbc:sqlserver://databaseserver/instance;databaseName=test;integratedSecurity=true Should be jdbc:sqlserver://databaseserver\instance;databaseName=test;integratedSecurity=true And second point, maybe it doesn't work without login and password?22KViews1like9CommentsRe: [Solved] [JDBC] Cannot connect to a MS SQL database
Thank you guys for help. Now everything is ok and I can work with my local DB. If you don't mind I keep my steps here, maybe it can help somebody. If you are using local DB 1) Put sqljdbc4.jar file to the directory C:\Program Files\SmartBear\SoapUI-5.2.1\lib. Do not use version sqljdbc41.jar and sqljdbc42.jar. (They do not work for some reason for me.) 2) Turn on SQL server browser 3) Go to the SQL server configuration/ choose SQL server network configuration and set TCP/IP enable 4) Restart the SQL server 5) In the test case create a JDBC step with properties Driver com.microsoft.sqlserver.jdbc.SQLServerDriver Connection Sting (example) jdbc:sqlserver://localhost\sqlexpress;databaseName=DataDB;user=admin;password=admin20KViews1like2CommentsRe: [Solved] [JDBC] Cannot connect to a MS SQL database
Hello. I have the same problem and I still could not solve it. Maybe you can help me. 1) I have downloadedMicrosoft JDBC Driver 6.0 for SQL Server. 2) From this folder I took filesqljdbc.jar and copy paste it to the folders C:\Program Files\SmartBear\SoapUI-5.2.1\bin\ext and C:\Program Files\SmartBear\SoapUI-5.2.1\lib 3) I configured my JDBC step as Driver MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDrive Connection String jdbc:sqlserver://localhost\sqlexpress;databaseName=DataVision;user=admin;password=admin After check connection I see the error as you com.eviware.soapui.support.SoapUIException: Failed to init connection for driver [MSSQL(MicrosoftDriver)/com.microsoft.sqlserver.jdbc.SQLServerDrive], connectionString [jdbc:sqlserver://localhost\sqlexpress;databaseName=DataVision;user=admin;password=admin] this is scr with my example Could you please push me to the right may. Thx in advance.20KViews0likes4CommentsRe: How to analyze LoadTests results in TeamCity?
Come on, community! How you analyze your LoadTest data? Do you build graphs? How you integrate it with your Continuous Integration system? If this question has been asked before(but I could not find anything useful about this topic), please, post a link.637Views0likes0Comments