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:[EMAIL PROTECTED] 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:[EMAIL PROTECTED] Sent: 27 October 2003 11:32 To: '[EMAIL PROTECTED]' 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] ___________________________________________________________________________________________________ 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. ________________________________
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
