关于fetch

最新推荐文章于 2020-12-03 16:15:11 发布
最新推荐文章于 2020-12-03 16:15:11 发布
阅读量643 收藏
点赞数
分类专栏： Hibernate
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/wangyuxuan_java/article/details/8742196
版权

打算hql用fetch要注意

Hibernate ignores my outer-join="true" or fetch="join" setting and fetches an association lazily, using n+1 selects!

HQL queries always ignore the setting for outer-join or fetch="join" defined in mapping metadata. This setting applies only to associations fetched usingget() or load(), Criteria queries, and graph navigation. If you need to enable eager fetching for a HQL query, use an explicitLEFT JOIN FETCH.

转自：https://community.jboss.org/wiki/HibernateFAQ-AdvancedProblems?_sscc=t#Hibernate_ignores_my_outerjointrue_or_fetchjoin_setting_and_fetches_an_association_lazily_using_n1_selects

The fetch strategy defined in the mapping document affects:

  • retrieval via get() or load()

  • retrieval that happens implicitly when an association is navigated

  • Criteria queries

  • HQL queries if subselect fetching is used

Irrespective of the fetching strategy you use, the defined non-lazy graph is guaranteed to be loaded into memory. This might, however, result in several immediate selects being used to execute a particular HQL query.

Usually, the mapping document is not used to customize fetching. Instead, we keep the default behavior, and override it for a particular transaction, using left join fetch in HQL. This tells Hibernate to fetch the association eagerly in the first select, using an outer join. In the Criteria query API, you would use setFetchMode(FetchMode.JOIN).

上面解释了什么时候fetch strategy有效，还有一般应该override it for a particular transaction, using left join fetch in HQL

于是我写了

Query query = getSession().createQuery(" from MessageBox m left join fetch  m.replies where m.id=? ");


生成了

Hibernate: select messagebox0_.id as id1_0_, replies1_.id as id2_1_, messagebox0_.name as name1_0_, messagebox0_.content as content1_0_, messagebox0_.sendTime as sendTime1_0_, messagebox0_.sendPerson_id as sendPerson5_1_0_, messagebox0_.getPerson_id as getPerson6_1_0_, messagebox0_.collect as collect1_0_, messagebox0_.canBeReplied as canBeRep8_1_0_, messagebox0_.rubbish as rubbish1_0_, replies1_.title as title2_1_, replies1_.content as content2_1_, replies1_.PARENT_REPLY_ID as PARENT4_2_1_, replies1_.MESSAGEBOX_ID as MESSAGEBOX5_2_1_, replies1_.SEND_REPLY_PERSON_ID as SEND6_2_1_, replies1_.SEND_REPLY_TIME as SEND7_2_1_, replies1_.MESSAGEBOX_ID as MESSAGEBOX5_1_0__, replies1_.id as id0__ from MessageBox messagebox0_ left outer join reply replies1_ on messagebox0_.id=replies1_.MESSAGEBOX_ID where messagebox0_.id=?
10:04:23,764 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402841703db9a129013db9a9eafe0003
10:04:23,795 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:04:23,812 TRACE BasicExtractor:71 - found [402841703db9d94e013db9e869230002] as column [id2_1_]
10:04:23,812 TRACE BasicExtractor:71 - found [ffff] as column [name1_0_]
10:04:23,827 TRACE BasicExtractor:71 - found [1111] as column [content1_0_]
10:04:23,827 TRACE BasicExtractor:71 - found [2013-03-30 12:59:13.331] as column [sendTime1_0_]
10:04:23,827 TRACE BasicExtractor:71 - found [2] as column [sendPerson5_1_0_]
10:04:23,843 TRACE BasicExtractor:71 - found [1] as column [getPerson6_1_0_]
10:04:23,843 TRACE BasicExtractor:71 - found [false] as column [collect1_0_]
10:04:23,843 TRACE BasicExtractor:71 - found [false] as column [canBeRep8_1_0_]
10:04:23,858 TRACE BasicExtractor:71 - found [false] as column [rubbish1_0_]
10:04:23,858 TRACE BasicExtractor:71 - found [zzz] as column [title2_1_]
10:04:23,874 TRACE BasicExtractor:71 - found [zzzz] as column [content2_1_]
10:04:23,874 TRACE BasicExtractor:66 - found [null] as column [PARENT4_2_1_]
10:04:23,874 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:04:23,890 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:04:23,890 TRACE BasicExtractor:71 - found [2013-03-30 14:07:28.882] as column [SEND7_2_1_]
10:04:23,890 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_1_0__]
10:04:23,905 TRACE BasicExtractor:71 - found [402841703db9d94e013db9e869230002] as column [id0__]
10:04:23,905 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:04:23,921 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [id2_1_]
10:04:23,921 TRACE BasicExtractor:71 - found [fffffaaaa] as column [title2_1_]
10:04:23,921 TRACE BasicExtractor:71 - found [aaa] as column [content2_1_]
10:04:23,936 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [PARENT4_2_1_]
10:04:23,936 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:04:23,936 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:04:23,952 TRACE BasicExtractor:71 - found [2013-03-30 21:00:49.149] as column [SEND7_2_1_]
10:04:23,952 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_1_0__]
10:04:23,968 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [id0__]
10:04:23,968 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:04:23,968 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb63fdf80002] as column [id2_1_]
10:04:23,983 TRACE BasicExtractor:71 - found [gaga] as column [title2_1_]
10:04:23,983 TRACE BasicExtractor:71 - found [aa] as column [content2_1_]
10:04:23,983 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [PARENT4_2_1_]
10:04:23,999 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:04:23,999 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:04:24,014 TRACE BasicExtractor:71 - found [2013-03-30 21:02:05.133] as column [SEND7_2_1_]
10:04:24,014 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_1_0__]
10:04:24,030 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb63fdf80002] as column [id0__]
10:04:24,030 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:04:24,030 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [id2_1_]
10:04:24,046 TRACE BasicExtractor:71 - found [sssss] as column [title2_1_]
10:04:24,046 TRACE BasicExtractor:71 - found [ssaasa] as column [content2_1_]
10:04:24,046 TRACE BasicExtractor:71 - found [402841703db9d94e013db9e869230002] as column [PARENT4_2_1_]
10:04:24,061 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:04:24,061 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:04:24,077 TRACE BasicExtractor:71 - found [2013-03-30 14:13:54.344] as column [SEND7_2_1_]
10:04:24,077 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_1_0__]
10:04:24,077 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [id0__]
Hibernate: select author0_.id as id0_0_, author0_.name as name0_0_, author0_.profession as profession0_0_, author0_.sex as sex0_0_, author0_.password as password0_0_, author0_.email as email0_0_, author0_.trade as trade0_0_, author0_.worktime as worktime0_0_, author0_.city as city0_0_, author0_.registtime as registtime0_0_, author0_.enable as enable0_0_ from author author0_ where author0_.id=?
10:04:24,092 TRACE BasicBinder:82 - binding parameter [1] as [BIGINT] - 2
10:04:24,092 TRACE BasicExtractor:71 - found [ss] as column [name0_0_]
10:04:24,108 TRACE BasicExtractor:71 - found [CTO/CIO/技术总监] as column [profession0_0_]
10:04:24,108 TRACE BasicExtractor:71 - found [男] as column [sex0_0_]
10:04:24,124 TRACE BasicExtractor:71 - found [111111] as column [password0_0_]
10:04:24,124 TRACE BasicExtractor:71 - found [wyxz127@163.com] as column [email0_0_]
10:04:24,139 TRACE BasicExtractor:71 - found [金融] as column [trade0_0_]
10:04:24,139 TRACE BasicExtractor:71 - found [在读学生] as column [worktime0_0_]
10:04:24,139 TRACE BasicExtractor:66 - found [null] as column [city0_0_]
10:04:24,155 TRACE BasicExtractor:71 - found [2013-03-25 21:04:24.217] as column [registtime0_0_]
10:04:24,155 TRACE BasicExtractor:71 - found [Y] as column [enable0_0_]
Hibernate: select author0_.id as id0_0_, author0_.name as name0_0_, author0_.profession as profession0_0_, author0_.sex as sex0_0_, author0_.password as password0_0_, author0_.email as email0_0_, author0_.trade as trade0_0_, author0_.worktime as worktime0_0_, author0_.city as city0_0_, author0_.registtime as registtime0_0_, author0_.enable as enable0_0_ from author author0_ where author0_.id=?
10:04:24,170 TRACE BasicBinder:82 - binding parameter [1] as [BIGINT] - 1
10:04:24,170 TRACE BasicExtractor:71 - found [aa] as column [name0_0_]
10:04:24,186 TRACE BasicExtractor:71 - found [CTO/CIO/技术总监] as column [profession0_0_]
10:04:24,186 TRACE BasicExtractor:71 - found [男] as column [sex0_0_]
10:04:24,202 TRACE BasicExtractor:71 - found [111111] as column [password0_0_]
10:04:24,202 TRACE BasicExtractor:71 - found [wyxz125@163.com] as column [email0_0_]
10:04:24,202 TRACE BasicExtractor:71 - found [金融] as column [trade0_0_]
10:04:24,217 TRACE BasicExtractor:71 - found [在读学生] as column [worktime0_0_]
10:04:24,217 TRACE BasicExtractor:66 - found [null] as column [city0_0_]
10:04:24,233 TRACE BasicExtractor:71 - found [2013-03-25 20:50:04.199] as column [registtime0_0_]
10:04:24,233 TRACE BasicExtractor:71 - found [Y] as column [enable0_0_]
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:04:24,248 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402841703db9d94e013db9ee4ad10003
10:04:24,248 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [id2_0_]
10:04:24,264 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [PARENT4_2_1_]
10:04:24,264 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [id1_]
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:04:24,280 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402881e43dbb4d20013dbb63fdf80002
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:04:24,280 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402881e43dbb4d20013dbb62d5480000
10:04:24,295 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb63fdf80002] as column [id2_0_]
10:04:24,295 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [PARENT4_2_1_]
10:04:24,311 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb63fdf80002] as column [id1_]
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:04:24,311 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402841703db9d94e013db9e869230002
10:04:24,326 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [id2_0_]
10:04:24,326 TRACE BasicExtractor:71 - found [402841703db9d94e013db9e869230002] as column [PARENT4_2_1_]
10:04:24,342 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [id1_]


发现left join fetch 直接把messagebox里面的replies都查询出来了而且.list()只生成4个messagebox，每个messagebox里面的replies都加载了(用messagebox.replies()没有在执行查询语句)

而换用

Query query = getSession().createQuery(" from MessageBox m left join  m.replies where m.id=? ");


生成了

Hibernate: select messagebox0_.id as id1_0_, replies1_.id as id2_1_, messagebox0_.name as name1_0_, messagebox0_.content as content1_0_, messagebox0_.sendTime as sendTime1_0_, messagebox0_.sendPerson_id as sendPerson5_1_0_, messagebox0_.getPerson_id as getPerson6_1_0_, messagebox0_.collect as collect1_0_, messagebox0_.canBeReplied as canBeRep8_1_0_, messagebox0_.rubbish as rubbish1_0_, replies1_.title as title2_1_, replies1_.content as content2_1_, replies1_.PARENT_REPLY_ID as PARENT4_2_1_, replies1_.MESSAGEBOX_ID as MESSAGEBOX5_2_1_, replies1_.SEND_REPLY_PERSON_ID as SEND6_2_1_, replies1_.SEND_REPLY_TIME as SEND7_2_1_ from MessageBox messagebox0_ left outer join reply replies1_ on messagebox0_.id=replies1_.MESSAGEBOX_ID where messagebox0_.id=?
10:22:18,729 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402841703db9a129013db9a9eafe0003
10:22:18,745 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:22:18,762 TRACE BasicExtractor:71 - found [402841703db9d94e013db9e869230002] as column [id2_1_]
10:22:18,762 TRACE BasicExtractor:71 - found [ffff] as column [name1_0_]
10:22:18,762 TRACE BasicExtractor:71 - found [1111] as column [content1_0_]
10:22:18,777 TRACE BasicExtractor:71 - found [2013-03-30 12:59:13.331] as column [sendTime1_0_]
10:22:18,777 TRACE BasicExtractor:71 - found [2] as column [sendPerson5_1_0_]
10:22:18,793 TRACE BasicExtractor:71 - found [1] as column [getPerson6_1_0_]
10:22:18,793 TRACE BasicExtractor:71 - found [false] as column [collect1_0_]
10:22:18,793 TRACE BasicExtractor:71 - found [false] as column [canBeRep8_1_0_]
10:22:18,808 TRACE BasicExtractor:71 - found [false] as column [rubbish1_0_]
10:22:18,808 TRACE BasicExtractor:71 - found [zzz] as column [title2_1_]
10:22:18,824 TRACE BasicExtractor:71 - found [zzzz] as column [content2_1_]
10:22:18,824 TRACE BasicExtractor:66 - found [null] as column [PARENT4_2_1_]
10:22:18,824 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:22:18,840 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:22:18,840 TRACE BasicExtractor:71 - found [2013-03-30 14:07:28.882] as column [SEND7_2_1_]
10:22:18,855 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:22:18,855 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [id2_1_]
10:22:18,855 TRACE BasicExtractor:71 - found [fffffaaaa] as column [title2_1_]
10:22:18,871 TRACE BasicExtractor:71 - found [aaa] as column [content2_1_]
10:22:18,871 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [PARENT4_2_1_]
10:22:18,886 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:22:18,886 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:22:18,886 TRACE BasicExtractor:71 - found [2013-03-30 21:00:49.149] as column [SEND7_2_1_]
10:22:18,902 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:22:18,902 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb63fdf80002] as column [id2_1_]
10:22:18,918 TRACE BasicExtractor:71 - found [gaga] as column [title2_1_]
10:22:18,918 TRACE BasicExtractor:71 - found [aa] as column [content2_1_]
10:22:18,933 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [PARENT4_2_1_]
10:22:18,933 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:22:18,949 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:22:18,949 TRACE BasicExtractor:71 - found [2013-03-30 21:02:05.133] as column [SEND7_2_1_]
10:22:18,949 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [id1_0_]
10:22:18,964 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [id2_1_]
10:22:18,964 TRACE BasicExtractor:71 - found [sssss] as column [title2_1_]
10:22:18,964 TRACE BasicExtractor:71 - found [ssaasa] as column [content2_1_]
10:22:18,980 TRACE BasicExtractor:71 - found [402841703db9d94e013db9e869230002] as column [PARENT4_2_1_]
10:22:18,980 TRACE BasicExtractor:71 - found [402841703db9a129013db9a9eafe0003] as column [MESSAGEBOX5_2_1_]
10:22:18,996 TRACE BasicExtractor:71 - found [1] as column [SEND6_2_1_]
10:22:18,996 TRACE BasicExtractor:71 - found [2013-03-30 14:13:54.344] as column [SEND7_2_1_]
Hibernate: select author0_.id as id0_0_, author0_.name as name0_0_, author0_.profession as profession0_0_, author0_.sex as sex0_0_, author0_.password as password0_0_, author0_.email as email0_0_, author0_.trade as trade0_0_, author0_.worktime as worktime0_0_, author0_.city as city0_0_, author0_.registtime as registtime0_0_, author0_.enable as enable0_0_ from author author0_ where author0_.id=?
10:22:19,011 TRACE BasicBinder:82 - binding parameter [1] as [BIGINT] - 2
10:22:19,011 TRACE BasicExtractor:71 - found [ss] as column [name0_0_]
10:22:19,027 TRACE BasicExtractor:71 - found [CTO/CIO/技术总监] as column [profession0_0_]
10:22:19,027 TRACE BasicExtractor:71 - found [男] as column [sex0_0_]
10:22:19,042 TRACE BasicExtractor:71 - found [111111] as column [password0_0_]
10:22:19,042 TRACE BasicExtractor:71 - found [wyxz127@163.com] as column [email0_0_]
10:22:19,058 TRACE BasicExtractor:71 - found [金融] as column [trade0_0_]
10:22:19,058 TRACE BasicExtractor:71 - found [在读学生] as column [worktime0_0_]
10:22:19,074 TRACE BasicExtractor:66 - found [null] as column [city0_0_]
10:22:19,074 TRACE BasicExtractor:71 - found [2013-03-25 21:04:24.217] as column [registtime0_0_]
10:22:19,089 TRACE BasicExtractor:71 - found [Y] as column [enable0_0_]
Hibernate: select author0_.id as id0_0_, author0_.name as name0_0_, author0_.profession as profession0_0_, author0_.sex as sex0_0_, author0_.password as password0_0_, author0_.email as email0_0_, author0_.trade as trade0_0_, author0_.worktime as worktime0_0_, author0_.city as city0_0_, author0_.registtime as registtime0_0_, author0_.enable as enable0_0_ from author author0_ where author0_.id=?
10:22:19,089 TRACE BasicBinder:82 - binding parameter [1] as [BIGINT] - 1
10:22:19,105 TRACE BasicExtractor:71 - found [aa] as column [name0_0_]
10:22:19,105 TRACE BasicExtractor:71 - found [CTO/CIO/技术总监] as column [profession0_0_]
10:22:19,120 TRACE BasicExtractor:71 - found [男] as column [sex0_0_]
10:22:19,120 TRACE BasicExtractor:71 - found [111111] as column [password0_0_]
10:22:19,136 TRACE BasicExtractor:71 - found [wyxz125@163.com] as column [email0_0_]
10:22:19,136 TRACE BasicExtractor:71 - found [金融] as column [trade0_0_]
10:22:19,136 TRACE BasicExtractor:71 - found [在读学生] as column [worktime0_0_]
10:22:19,152 TRACE BasicExtractor:66 - found [null] as column [city0_0_]
10:22:19,152 TRACE BasicExtractor:71 - found [2013-03-25 20:50:04.199] as column [registtime0_0_]
10:22:19,167 TRACE BasicExtractor:71 - found [Y] as column [enable0_0_]
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:22:19,167 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402841703db9d94e013db9ee4ad10003
10:22:19,183 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [id2_0_]
10:22:19,183 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [PARENT4_2_1_]
10:22:19,198 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [id1_]
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:22:19,198 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402881e43dbb4d20013dbb63fdf80002
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:22:19,214 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402881e43dbb4d20013dbb62d5480000
10:22:19,230 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb63fdf80002] as column [id2_0_]
10:22:19,230 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb62d5480000] as column [PARENT4_2_1_]
10:22:19,230 TRACE BasicExtractor:71 - found [402881e43dbb4d20013dbb63fdf80002] as column [id1_]
Hibernate: select childrenre0_.PARENT_REPLY_ID as PARENT4_2_1_, childrenre0_.id as id1_, childrenre0_.id as id2_0_, childrenre0_.title as title2_0_, childrenre0_.content as content2_0_, childrenre0_.PARENT_REPLY_ID as PARENT4_2_0_, childrenre0_.MESSAGEBOX_ID as MESSAGEBOX5_2_0_, childrenre0_.SEND_REPLY_PERSON_ID as SEND6_2_0_, childrenre0_.SEND_REPLY_TIME as SEND7_2_0_ from reply childrenre0_ where childrenre0_.PARENT_REPLY_ID=?
10:22:19,245 TRACE BasicBinder:82 - binding parameter [1] as [VARCHAR] - 402841703db9d94e013db9e869230002
10:22:19,245 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [id2_0_]
10:22:19,261 TRACE BasicExtractor:71 - found [402841703db9d94e013db9e869230002] as column [PARENT4_2_1_]
10:22:19,261 TRACE BasicExtractor:71 - found [402841703db9d94e013db9ee4ad10003] as column [id1_]


但是注意：

生成了4个object[2]对象， 而每个object[2]里面是messagebox（其中replies没有加载，使用getreplies()继续查询）和reply（其中childrenreplies已加载，点击reply.getChildrenReply()不再查询，由reply的childrenreplies设定）

所以说明 join fetch 直接查询了所有m.replies而只用join则用到replies才查询。
王奕然
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
FetchAPIsandbox:这是一个关于 Fetch API 的介绍性项目。 创建 Fetch API Sandbox 以从本地资源和远程 API 获取数据。 我们已经从 JSONPlaceholder (From public API) 获取数据。 该项目的目的是了解 JavaScript 的重要概念，如 Fetch API、promise、函数（箭头函数）、回调、文档对象模型（DOM）
08-05
这是一个关于 Fetch API 的介绍性项目。 创建 Fetch API Sandbox 以从本地资源和远程 API 获取数据。 我们已经从 JSONPlaceholder (From public API) 获取数据。该项目的目的是了解 JavaScript 的重要概念，如 Fetch...
关于Fetch
悦.L的博客
10-21 847
关于FetchFetch是什么？Fetch 的核心是什么？Fetch与ajax的区别Fetch中Request的接构造方法参数 Fetch是什么？ Fetch 是一个现代的概念, 等同于 XMLHttpRequest，它提供了许多与XMLHttpRequest相同的功能。 Fetch 的核心是什么？ Fetch 的核心在于对 HTTP 接口的抽象，包括 Request，Response，Headers，Body，以及用于初始化异步请求的 global fet Fetch与ajax的区别 1、当接收到一个代表
IOS free版向正式版传递数据的方法
风---的专栏
07-07 2031
第一步：在setting里面点击某行调用下面的方法 #ifdef CONTRACTIONM_FREE_2_0_ else if (indexPath.section == 2) { //查询contaactions数据，并把正在进行的数据保存进数据库 [self fetchedResultsController]; self.contr
Hibernate中OneToOne延时加载的问题-解决方案
点火三周的专栏
08-16 1523
在上一篇文章中我们已经解释了延迟加载的问题。那我们该如何解决？ 我觉得该分两个方面来讨论。 如果这是一个新的项目，在发布之前我们有足够的时间来修改数据的映射和关联关系、以及已经存在的sql语句，或者我们可以更改客户的数据库，并且不存在复杂的数据关系，可以做数据更新。那么我们可以通过修改两端的关联关系来解决这个问题。 但如果这是一个老的项目，已经发布，并且客户那里有大量的数据，那么建议是通过增加
到底怎么查看Hibernate生成SQL中的参数值？
lanyotechcs的专栏
08-28 3555
在网上可能很多人问到到底怎么查看hibernate生成的SQL参数值，可以看到非常多的方法，最多的就是说下载一个P6SPY来查看，其实只要自己看看hibernate的源代码，就可以发现，hibernate所有的参数值的设置都是交由org.hibernate.type.descriptor.ValueBinder接口上的bind方法进行绑定。而在ValueBinder的子类BasicBinder的b
Fetch的理解和使用
zyz00000000的博客
12-03 5150
Abstract摘要： 1、Fetch的官方规范文档：https://fetch.spec.whatwg.org/ 2、Fetch API提供了一个 JavaScript 接口，优化了http请求和响应的操作方式。这种功能以前是使用XMLHttpRequest（ajax）实现的。它还提供了一个全局fetch()方法，该方法提供了一种简单，合理的方式来跨网络异步获取资源。 3、fetch最大的特点是与Promise对象的结合，Fetch API大多都返回一个Promise对象，使我们的编程风格...
Fetch
03-19
··目录关于该项目我们有一个梦想，那个梦想就是拥有一个您可以在白天或黑夜随时访问的站点，并查看成千上万的狗图片！！！谁不喜欢这个主意！使用我们的顶级图像识别软件，我们可以验证每张照片确实包含狗的图像。...
fetch_features
03-16
fetch_features 为了运行此脚本，您需要python3。...关于fetch_features.py 功能： 从Genebank登录号列表或BioSample号列表中获取信息。 程序读取列表的登录号或BioSample编号。 然后，它进入nuccore数据库，并在
cache of the Session flush clear
04-02 627
21.3. Managing the caches Whenever you pass an object to save(), update() or saveOrUpdate(), and whenever you retrieve an object usingload(),get(),list(),iterate() or scroll(), that object i
显示出Hibernate查询语句的绑定参数值
wangshfa的专栏
07-17 9684
在使用 Hibernate 进行数据库操作的时候可以显示出所执行的 SQL 语句，相信用 Hibernate 的兄弟姐妹们都知道怎么设置。就设置 hibernate.show_sql  或者 show_sql 属性为 true 就行，在 hibernate.cfg.xml 或者与 Spring 集成时配置在 Spring 的配置文件中。再就是要让显示的 SQL 语句是格式化的，就配置 hibern
fetch详解
热门推荐
宁静致远
08-17 1万+
在 JS 中使用 fetch 更加高效地进行网络请求 在前端快速发展地过程中，为了契合更好的设计模式，产生了 fetch 框架，此文将简要介绍下 fetch 的基本使用。 我的源博客地址：http://blog.parryqiu.com/2016/03/02/using_fetch_in_nodejs/ 免费的高质量软件开发视频教程 https://devopen.clu
微擎公共系统函数
我是左小皓
04-23 2886
1.获取指定公众号信息 文件路径：/framework/class/account/account.class.php $accountApi = WeAccount::create($_W['uniacid']); $accountInfo = $accountApi->fetchAccountInfo(); 2.获取指定公众号的各项设置参数 文件路径：/framework...
JBOSS连接池调优—合理的设置fetchsize
01-16 1539
1. 什么是fetchsize？ 1.1 Oracle中的fetchsize 先来简单解释一下，当我们执行一个SQL查询语句的时候，需要在客户端和服务器端都打开一个游标，并且分别申请一块内存空间，作为存放查询的数据的一个缓冲区。这块内存区，存放多少条数据就由fetchsize来决定，同时每次网络包会传送fetchsize条记录到客户端。应该很容易理解，如果fetchsize设...
springBoot中使用sping data JPA控制台打印sql以及参数
学无止境
11-21 3380
springBoot中使用sping data JPA控制台打印sql以及参数 开始看了几篇步骤都比较繁琐，将问题复杂化了 直接再spingBoot得配置文件中添加以下内容： logging.level.org.hibernate.type.descriptor.sql.BasicBinder=trace 效果如下： binding parameter [1] as [VARCHAR] -[...
灵活控制 Hibernate 的日志或 SQL 输出，以便于诊断
03-29 1060
我们在使用 Hibernate 时一般只会关注是否显示生成的 SQL 语句，不过有些时候还不够。默认时 Hibernate 执行的 SQL 语句是打印在控制台上的，它也可以配置为输出给 Log4J 或是 Log4Back，还能显示出更详细的参数和取值信息。这里简单讲来。 Hibernate 的配置文件 hibernate.cfg.xml 里提供有三个有关显示 SQL 的配置项，如果是与 Spri
java.lang.ClassCastException: java.lang.String cannot be cast to java.sql.Clob
03-26 1万+
clob, blob    Type mappings for the JDBC classes java.sql.Clob andjava.sql.Blob. These types can be inconvenient for some applications, since the blob or clob object cannot be reused outside of a tr
org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of com
01-29 1625
org.hibernate.PropertyAccessException: IllegalArgumentException occurred while calling setter of com.yuxuan.model.Application.applicationInfo 找到 com.yuxuan.model.Application类中的applicationInfo属性，看看和h
composite-id用法
02-16 1445
public class SysPopedom { private SysPopedomId id; private Integer sort; private String title; private String popedomName; public String getPopedomName() { return popedomName; } public void s
hibernate 多对一 存id就可以了
02-19 1427
比如多个客户对应一个用户 public class Company{ private SysUser sysUser; } 在add.jsp页面   我当时想的是 save(){ SysUser sysUser = session.get(SysUser.class,Integer.parseInt(userid.trim())); company.setSysUser(
fetch agent
最新发布
12-07
fetch agent是一种用于在Node.js中设置代理的方法。在使用fetch进行网络请求时，可以通过设置agent选项来指定代理。以下是一个使用fetch agent的例子： ```javascript const fetch = require('node-fetch'); const ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值