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: [email protected] For additional commands, e-mail: [email protected]
