You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Vikrant Sharma <xb...@yahoo.com> on 2007/04/19 11:07:35 UTC

How to store query results to a Variable?

Hi,

I am trying to use the JDBC Connection Configuration and JDBC Request to connect to DB and execute some queries.
I am able to connect to DB and execute my queries. 
My question is -
Is there a way that I can store the results obtained by the query into some variable or file so that I can use it in my other requests or bean shell samplers

Thanks & regards
Vikrant

       
---------------------------------
Ahhh...imagining that irresistible "new car" smell?
 Check outnew cars at Yahoo! Autos.

Re: How to store query results to a Variable?

Posted by sebb <se...@gmail.com>.
Or use the Regular Expression Post-Processor to extract the
information and store it in a variable.

On 19/04/07, prateeti <pr...@kirusa.com> wrote:
>
> Hi Vikrant,
>
> You can use Save response to file.
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#Save_Responses_to_a_file
>
>
> Vikrant Sharma wrote:
> >
> > Hi,
> >
> > I am trying to use the JDBC Connection Configuration and JDBC Request to
> > connect to DB and execute some queries.
> > I am able to connect to DB and execute my queries.
> > My question is -
> > Is there a way that I can store the results obtained by the query into
> > some variable or file so that I can use it in my other requests or bean
> > shell samplers
> >
> > Thanks & regards
> > Vikrant
> >
> >
> > ---------------------------------
> > Ahhh...imagining that irresistible "new car" smell?
> >  Check outnew cars at Yahoo! Autos.
> >
>
> --
> View this message in context: http://www.nabble.com/How-to-store-query-results-to-a-Variable--tf3605914.html#a10074631
> Sent from the JMeter - User mailing list archive at Nabble.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: How to store query results to a Variable?

Posted by prateeti <pr...@kirusa.com>.
Hi Vikrant,

You can use Save response to file.
http://jakarta.apache.org/jmeter/usermanual/component_reference.html#Save_Responses_to_a_file


Vikrant Sharma wrote:
> 
> Hi,
> 
> I am trying to use the JDBC Connection Configuration and JDBC Request to
> connect to DB and execute some queries.
> I am able to connect to DB and execute my queries. 
> My question is -
> Is there a way that I can store the results obtained by the query into
> some variable or file so that I can use it in my other requests or bean
> shell samplers
> 
> Thanks & regards
> Vikrant
> 
>        
> ---------------------------------
> Ahhh...imagining that irresistible "new car" smell?
>  Check outnew cars at Yahoo! Autos.
> 

-- 
View this message in context: http://www.nabble.com/How-to-store-query-results-to-a-Variable--tf3605914.html#a10074631
Sent from the JMeter - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org