This EJB QL query is returning null, when it should not. Can someone point me in the right direction. What is wrong with my EJB QL query?
And i call it from the struts action. Thanks in advance. public java.util.List findTrip(String placefrom, String placeto) throws Exception{ | List q = null; | try { | | q = (List) em.createQuery("SELECT OBJECT(b) FROM Bookingline b WHERE " + | "b.bkLPlaceFrom = :sessionName AND b.bkLPlaceTo " + | "= :sessionName2").setParameter("sessionName",placefrom) | .setParameter("sessionName2",placeto).getResultList(); | | } catch (NoResultException en) { | | en.printStackTrace(); // just to be sure, maintain this enabled until finish debugging. | return q = null; | } catch(Exception ex) { | ex.printStackTrace(); // just for debugging. You will find errors like missing space between WHERE and clauses... | throw ex; // just rethrow exception... | } | | return q; | } | | | public java.util.List tripSearch(String placefrom, java.lang.String placeto) throws Exception { | List q = null; | | q = findTrip(placefrom,placeto); | | System.err.println(q==null?"tripSearchReturned NULL":"tripSearch returned "+q.size()); | | | | return q; | } | /* | * BookingLineAction.java | * | * Created on 04 June 2006, 14:11 | */ | | package com.myapp.struts; | | import entity.Bookingline; | import javax.servlet.http.HttpServletRequest; | import javax.servlet.http.HttpServletResponse; | import javax.servlet.http.HttpSession; | import org.apache.commons.beanutils.BeanUtils; | | import org.apache.struts.action.Action; | import org.apache.struts.action.ActionForm; | import org.apache.struts.action.ActionMapping; | import org.apache.struts.action.ActionForward; | /** | * | * @author Other | * @version | */ | | | public class BookingLineAction extends Action { | | //User selects Destination and Arrival, Action calls EJB which searches | //databases for trips that match destination and arrival. Forwards results | //page which displays trips available with that destination. | | /* forward name="success" path="" */ | private final static String SUCCESS = "success"; | private final static String FAIL = "fail"; | | /** | * This is the action called from the Struts framework. | * @param mapping The ActionMapping used to select this instance. | * @param form The optional ActionForm bean for this request. | * @param request The HTTP Request we are processing. | * @param response The HTTP Response we are processing. | * @throws java.lang.Exception | * @return | */ | public ActionForward execute(ActionMapping mapping, ActionForm form, | HttpServletRequest request, HttpServletResponse response) | throws Exception { | | BookingLineActionForm bookinglineform = (BookingLineActionForm) form; // get the form bean | Bookingline bookingline = new Bookingline(); | //ArrayList mylist = new ArrayList(); | bookingline = null; | | String placefrom = bookinglineform.getBkLPlaceFrom(); | String placeto = bookinglineform.getBkLPlaceTo(); | | | bookingline = lookupBookinglineFacade().tripSearch(placefrom,placeto); | | //BeanUtils.copyProperties(bookingline,lookupBookinglineFacade().tripSearch(placefrom,placeto)); | if (bookingline == null) { | return mapping.findForward(FAIL); | } | | request.setAttribute("bookingList", bookingline); | //HttpSession session = request.getSession(); | //request.setAttribute("bookingList",lookupBookinglineFacade().tripSearch(placefrom,placeto)); | | | return mapping.findForward(SUCCESS); | } | | private session.BookinglineFacadeLocal lookupBookinglineFacade() { | try { | javax.naming.Context c = new javax.naming.InitialContext(); | return (session.BookinglineFacadeLocal) c.lookup("java:comp/env/ejb/BookinglineFacade"); | } catch(javax.naming.NamingException ne) { | java.util.logging.Logger.getLogger(getClass().getName()).log(java.util.logging.Level.SEVERE,"exception caught" ,ne); | throw new RuntimeException(ne); | } | } | } View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3950079#3950079 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3950079 _______________________________________________ JBoss-user mailing list JBoss-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-user