Hi S
Implemented the CSVRead as you sugggested and Jmeter seems to process the
.csv correctly. Only problem is the database is not being updated. Tried
adding a commit, but no such luck.
If you have time can u have a look at my jmx file:
Regards
Dani
-----Original Message-----
From: BAZLEY, Sebastian [mailto:Sebastian.BAZLEY@london.sema.slb.com]
Sent: Monday, October 27, 2003 2:23 PM
To: 'JMeter Users List'
Subject: RE: CVSRead and JDBC query
__CSVRead(file,next) always returns the empty string. This is intentional.
You need to use
__CSVRead(file,0)
__CSVRead(file,1)
...
__CSVRead(file,4)
__CSVRead(file,next)
in your test plan to be able to pick out the different columns.
Probably best to do this in a User Parameter test element, e.g.
Name Value
PASS ${__CSVRead(file,0)}
...
SID ${__CSVRead(file,4)${__CSVRead(file,next)}
Since the "next" modifier returns "", it can be combined with the last
column.
Columns don't have to be listed in numerical order, but it is important that
the "next" is processed last.
The Java Test sampler is useful for testing variables - just add the
variable(s) to the Label, and it will appear in the View Results Table (or
Tree) Listener.
S.
P.S. There was a bug in CSVRead (Bugzilla id 24076) which has only just been
fixed in CVS.
-----Original Message-----
From: Rubin, Dani [mailto:DRubin@fnb.co.za]
Sent: 27 October 2003 11:32
To: 'jmeter-user@jakarta.apache.org'
Subject: CVSRead and JDBC query
> Hi
> I am trying to iterate this SQL statement to a DB2 database
> insert into user (password, loginattempts, status, username,
> person_payworksid) values
> (${__CSVRead(C:\jakarta-jmeter-1.9.1\test_data\insert.csv,next())})
> This insert does not work and there are not errors in the error log.
> Has anyone experienced anything like this?
>
> Dani Rubin
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
___________________________________________________________________________________________________
The views expressed in this email are, unless otherwise stated, those of the author and not
those
of the FirstRand Banking Group or its management. The information in this e-mail is confidential
and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised.
If you are not the intended recipient, any disclosure, copying, distribution or any action
taken or
omitted in reliance on this, is prohibited and may be unlawful.
Whilst all reasonable steps are taken to ensure the accuracy and integrity of information
and data
transmitted electronically and to preserve the confidentiality thereof, no liability or
responsibility whatsoever is accepted if information or data is, for whatever reason, corrupted
or does not reach its intended destination.
________________________________
|