I tried to left outer join Project table and Activity table using HQL. But i got the following error... details as shown below. Plz help me out this incertitued.
Hibernate version:3.0.5
Code between sessionFactory.openSession() and session.close():
Code:
String qry ="";
qry = "from net.test.ProjectPOJO left outer join net.test.TS_ActivityPOJO";
Query query = HibernateUtil.getSession().createQuery(qry);
System.out.println("Size::::"+query.list().size());
HibernateUtil.closeHibernateSession();
Full stack trace of any exception that occurs:Code:
java.lang.NullPointerException
at org.hibernate.hql.ast.HqlSqlWalker.createFromJoinElement(HqlSqlWalker.java:264)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.joinElement(HqlSqlBaseWalker.java:3022)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElement(HqlSqlBaseWalker.java:2841)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromElementList(HqlSqlBaseWalker.java:2719)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.fromClause(HqlSqlBaseWalker.java:513)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.query(HqlSqlBaseWalker.java:371)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.selectStatement(HqlSqlBaseWalker.java:201)
at org.hibernate.hql.antlr.HqlSqlBaseWalker.statement(HqlSqlBaseWalker.java:151)
at org.hibernate.hql.ast.QueryTranslatorImpl.analyze(QueryTranslatorImpl.java:189)
at org.hibernate.hql.ast.QueryTranslatorImpl.doCompile(QueryTranslatorImpl.java:130)
at org.hibernate.hql.ast.QueryTranslatorImpl.compile(QueryTranslatorImpl.java:83)
at org.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:427)
at org.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:884)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:834)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at net.assyst.peopleplus.dao.TestJoin.main(TestJoin.java:21)
Exception in thread "main"
Name and version of the database you are using: Sybase Adaptive Server Enterprise 11.9.2.3
The generated SQL (show_sql=true): none
Login
FAQ
Search