Hibernate数据获取

Question

下面是我获取数据的方法：

public static List<SubjectSubjectUsersUsers> getAllSubjectUsers()
    {
        List<SubjectSubjectUsersUsers> theList = null;

        Session session = ServiceLocator.getSessionFactory().openSession();

        try{

            theList = session.createSQLQuery("SELECT s.name as subject_name, u.name as user_name, u.surname as user_surname, su.id as id from subjects s "
                    + "join subject_users su on s.id = su.subject_id join users u on su.user_id = u.id")

                    .addScalar("subject_name", StandardBasicTypes.STRING)
                    .addScalar("user_name", StandardBasicTypes.STRING)
                    .addScalar("user_surname", StandardBasicTypes.STRING)
                    .addScalar("id", StandardBasicTypes.LONG)
                    .setResultTransformer(Transformers.aliasToBean(SubjectSubjectUsersUsers.class)).list();


        }catch(Exception e){

            e.printStackTrace();

        }finally{

            session.flush();
            session.close();

        }


        return theList;
    }

问题是，当我在DB中手动更新数据时，获取的数据没有更改。但是当我重新加载服务器和IDE时，它就可以工作了。问题的原因可能是什么？我想我使用session对象的方式不正确。谢谢。

Answer 1

您需要将CacheMode设置为刷新

query.setCacheMode(CacheMode.REFRESH);

您的查询将如下所示-

theList = session.createSQLQuery("SELECT s.name as subject_name, u.name as user_name, u.surname as user_surname, su.id as id from subjects s "
                    + "join subject_users su on s.id = su.subject_id join users u on su.user_id = u.id")

                    .setCacheMode(CacheMode.REFRESH)
                    .addScalar("subject_name", StandardBasicTypes.STRING)
                    .addScalar("user_name", StandardBasicTypes.STRING)
                    .addScalar("user_surname", StandardBasicTypes.STRING)
                    .addScalar("id", StandardBasicTypes.LONG)
                    .setResultTransformer(Transformers.aliasToBean(SubjectSubjectUsersUsers.class)).list();

然而，在使用hibernate时从outsite更新数据库并不是一个好主意，否则您将无法获得hibernate缓存的好处。