Help on SQL datapopulation

[itsbritto <br...@gmail.com>]

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

--

Re: Help on SQL datapopulation

[itsbritto <br...@gmail.com>]

Hey thanksRoman Bargezi,
For your quick reply.Will mining on that link


On Tue, Nov 1, 2011 at 6:06 PM, Roman Bargezi, Infonic AG <
rbargezi@infonic.net> wrote:

> 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:brittobtech@gmail.com]
> Sent: Tuesday, November 01, 2011 7:56 AM
> To: jmeter-user@jakarta.apache.org
> 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****
>
> ** **
>
> --****
>



--

RE: Help on SQL datapopulation

["Roman Bargezi, Infonic AG" <rb...@infonic.net>]

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:brittobtech@gmail.com] 
Sent: Tuesday, November 01, 2011 7:56 AM
To: jmeter-user@jakarta.apache.org
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

 

--