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: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- Michael Stover [EMAIL PROTECTED] Yahoo IM: mstover_ya ICQ: 152975688 -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>