[jboss-user] [EJB 3.0] - LEFT OUTER JOIN problem
zengchuan
do-not-reply at jboss.com
Mon Nov 6 23:21:58 EST 2006
I use jboss4.0.4RC1.
Code:
sql = "SELECT c.id ,c.centerId ,c.centerName ,c.centerFullName ,c.address1 ,c.address2 ,c.zipCode ,c.tel1 ,c.tel2 ,c.fax ,c.homepage ,c.parentCenterId ,c.remark ,d.centerName FROM M_Center c LEFT OUTER JOIN M_Center d ON c.parentCenterId = d.centerId ORDER BY c.levelDesc ";
List data = manager.createQuery(sql).getResultList();
Then problem happend:
12:14:18,296 ERROR [PARSER] line 1:228: unexpected token: ON
12:14:18,312 ERROR [[ZCZ0001Action]] Servlet.service() for servlet ZCZ0001Action threw exception
javax.ejb.EJBTransactionRolledbackException: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ON near line 1, column 228 [ SELECT c.id ,c.centerId ,c.centerName ,c.centerFullName ,c.address1 ,c.address2 ,c.zipCode ,c.tel1 ,c.tel2 ,c.fax ,c.homepage ,c.parentCenterId ,c.remark ,d.centerName FROM com.zeng.db.M_Center c LEFT OUTER JOIN M_Center d ON c.parentCenterId = d.centerId ORDER BY c.levelDesc ]
at org.jboss.ejb3.tx.Ejb3TxPolicy.handleInCallerTx(Ejb3TxPolicy.java:89)
...
How can I do for the sql?
View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3983623#3983623
Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3983623
More information about the jboss-user
mailing list