JDBC request - Single Query running as segregated

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

JDBC request - Single Query running as segregated

prateekgommt
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: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: JDBC request - Single Query running as segregated

prateekgommt
Here is the structure of my test plan

On Sun, Aug 5, 2018 at 12:43 AM, Prateek Dua <[hidden email]> 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: [hidden email]
For additional commands, e-mail: [hidden email]
Reply | Threaded
Open this post in threaded view
|

Re: JDBC request - Single Query running as segregated

shettyd
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 <[hidden email]> wrote:

> Here is the structure of my test plan
>
> On Sun, Aug 5, 2018 at 12:43 AM, Prateek Dua <[hidden email]>
> 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: [hidden email]
> For additional commands, e-mail: [hidden email]
>