Returning multiple entities and Alias injection names

Query query = getSession().createSQLQuery("select * from reply r join messagebox m on r.messagebox_id = m.id where m.id=? and r.parent_reply_id is null").addEntity(MessageBox.class).addEntity(Reply.class);

这个语句出现了一个问题

在查询

Hibernate: select replies0_.MESSAGEBOX_ID as MESSAGEBOX5_1_1_, replies0_.id as id1_, replies0_.id as id2_0_, replies0_.title as title2_0_, replies0_.content as content2_0_, replies0_.PARENT_REPLY_ID as PARENT4_2_0_, replies0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, replies0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, replies0_.SEND_REPLY_TIME as SEND7_2_0_ from reply replies0_ where replies0_.MESSAGEBOX_ID=?

messagebox_id的参数却写成了reply.id的值(应该是messagebox.id的值)

于是查询文档

18.1.4. Returning multiple entities

Until now, the result set column names are assumed to be the same as the column names specified in the mapping document. This can be problematic for SQL queries that join multiple tables, since the same column names can appear in more than one table.

原来同列名id导致了错误

于是我用

Table 18.1. Alias injection names

Description	Syntax	Example
A simple property	{[aliasname].[propertyname]	A_NAME as {item.name}

修改成了

Query query = getSession().createSQLQuery("select r.id as {reply.id},r.title as {reply.title}, r.content as {reply.content},r.send_reply_person_id as {reply.sendReplyPerson},r.send_reply_time as {reply.sendReplyTime}, r.parent_reply_id as {reply.parentReply},r.messagebox_id as {reply.messageBox},m.id as {messageBox.id},m.name as {messageBox.title},m.content as {messageBox.content},m.sendtime as {messageBox.sendTime},m.sendperson_id as {messageBox.sendPerson},m.getperson_id as {messageBox.getPerson},m.collect as {messageBox.collect},m.rubbish as {messageBox.rubbish},m.canbereplied as {messageBox.canBeReplied} from reply r join messagebox m on r.messagebox_id = m.id where m.id=? and r.parent_reply_id is null").addEntity("messageBox",MessageBox.class).addEntity("reply",Reply.class);

把每个别名.列都 as 给了相应的 {对象名.属性名}