You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by mukesh garg <mu...@yahoo.com> on 2005/08/12 12:31:04 UTC
using sql query as a request parameter value
Hi,
I am creating a test plan that needs some value from database to
execute a request. is there any way to execute sql query in a request
parameter. I have used random function to create send unique names in request
parameter but unable to find a way hot to execute a sql query.
Any help will be really appreciated.
Thanks,
Mukesh
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: using sql query as a request parameter value
Posted by mukesh garg <mu...@yahoo.com>.
Hi Peter,
You are absolutely right. i want to use the result of a sql query in http request.
Thanks,
Mukesh
Peter Lin <wo...@gmail.com> wrote:
hi mukesh,
is your goal to send a query to the database and then use the results
for a HTTP request?
peter
On 8/12/05, Michael Stover wrote:
> Soooo..... does the JDBCSampler not meet your needs?
>
> On Fri, 2005-08-12 at 06:28 -0700, mukesh garg wrote:
> > Basically i am creating a test plan for an application, where we start with an account creation that sends a mail with some randomly generated validation code. We need to know the validation code to setup the account after it. I am preparing a complete account setup test script. but after creating an account, we need to enter validation code in next request. So i need to retrieve validation code from DB on the basis of recently created account name.
> >
> > -- Mukesh
> >
> > Michael Stover wrote:
> > Does the JDBCSampler not meet your needs?
> >
> > -Mike
> >
> > On Fri, 2005-08-12 at 03:31 -0700, mukesh garg wrote:
> > > Hi,
> > >
> > > I am creating a test plan that needs some value from database to
> > > execute a request. is there any way to execute sql query in a request
> > > parameter. I have used random function to create send unique names in request
> > > parameter but unable to find a way hot to execute a sql query.
> > >
> > > Any help will be really appreciated.
> > >
> > > Thanks,
> > > Mukesh
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam protection around
> > > http://mail.yahoo.com
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: using sql query as a request parameter value
Posted by Peter Lin <wo...@gmail.com>.
hi mukesh,
is your goal to send a query to the database and then use the results
for a HTTP request?
peter
On 8/12/05, Michael Stover <ms...@apache.org> wrote:
> Soooo..... does the JDBCSampler not meet your needs?
>
> On Fri, 2005-08-12 at 06:28 -0700, mukesh garg wrote:
> > Basically i am creating a test plan for an application, where we start with an account creation that sends a mail with some randomly generated validation code. We need to know the validation code to setup the account after it. I am preparing a complete account setup test script. but after creating an account, we need to enter validation code in next request. So i need to retrieve validation code from DB on the basis of recently created account name.
> >
> > -- Mukesh
> >
> > Michael Stover <ms...@apache.org> wrote:
> > Does the JDBCSampler not meet your needs?
> >
> > -Mike
> >
> > On Fri, 2005-08-12 at 03:31 -0700, mukesh garg wrote:
> > > Hi,
> > >
> > > I am creating a test plan that needs some value from database to
> > > execute a request. is there any way to execute sql query in a request
> > > parameter. I have used random function to create send unique names in request
> > > parameter but unable to find a way hot to execute a sql query.
> > >
> > > Any help will be really appreciated.
> > >
> > > Thanks,
> > > Mukesh
> > >
> > >
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Tired of spam? Yahoo! Mail has the best spam protection around
> > > http://mail.yahoo.com
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: using sql query as a request parameter value
Posted by Michael Stover <ms...@apache.org>.
Soooo..... does the JDBCSampler not meet your needs?
On Fri, 2005-08-12 at 06:28 -0700, mukesh garg wrote:
> Basically i am creating a test plan for an application, where we start with an account creation that sends a mail with some randomly generated validation code. We need to know the validation code to setup the account after it. I am preparing a complete account setup test script. but after creating an account, we need to enter validation code in next request. So i need to retrieve validation code from DB on the basis of recently created account name.
>
> -- Mukesh
>
> Michael Stover <ms...@apache.org> wrote:
> Does the JDBCSampler not meet your needs?
>
> -Mike
>
> On Fri, 2005-08-12 at 03:31 -0700, mukesh garg wrote:
> > Hi,
> >
> > I am creating a test plan that needs some value from database to
> > execute a request. is there any way to execute sql query in a request
> > parameter. I have used random function to create send unique names in request
> > parameter but unable to find a way hot to execute a sql query.
> >
> > Any help will be really appreciated.
> >
> > Thanks,
> > Mukesh
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: using sql query as a request parameter value
Posted by mukesh garg <mu...@yahoo.com>.
Basically i am creating a test plan for an application, where we start with an account creation that sends a mail with some randomly generated validation code. We need to know the validation code to setup the account after it. I am preparing a complete account setup test script. but after creating an account, we need to enter validation code in next request. So i need to retrieve validation code from DB on the basis of recently created account name.
-- Mukesh
Michael Stover <ms...@apache.org> wrote:
Does the JDBCSampler not meet your needs?
-Mike
On Fri, 2005-08-12 at 03:31 -0700, mukesh garg wrote:
> Hi,
>
> I am creating a test plan that needs some value from database to
> execute a request. is there any way to execute sql query in a request
> parameter. I have used random function to create send unique names in request
> parameter but unable to find a way hot to execute a sql query.
>
> Any help will be really appreciated.
>
> Thanks,
> Mukesh
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Re: using sql query as a request parameter value
Posted by Michael Stover <ms...@apache.org>.
Does the JDBCSampler not meet your needs?
-Mike
On Fri, 2005-08-12 at 03:31 -0700, mukesh garg wrote:
> Hi,
>
> I am creating a test plan that needs some value from database to
> execute a request. is there any way to execute sql query in a request
> parameter. I have used random function to create send unique names in request
> parameter but unable to find a way hot to execute a sql query.
>
> Any help will be really appreciated.
>
> Thanks,
> Mukesh
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org