Question

我的hql查询有问题吗?

String queryString = "SELECT A.INITIAL, A.NUMBER, A.OWNR_SCAC , A.INITIAL||A.NUMBER AS CAR," + 
            "A.LESSEE_SCAC, A.TRUK_CNT, A.EQP_TYP_CD, A.AXL_CNT, B.STABILITY_DEV_EQP," +
            "A.C_CNT, A.G_WGT, B.TRUK_AXL_CNT, A.EIN FROM DS.E_UT AS A" +
            "LEFT JOIN DS.E_PRIMARY AS B" +
            "WHERE A.INITIAL||A.NUMBER IN (:carList) AND A.INITIAL IN {:initList) AND A.NUMBER IN (:numberList)" + 
            "AND B.TRUK_AXL_CNT > 0";

错误:

g.hibertate.hql. intern.ast. QuerySyndexcutive: 意想不到的标记: 靠近第1行的第263列

我想这是在 DS.E_UT AS A 之后的 A 。

Answer 1

在 HQL 中,您要提供表格和列名称,而要提供 Java 类名称和成员变量名称(或getter/set) 以及您绘制到表格和列的类别和成员变量名称(或geter/set)。

Answer 2

我认为你应该在每条新线上加点空间

"A.C_CNT, A.G_WGT, B.TRUK_AXL_CNT, A.EIN FROM DS.E_UT AS A" +
"LEFT JOIN DS.E_PRIMARY AS B"

将变成:

A.C_CNT, A.G_WGT, B.TRUK_AXL_CNT, A.EIN FROM DS.E_UT AS ALEFT JOIN DS.E_PRIMARY AS B

注意 ACEFT 注释

Answer 3

我不完全相信你的策略,或者这是你要找的, 但你可以一起绘制您的组合表格。这样可以让事情变得简单一些, 你不需要明确地加入到你的查询中来。

http://tadtech.blogspot.com/2007/02/hiberate-annotation-many-to-one forforeign.html" rel="nofollow"。这里举个小例子

从该示例中抽取的样本查询可能看起来像 :

SELECT p 
    FROM Person 
WHERE p.name like :name 
AND p.address.street like :street

友情链接