You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by Jose Castro <ok...@gmail.com> on 2008/07/17 16:47:56 UTC
SQL call returns header as the first line
I am using a sql call to drive my test plan. It works, except that
the sql call returns the column name as part of the returned data(in
the first row). So My first test will fail(because it contains the
column name instead of the data).
Is there any way to fix it?
I dont see any benefits in having that columns name returned as part
of the data.
Thank you
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: SQL call returns header as the first line
Posted by Jose Castro <ok...@gmail.com>.
Thank you,
I added and if processor, if {$data} != COUNT NEXT STEP
That worked
On Mon, Jul 21, 2008 at 5:10 AM, Ronald Van de Kuil
<ro...@nl.ibm.com> wrote:
> Hello Jose,
>
> You probably get the result back as something as:
>
> COUNT
> 236
>
> You could process this result with a BeanShell Post processor.
>
>
> Met Vriendelijke Groet,
> Ronald van de Kuil
>
> Stuck in the past somewhere in the future? NO WAY!!!
>
>
>
> sebb <se...@gmail.com>
> 17-07-2008 23:57
> Please respond to
> "JMeter Users List" <jm...@jakarta.apache.org>
>
>
> To
> "JMeter Users List" <jm...@jakarta.apache.org>
> cc
>
> Subject
> Re: SQL call returns header as the first line
>
>
>
>
>
>
> On 17/07/2008, Jose Castro <ok...@gmail.com> wrote:
>> I am using a sql call to drive my test plan. It works, except that
>> the sql call returns the column name as part of the returned data(in
>> the first row). So My first test will fail(because it contains the
>> column name instead of the data).
>>
>> Is there any way to fix it?
>
> Skip the first row?
>
> You don't say how you are using the data, so it's difficult to offer a
> sensible suggestion.
>
>>
>> I dont see any benefits in having that columns name returned as part
>> of the data.
>
> That is how many SQL selects work.
>
>> Thank you
>>
>> ---------------------------------------------------------------------
>> 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
>
>
>
>
> Tenzij hierboven anders aangegeven: / Unless stated otherwise above:
> IBM Nederland B.V.
> Gevestigd te Amsterdam
> Inschrijving Handelsregister Amsterdam Nr. 33054214
>
---------------------------------------------------------------------
To unsubscribe, e-mail: jmeter-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: jmeter-user-help@jakarta.apache.org
Re: SQL call returns header as the first line
Posted by Ronald Van de Kuil <ro...@nl.ibm.com>.
Hello Jose,
You probably get the result back as something as:
COUNT
236
You could process this result with a BeanShell Post processor.
Met Vriendelijke Groet,
Ronald van de Kuil
Stuck in the past somewhere in the future? NO WAY!!!
sebb <se...@gmail.com>
17-07-2008 23:57
Please respond to
"JMeter Users List" <jm...@jakarta.apache.org>
To
"JMeter Users List" <jm...@jakarta.apache.org>
cc
Subject
Re: SQL call returns header as the first line
On 17/07/2008, Jose Castro <ok...@gmail.com> wrote:
> I am using a sql call to drive my test plan. It works, except that
> the sql call returns the column name as part of the returned data(in
> the first row). So My first test will fail(because it contains the
> column name instead of the data).
>
> Is there any way to fix it?
Skip the first row?
You don't say how you are using the data, so it's difficult to offer a
sensible suggestion.
>
> I dont see any benefits in having that columns name returned as part
> of the data.
That is how many SQL selects work.
> Thank you
>
> ---------------------------------------------------------------------
> 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
Tenzij hierboven anders aangegeven: / Unless stated otherwise above:
IBM Nederland B.V.
Gevestigd te Amsterdam
Inschrijving Handelsregister Amsterdam Nr. 33054214
Re: SQL call returns header as the first line
Posted by sebb <se...@gmail.com>.
On 17/07/2008, Jose Castro <ok...@gmail.com> wrote:
> I am using a sql call to drive my test plan. It works, except that
> the sql call returns the column name as part of the returned data(in
> the first row). So My first test will fail(because it contains the
> column name instead of the data).
>
> Is there any way to fix it?
Skip the first row?
You don't say how you are using the data, so it's difficult to offer a
sensible suggestion.
>
> I dont see any benefits in having that columns name returned as part
> of the data.
That is how many SQL selects work.
> Thank you
>
> ---------------------------------------------------------------------
> 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