jmeter-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Deepak Shetty <shet...@gmail.com>
Subject Re: JDBC request - Single Query running as segregated
Date Wed, 08 Aug 2018 16:47:02 GMT
Attachments dont make the list - upload them somewhere and provide the link
>I'm giving below Single SQl query via JDBC but its giving output by taking
every column as a separate sql query
Im not sure what you mean by this - Im assuming you are referring to what
happens when you specify variable names for the columns which is described
here
http://jmeter.apache.org/usermanual/component_reference.html#JDBC_Request


On Mon, Aug 6, 2018 at 2:57 AM, Prateek Dua <prateek.dua@go-mmt.com> wrote:

> Here is the structure of my test plan
>
> On Sun, Aug 5, 2018 at 12:43 AM, Prateek Dua <prateek.dua@go-mmt.com>
> wrote:
>
>> Hi,
>>
>> I'm giving below Single SQl query via JDBC but its giving output by
>> taking every column as a separate sql query.. please find attached below
>> JDBC pool , JDBC request settings & response.
>>
>>
>> SELECT `flight_seat`.`id`, `flight_seat`.`paymentid_id`,
>> `flight_seat`.`bookingid`, `flight_seat`.`sector`,
>> `flight_seat`.`traveldate`, `flight_seat`
>> .`airlinepnr`, `flight_seat`.`seatno`, `flight_seat`.`seatfee`,
>> `flight_seat`.`passengername`, `flight_seat`.`paymentstatus`,
>> `flight_seat`.`airlinec
>> heckinstatus`, `flight_seat`.`optedcheckin`,
>> `flight_seat`.`checkinstatus`, `flight_seat`.`pdfurl`,
>> `flight_seat`.`notificationsent`, `flight_seat`.`
>> createdon`, `flight_seat`.`modifiedon`, `flight_seat`.`modifiedBy`,
>> `flight_seat`.`comments` FROM `flight_seat` WHERE `flight_seat`.`bookingid`
>> = 'M6
>> EEL1MVE' LIMIT 1;
>>
>>
>> please help me in getting it solved.
>>
>
>
> ::DISCLAIMER::
>
> ------------------------------------------------------------
> ------------------------------------------------------------
> ----------------------------
>
>
> This message is intended only for the use of the addressee and may contain
> information that is privileged, confidential and exempt from disclosure
> under applicable law. If the reader of this message is not the intended
> recipient, or the employee or agent responsible for delivering the message
> to the intended recipient, you are hereby notified that any dissemination,
> distribution or copying of this communication is strictly prohibited. If
> you have received this e-mail in error, please notify us immediately by
> return e-mail and delete this e-mail and all attachments from your system.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
> For additional commands, e-mail: user-help@jmeter.apache.org
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message