using join query in hibernate

[bamini mini]

hi

i want to get records from two tables by using join query.
but i got the queryexception error.
i can't get the multiple column values from two tables.
how i will write the select query for getting records from two tables.
pl. help me(if possible)

i give the java files below.


public List getSupforProducts(String prdcode)
{
try
{
SessionFactory sf=HibernateEnvironment.getSessionFactory();
Session sess=sf.openSession();
List supplierList=sess.find("select a.id,a.descfrom groupAccountin(,b.msupplier,b.mnumber from supProduct b where a.id=b.supcode");
Transaction tx = sess.beginTransaction();
tx.commit();
sess.close();
}catch(Exception CreateException){
CreateException.printStackTrace();
}
supplierList;
}

[Paul Sturrock]

select a.id,a.descfrom groupAccountin(,b.msupplier,b.mnumber from supProduct b where a.id=b.supcode

Your exception is probably because this query is a bit of a mess. I'd try to write the query directly in SQL in whatever DB tool you have. You'll get pointers from the DB as to what's wrong.

[pascal betz]

can you show the exception you got ?

btw: SessionFactory is an expensive Object to create ! You should not create it every method call. Instead keep it somewhere and jsut create new Sessions. Check out the hibernate wiki pages for some receomendations.

pascal

[bamini mini]

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)