JDBC testing with User paramaters in Query

["Sosnowski, Andrew P [IT]" <an...@citigroup.com>]

There may be a bug with User Parameters when used with JDBC objects.

Once in a while but not all the time the ${EMPID} parameter does not get
expanded; most of the time it is expanded correctly. I.e. of 17 threads the
query is not expanded 1 of the 17 times on average.

Is there a restriction on what characters can be in the User Values?
The Values I use are of the form "0000091357"
Is '0000091357' better?

If necessary I could use of the form 0000091357 and have the quotes in the
Query field

-----Original Message-----
From: Sosnowski, Andrew P [IT] 
Sent: Wednesday, October 16, 2002 1:42 PM
To: Sosnowski, Andrew P [IT]; 'Mike Stover '; 'JMeter Users List '
Subject: RE: JDBC testing


Some things I would find useful for JDBC testing:

-the label of the JDBC test element is not used in the Sample Results label
attribute (uses the Query string instead) as it is in the HTML element.
I like this feature as it is helpful in creating reports of results from jtl
file.

-is there any way to view the data returned or to create an Assertion on the
data returned. I am getting a very wide different in Min and Max time for
many storesd procs and I wonder if some are actually returning erroneous
data.
Sometimes I find errors in the jmeter.log but according to the GUI the
result is good and it uses the bad results in computing the Averages, etc.

Thanks 
Andy

-----Original Message-----
From: Sosnowski, Andrew P [IT] 
Sent: Tuesday, October 15, 2002 1:57 PM
To: 'Mike Stover '; 'JMeter Users List '
Subject: RE: JDBC testing


 Yes I found my problem.
I didn't change the sybase url to the new Server in every place it was
referenced although I still don;t understand why the message came up

Thanks Mike

-----Original Message-----
From: Mike Stover
To: JMeter Users List
Sent: 10/15/02 12:19 PM
Subject: Re: JDBC testing

Hard to say, but the stack trace is usually revealing for errors of that
sort.

-Mike

On 15 Oct 2002 at 11:34, Sosnowski, Andrew P [IT] wrote:

>  I'm using jmeter to do JDBC performance testing for the first time in
a
> while and I'm having a problem I've never seen before accessing a
Sybase
> database.
> 
> When I access one server, everything seems fine but when I change the
url to
> another server, running read-only stored procs seems to cause a
> ConcurrentModificationException. This is puzzling as that seems to
have
> something to do with Collections? The second attempt does seem to run
all
> the stored procs but it does not generate a file of Results as it does
for
> the first.
> 
> Any ideas welcome,
> 
> Andy Sosnowski
> 
> --
> To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
> For additional commands, e-mail:
<ma...@jakarta.apache.org>
> 



--
Michael Stover
mstover1@apache.org
Yahoo IM: mstover_ya
ICQ: 152975688

--
To unsubscribe, e-mail:
<ma...@jakarta.apache.org>
For additional commands, e-mail:
<ma...@jakarta.apache.org>

--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>