Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

String literal is not properly closed by a double-quote

user545194Mar 5 2012 — edited Mar 5 2012
Hi,

In my Java Class, this message appears:

String literal is not properly closed by a double-quote
LINE: The red part of the statement.

Please help! Thanks!
package demo;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

public class Flights {
	
	private EntityManagerFactory emf;
	 
    private EntityManager getEntityManager() {
        if (emf == null) {
            emf = Persistence.createEntityManagerFactory("Flights");
        }
        return emf.createEntityManager();
    }
 
    public Flights[] getFlights() {
        EntityManager em = getEntityManager();
        try {
            javax.persistence.Query q = em.createQuery("SELECT /*+ INDEX(lh_master_q lh_master_pk)*/ DISTINCT to_char(FD.FLIGHT_DATE, 'DY')||'.'|| FD.FLIGHT_DATE AS DATE_HEADER,
  FD.FLIGHT_DATE AS TRAVEL_DATE,
  B.CITY                       AS LEAVING,
  LM.STD                       AS DEPART,
  C.CITY                       AS ARRIVING,
  LM.STA                       AS ARR,
  LM.FNR                       AS FLIGHT,
  E.CARRIER                    AS AIRLINE,
  LM.ACTYPE                    AS AIRCRAFT,
  LM.ACTYPEFULLNAME            AS EQUIP,
  LM.STD ||' '|| LM.DEP ||' - '|| LM.STA ||' '|| LM.ARR AS SCHEDULE,
  B.CITY ||' - '|| C.CITY AS ROUTE
  MAX(CASE WHEN FA.BOOKING_CLASS = 'S' AND p_num_adt > 1 THEN (ROUND(FA.LH_FARE_EUR, 2)* p_num_adt) END) AS ECONOMY_SAVER,
  MAX(CASE WHEN FA.BOOKING_CLASS = 'H' AND p_num_adt > 1 THEN (ROUND(FA.LH_FARE_EUR, 2)* p_num_adt) END) AS ECONOMY,
  MAX(CASE WHEN FA.BOOKING_CLASS = 'B' AND p_num_adt > 1 THEN (ROUND(FA.LH_FARE_EUR, 2)* p_num_adt) END) AS ECONOMY_FLEXIBLE,
  MAX(CASE WHEN FA.BOOKING_CLASS = 'Z' AND p_num_adt > 1 THEN (ROUND(FA.LH_FARE_EUR, 2)* p_num_adt) END) AS BUSINESS,
  MAX(CASE WHEN FA.BOOKING_CLASS = 'D' AND p_num_adt > 1 THEN (ROUND(FA.LH_FARE_EUR, 2)* p_num_adt) END) AS BUSINESS_FLEXIBLE,
  MAX(CASE WHEN FA.BOOKING_CLASS = 'F' AND p_num_adt > 1 THEN (ROUND(FA.LH_FARE_EUR, 2)* p_num_adt) END) AS FIRST_CLASS
FROM LH_MASTER_Q LM, LH_FLIGHT_DATE FD, AIRPORTS_LOOKUP B, AIRPORTS_LOOKUP C, CARRIERS E, LH_FARES FA, LH_SERVICE_CLASS SC, LH_CABIN_CLASS CC
WHERE LM.ROWNR = FD.FLIGHT_LEG_ID
   AND LM.DEP = FA.FROM_AP
   AND LM.ARR = FA.TO_AP
   AND LM.DEP = B.IATA_CODE
   AND LM.ARR = C.IATA_CODE
   AND LM.AL = E.CARRIER_CODE
   AND FA.BOOKING_CLASS = SC.BKG_CLASS_ID
   AND SC.CABIN_CLASS_ID = CC.CABIN_CLASS_ID
   AND LM.ACTYPE = FD.AIRCRAFT_TYPE
   AND B.CITY_CODE = :p_leaving
   AND C.CITY_CODE = :p_arriving
   AND CC.CABIN_CLASS_NAME = :p_class
   AND E.CARRIER = :p_airline
   AND FD.FLIGHT_DATE = :p_outbound
GROUP BY FD.FLIGHT_DATE,
         to_char(FD.FLIGHT_DATE, 'DY')||'.'|| FD.FLIGHT_DATE,
         B.CITY, 
         LM.STD, 
         C.CITY, 
         LM.STA, 
         LM.FNR,
         E.CARRIER,
         LM.ACTYPE,
         LM.ACTYPEFULLNAME,
         LM.STD ||' '|| LM.DEP ||' - '|| LM.STA ||' '|| LM.ARR,
         B.CITY ||' - '|| C.CITY,
         to_char(FD.FLIGHT_DATE, 'DY')
ORDER BY Depart;");
            return (Flights[]) q.getResultList().toArray(new Flights[0]);
        } finally {
            em.close();
        }
    }
}
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 2 2012
Added on Mar 5 2012
1 comment
2,653 views