hi
i cant get multiple column values by using the foll. query.
supplierList=sess.find("select a.id,a.desc,from groupAccount a in(b.msupplier,b.mnumber from supProduct b where a.id=b.supcode)");
when i am using this query in sql directly, i got the answer.
but in session, i cant get the result.
i think i should use the join query or subclass query.
if anybody knows ,give that concept.
when i am using in query method.
i got the following error.
unexpected token in query (i got this error in server)
and iexplore i got the following error
org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
root cause
java.lang.NullPointerException
org.apache.jsp.findProducts_jsp._jspService(findProducts_jsp.java:70)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
javax.servlet.http.HttpServlet.service(HttpServlet.java:810)