Well the first link to check is http://jakarta.apache.org/jmeter/usermanual/build-db-test-plan.html
Here a sample on how you could solve below task assuming you just want to test the insert of the 100 users and no additional concurrency, etc.. Be aware that the screenshots show a slightly customized version of a latest nightly build. Nevertheless the sample should work for JMeter 2.5: - Create a Testplan with a ThreadGroup and a JDBC Connection Configuration - I propose you add the names of the 100 users to an argument list (optionally you could also use a CSV file or something similar to host the list of you 100 user names). This also only works for the assumption that all you need to insert is a username and some fixed other data. - Add a ForEach controller to loop through the user names - Add a JDBC Sampler to the loop. This one inserts into table Users the name, a password, age - Done -----Original Message----- From: itsbritto [mailto:[email protected]] Sent: Tuesday, November 01, 2011 7:56 AM To: [email protected] Subject: Help on SQL datapopulation Hi friends, Can any one give me basic guidelines on SQL operations in jmeter.As of now i'm comfortable with web request and all. And now in need to enter into SQL transaction and database connectivity operations.A simple need here: Need to create 100 user into the database field.. Any suggestions? links? Thanks in advance --
