Joined: Wed Aug 25, 2004 10:35 am Posts: 3
|
Hibernate version 2.1.4
Data Base mySQL 4.0
I am facing this exception when i tried to make an inner join
String sql= "select a from mypack.mypach2.MyClass as a";
sql+=" inner join mpack3.MyClass2 as b";
Transaction tx = null;
tx = session.beginTransaction();
Query query = session.createQuery(sql);
list = query.list();
tx.commit();
session.connection().close();
session.close();
19:23:43,609 INFO [STDOUT] net.sf.hibernate.QueryException: outer or full join
must be followed by path expression [select a from mypack.mypach2.MyClass as a inner join mpack3.MyClass2 as b
]
at net.sf.hibernate.hql.FromParser.token(FromParser.java:166)
at net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
at net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.ja
va:123)
at net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149
)
at net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138
)
at net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.
java:293)
at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1561)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1532)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at alert.management_alert.Management_Alert_DAO.getAlertsForTheEmployee(M
anagement_Alert_DAO.java:243)
at alert.management_alert.Management_Alert_Session_Bean.getAllAlerts(Man
agement_Alert_Session_Bean.java:207)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
|
|