java - Hibernate 中带参数的 createSQLQuery

Question

我正在尝试运行这个:

..
String modelTableName = (model == TableModelType.RING) ? "RING_PLAYERS" : "TOURNY_PLAYERS";

List<Object[]> results = dbs.createSQLQuery("SELECT group_level, COUNT(group_level) FROM :modelTableName WHERE game_id=:gameId GROUP BY group_level")
                .addScalar("group_level", Hibernate.INTEGER)
                .addScalar("COUNT(group_level)", Hibernate.LONG)
                .setString("modelTableName", getModelTableName())
                .setInteger("gameId", getGameId())
                .list();

它给出了一个异常(exception):

Caused by: java.sql.SQLException: ORA-00903: invalid table name

如果我写“RING_PLAYERS”而不是“:tableModelName”，那么它就可以了!

我这个参数做错了什么？

谢谢。

Answer 1

根据这个答案，不能注入(inject)表名:Table name as parameter in HQL

您可能必须将其构造为:

List<Object[]> results = dbs.createSQLQuery("SELECT group_level, COUNT(group_level) FROM " + getModelTableName() + " WHERE game_id=:gameId GROUP BY group_level")
                .addScalar("group_level", Hibernate.INTEGER)
                .addScalar("COUNT(group_level)", Hibernate.LONG)
                .setInteger("gameId", getGameId())
                .list();