• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Paul Clapham
  • Ron McLeod
Sheriffs:
  • Jeanne Boyarsky
  • Liutauras Vilda
Saloon Keepers:
  • Tim Holloway
  • Carey Brown
  • Roland Mueller
  • Piet Souris
Bartenders:

using join query in hibernate

 
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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;
}
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

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.
 
Ranch Hand
Posts: 547
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
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)
 
reply
    Bookmark Topic Watch Topic
  • New Topic