SQL在玩游戏!框架
问题描述:
我有以下这在SQL软件(HeidiSQL)完美运行SQLSQL在玩游戏!框架
SELECT gl2.documentNumber, gl2.debitAmount, gl2.creditAmount,
gl2.account, gl2.description FROM GeneralLedger AS gl1
LEFT JOIN GeneralLedger AS gl2
ON gl1.documentNumber = gl2.documentNumber
WHERE gl1.account='911' AND gl2.account <> '911';
当将其放置进场!控制器,我用这个:
String queryPL = "SELECT gl2.documentNumber, gl2.debitAmount, gl2.creditAmount, "
+ "gl2.account, gl2.description FROM GeneralLedger AS gl1 "
+ "LEFT JOIN GeneralLedger AS gl2 "
+ "ON gl1.documentNumber = gl2.documentNumber "
+ "WHERE gl1.account='911' AND gl2.account <> '911'";
Query query = JPA.em().createQuery(queryPL);
List<Object[]> profitAndLoss = query.getResultList();
接收的错误:
IllegalArgumentException occured : org.hibernate.hql.ast.QuerySyntaxException: unexpected token: ON near line 1, column 156 [SELECT gl2.documentNumber, gl2.debitAmount, gl2.creditAmount, gl2.account, gl2.description FROM models.GeneralLedger AS gl1 LEFT JOIN GeneralLedger AS gl2 ON gl1.documentNumber = gl2.documentNumber WHERE gl1.account='911' AND gl2.account <> '911']
我修改了HQL到
String queryPL = "SELECT gl2.documentNumber, gl2.debitAmount, gl2.creditAmount, "
+ "gl2.account, gl2.description FROM models.GeneralLedger AS gl1 "
+ "LEFT OUTER JOIN models.GeneralLedger AS gl2 "
+ "WITH gl1.documentNumber = gl2.documentNumber "
+ "WHERE gl1.account='911' AND gl2.account <> '911'";
Query query = JPA.em().createQuery(queryPL);
List<Object[]> profitAndLoss = query.getResultList();
,仍然收到错误:
IllegalStateException occured : DOT node with no left-hand-side!
所以我该如何解决这个问题?
答
为了能够在HQL中的两个实体之间建立连接,您需要在这两个实体之间建立关联。在任何情况下,你都不能在两个不相关的实体之间进行连接,就像你可以在SQL中一样。在Hibernate documentation中详细描述了HQL及其加入功能。
如果您确实需要这种类型的联接,请使用本机查询。
谢谢。我只是将createQuery修改为CreateNativeQuery,并在查询语句中进行了一些小调整(使用HeidiSQL中的原始调整,现在可以工作。 – 2012-04-29 23:44:21