Dynamic query, temp table, insert select
Hi, I went thru this older post https://community.smartbear.com/t5/SoapUI-Pro/Stored-Proc-DYNAMIC-SQL-returns-no-rows/td-p/42621 And i also have the similar problem, I am creating a temp table, inserting the data using a SP and then doing some select based on my criteria I am using JDBC test step in my test case to execute this, whenever I am executing it, I am not getting any error, instead i m getting <Results> <UpdateCount>0</UpdateCount> </Results> Although, I expect the output of my Select query which is my last statement. I can see it use to be a bug in earlier version. Not sure if that is still an issue, or am I missing something. Thanks in advance. P.S: It is working fine if I am executing the same in SSMS(Sql Server Management Studio) Regards, Andy
ReadyAPI 1.9.0 JDBC Request converted all received SQL column names to the upper case
I have recently upgraded from 1.8.5 to 1.9.0 and see this issue - now i have to rebuild all my assertions - Please let me know is there any global setting which can control this behaviour? Product - Ready API 1.9.0 - SOAPUI NG
Unable to transfer data from a data source into SQL query
I'm trying totransfer data from a data source to be used in a where statement of a SQL query. Essentially my script does the following: Holds “ID” numbers in a grid data source Executes a SOAP request and one of the fields uses the “ID” numbers from the grid data source ${DataSource#IDNumber} (have looped this at the end of the test case to go back and use the next ID number and run again) Uses a Microsoft SQL Server driver to connect to a DB and run a Select SQL query on one of the tables and compare this against some of the data in the SOAP request I can do this for one “ID” number if I write it as where = '123' however I want to be able to use the ID number that was used in the test case for that loop i.e ${DataSource#IDNumber}. I have tried it writing the below but it doesn’t work can someone help please? Select * From OpsControl.Piece Where OpsControl.Piece.TrackingNumber = 'DataSource#IDNumber' Many thanks Chris Hi,
How to address properties in MySQL query
Hi there, I hope someone could help, I have the following scenario: I am using DataSource "Data Connection" to connect to our database. I have a global property on TestSuite level named "propEntityID" w/ value 20 for example. Now I have the following SQL select statement: SELECT * FROM databasetable WHERE entity_id = ${#TestSuite#propEntityID} When I run this I get a Soap error: "Can't get the Connection for specified properties; com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column '$' in 'where clause'" as well as a Java Error "Unexpected token "{" at line 3, pos 50". How do I correctly address the TestSuite property and how do I mask/escape the special characters such as "$" and "{" respectively? Help appreciated. Kind regards
