Hello,
Can someone point me to a simple example of how to use the CSV Data Set
Config? I've read the docs, but can't seem to make it function at all.
What I'd like to do is to pull sql queries out of a CSV file and shove
them at a JDBC sampler (specifying the query type in the CSV file would
be a nice touch too). However, I haven't been successful in pulling
simple Id values out, never mind full queries. I know that the JDBC
config is fine since I can execute a simple JDBC sampler and can see
results come through in my SQL Profile tool (a separate monitoring tool
for the db), but when I try to pull sql out of a CSV, all I can see
making it to the database is jibberish. When I try to pull simple data
out, I don't see anything making it to the db.
The test plan consists of a Thread Group with 10 threads, 10 loop
iterations and a 5 second ramp up. It's children are: a functional JDBC
config, a CSV Data Set Config element, a JDBC Sampler and a Graph
results. The sql I'm trying to execute is an exceptionally simple:
SELECT * FROM person WHERE person_id = ${PERSON_ID}
and the CSV file contains a whopping 8 lines (do lines need to be
terminated with a delimiter token when there is only one value per line?).
In JMeter.log, I can see that at 5 threads (or thereabouts), threads
start dying with an OutOfMemoryError.
2007/12/21 03:20:05 INFO - jmeter.threads.JMeterThread: Thread Users
1-6 started
2007/12/21 03:20:05 ERROR - jmeter.threads.JMeterThread: Test failed!
java.lang.OutOfMemoryError: Java heap space
at java.util.Arrays.copyOf(Unknown Source)
at java.util.Arrays.copyOf(Unknown Source)
at java.util.Vector.ensureCapacityHelper(Unknown Source)
at java.util.Vector.addElement(Unknown Source)
at org.apache.jorphan.util.JOrphanUtils.split(JOrphanUtils.java:96)
at
org.apache.jmeter.config.CSVDataSet.iterationStart(CSVDataSet.java:84)
at
org.apache.jmeter.control.GenericController.fireIterationStart(GenericController.java:225)
at
org.apache.jmeter.control.GenericController.fireIterEvents(GenericController.java:215)
at
org.apache.jmeter.control.GenericController.next(GenericController.java:84)
at org.apache.jmeter.control.LoopController.next(LoopController.java:91)
at org.apache.jmeter.threads.ThreadGroup.next(ThreadGroup.java:123)
at org.apache.jmeter.threads.JMeterThread.run(JMeterThread.java:248)
at java.lang.Thread.run(Unknown Source)
What the hell am I doing wrong here? Thanks.
--
Shane
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
