mysql - 带有 Select、Order 和 Desc 的 HQL 查询不起作用

Question

我的 Hibernate 查询不返回结果。这有什么问题吗？

long senderId=42461335;
long recipientId=40524960;
Query query = session.createQuery("Select im.ReadTime From InternalMessage im WHERE im.SenderId=:senderId AND im.RecipientId=:recipientId ORDER BY im.Id DESC");
query.setLong("senderId", senderId);
query.setLong("recipientId", recipientId);
query.setMaxResults(1);
InternalMessage result = HibernateQueryUtil.uniqueResult(query, session);

我的查询的 MySQL 版本是:

SELECT read_time FROM InternalMessage WHERE sender_id="42461335" AND recipient_id="40524960" ORDER BY sent_time DESC LIMIT 1;

Answer 1

尝试这个，如果它不起作用，请不要忘记在日志文件中发布控制台日志或错误消息。

  String hql = "Select im.ReadTime From InternalMessage im WHERE im.SenderId=:senderId AND im.RecipientId=:recipientId ORDER BY im.Id DESC";
    Query q = session.createQuery(hql);
    q = session.createQuery(hql);