JBDC Request results

You may use property. If not seen yet, check link below:
http://www.soapui.org/Functional-Testin ... rties.html

Thank you so much for your prompt reply.

I've used properties in several different ways but I don't understand how to use one in this case. Are you suggesting a "properties" test step? Please explain what kind of property and how to assign it to the 'max number of rows'.

Hi,

This seems strange... you should still get some results even when you do not specify the maximum number of results to fetch.

In any case, could you try adding this line to your SQL Query:

LIMIT 1

For example:

SELECT * FROM TABLE_1 WHERE ID > 333 LIMIT 1;

If this does not make any difference, please send us your project file so we can see if you need to do something differently.

Regards,

Renato
SmartBear Software

I can't really send you my project because you won't have the database. This is my SQL statement in the JDBC DataSource:

select party_number
from
(
select *
from apps.hz_parties
sample block (.1)
where 1 = 1
and status = 'A'
and party_number > 0
)
where rownum = 1

This returns just one row (one field also, as you can see) which is then referenced in a JDBC request. partyNumber is set to ${DataSource_JDBC_PD#party_number} and the SQL is:

select HP.party_number
,HP.party_id
,HP.person_first_name
,HP.person_last_name
,HCP.phone_area_code||HCP.phone_number AS PHONE_NUMBER
,HP.email_address
,HP.address1
,HP.address2
,HP.address3
,HP.address4
,HP.city
,HP.county
,NVL(HP.state,HP.province) AS STATE
,HP.country
,HP.postal_code
,HP.party_name
,HP.party_type
from apps.hz_parties HP
,apps.hz_contact_points HCP
where 1 = 1
and HP.party_id = HCP.owner_table_id (+)
and HCP.contact_point_type = 'PHONE'
and HCP.primary_flag = 'Y'
and HCP.status = 'A'
and HCP.owner_table_name = 'HZ_PARTIES'
and rownum = 1
and HP.party_number = :partyNumber

If I run the DataSource manually and set the max rows to 1, I get what I expect. Because it defaults to 10, I need to be able to set that number to 1.

I decided to send you the project anyway.

This issue is a show stopper for me. Are there any answers yet?

Unfortunately, do not use soapui pro and having problem in viewing your project in soapui free version.

Would you please see if the below links help?
www.soapui.org/Data-Driven-Testing/datasources.html
http://www.soapui.org/Scripting-Propert ... -datasinks

Thanks for your response. I had read those pages and tried using all sorts of combinations of DataGen, Properties and Groovy script in my effort to make it work.

I finally have made it work just a bit ago but not in the way that I was asking. I changed the SQL in the DataSource to < 11 rows, instead of just 1. The JDBC Request still is limited to 1 row. The DataLoop causes my test case to process the 10 rows, one at a time, successfully.

I would still like to know if there is any way to programmatically set the number of rows in a DataSource.

Ok, I can imagine if there is something that needs to be done due to time lines / other dependencies.

Sorry to bother you again, still i dont get where you would like to change in the below (assuiming that you are referring to the same)

select party_number
from
(
select *
from apps.hz_parties
sample block (.1)
where 1 = 1
and status = 'A'
and party_number > 0
)
where rownum = 1

You're not bothering me - you're trying to help me. But I don't understand how you can help me without Pro. When you run a DataSource test step, a dialog box pops up asking how many rows you want returned. This is the property that I want to control.

I changed that sql statement to "where rownum < 11" in the last line. It seemed to work and then didn't. So I closed SoapUI and I'll try again.

EDIT: Nope, not working. I really need my DataSource to return data so that the JDBC Request will return data. I'm still getting:
<Results>
<ResultSet fetchSize="10"/>
</Results>