Sebb,
Thanks. This is valuable information. Is there anyway we can set up a
JMeter Wiki faq, and then we could filter the really useful stuff to
the help files?
Aidy
On 02/06/2008, sebb <[EMAIL PROTECTED]> wrote:
> On 02/06/2008, aidy lewis <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > In a JDBC request, is it possible to use variables in the sql query?
> >
> > I have a file
> >
> > 15004781
> > 15004782
> > 15004783
> > 15004784
> > 15004785
> > 15004786
> > 15004787
> > 15004788
> > ....
> >
> > That I read in the CSV data set config. The var has been assigned to
> > the name 'contractid'
> >
> > Now, I know I can use this var in Jmeter like this; ${contractid}
> >
> > But, how could I use this in my sql?
> >
> > declare @contractId int,
> >
> > set @contractId = 15004779
> >
>
> If you are referring to SQL in the JDBC sampler, then just put:
>
> set @contractId = ${contractid}
>
> However, I assume you are referring to a stored procedure.
>
> In which case, you need to pass the variable in as a parameter to the
> stored procedure, and use whatever the SQL dialect requires to refer
> to the parameter.
>
> The JDBC Sampler would look something like:
>
> {CALL PROCEDURE(${contractid})}
>
> or, if using a prepared statement:
> {CALL PROCEDURE(?)}
> and then add ${contractid} as a variable at the bottom.
>
> The enclosing {} may not be necessary.
>
> See
> http://jakarta.apache.org/jmeter/usermanual/component_reference.html#JDBC_Request
>
> > Thanks
> >
> > Aidy
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
Aidy
www.agiletester.co.uk
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
