title: Jsp code with mysql
body: <p>I am facing the problem in mysql query. The query working fine in PHP MY admin.Whenever i am implementing through jsp code it is showing String literal is not properly closed error.</p>
  
  <p>Here is my code    </p>
  
  <pre><code>String query="SELECT * FROM (
  
                              (SELECT SupplierTicketId AS SupplierTicketId,
                                      TicketType AS TicketType,
                                      SupplierTicketStatus AS SupplierTicketStatus,
                                      CreatedBy AS CreatedBy,
                                      SupplierType AS SupplierType
                                      FROM supplierticket)
                             UNION ALL
                             (SELECT FactoryTicketId, TicketType, 
                                     FactoryTicketStatus, FactoryTicketCreatedBy,
                                     SupplierType
                                     FROM factoryticket)
                             )t";
  </code></pre>
  
  <p>Plz help me..What is problem in this query..Thanks in advance</p>