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....@go-mmt.com> wrote: > Here is the structure of my test plan > > On Sun, Aug 5, 2018 at 12:43 AM, Prateek Dua <prateek....@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-unsubscr...@jmeter.apache.org > For additional commands, e-mail: user-h...@jmeter.apache.org >