<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-scale=1.0">
<base href="https://hibernate.atlassian.net">
<title>Message Title</title>
</head>
<body class="jira" style="color: #333333; font-family: Arial, sans-serif; font-size: 14px; line-height: 1.429">
<table id="background-table" cellpadding="0" cellspacing="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; background-color: #f5f5f5; border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt" bgcolor="#f5f5f5">
<!-- header here -->
<tbody>
<tr>
<td id="header-pattern-container" style="padding: 0px; border-collapse: collapse; padding: 10px 20px">
<table id="header-pattern" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tbody>
<tr>
<td id="header-avatar-image-container" valign="top" style="padding: 0px; border-collapse: collapse; vertical-align: top; width: 32px; padding-right: 8px" width="32"> <img id="header-avatar-image" class="image_fix" src="cid:jira-generated-image-avatar-4f7529b4-fcc3-4c42-bea7-4b1975b67bd4" height="32" width="32" border="0" style="border-radius: 3px; vertical-align: top"> </td>
<td id="header-text-container" valign="middle" style="padding: 0px; border-collapse: collapse; vertical-align: middle; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px"> <a class="user-hover" rel="Shoot3R" id="email_Shoot3R" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=Shoot3R" style="color:#6c797f;; color: #3b73af; text-decoration: none">Igor Dmitriev</a> <strong>created</strong> an issue </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="email-content-container" style="padding: 0px; border-collapse: collapse; padding: 0 20px">
<table id="email-content-table" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; border-spacing: 0; border-collapse: separate">
<tbody>
<tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<td class="email-content-rounded-top mobile-expand" style="padding: 0px; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 15px; background-color: #ffffff; border-left: 1px solid #cccccc; border-top: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 0; border-top-right-radius: 5px; border-top-left-radius: 5px; height: 10px; line-height: 10px; padding: 0 15px 0 16px; mso-line-height-rule: exactly" height="10" bgcolor="#ffffff"> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff">
<table class="page-title-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tbody>
<tr>
<td class="page-title-pattern-first-line " style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; padding-top: 10px"> <a href="https://hibernate.atlassian.net/browse/HHH" style="color: #3b73af; text-decoration: none">Hibernate ORM</a> / <a href="https://hibernate.atlassian.net/browse/HHH-10836" style="color: #3b73af; text-decoration: none"><img src="cid:jira-generated-image-avatar-4803d419-6663-4979-85a3-265fba445c22" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"></a> <a href="https://hibernate.atlassian.net/browse/HHH-10836" style="color: #3b73af; text-decoration: none">HHH-10836</a> </td>
</tr>
<tr>
<td style="vertical-align: top;; padding: 0px; border-collapse: collapse; padding-right: 5px; font-size: 20px; line-height: 30px; mso-line-height-rule: exactly" class="page-title-pattern-header-container"> <span class="page-title-pattern-header" style="font-family: Arial, sans-serif; padding: 0; font-size: 20px; line-height: 30px; mso-text-raise: 2px; mso-line-height-rule: exactly; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-10836" style="color: #3b73af; text-decoration: none">Fetch Graph does not work as documented</a> </span> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand wrapper-special-margin" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 10px; padding-bottom: 5px" bgcolor="#ffffff">
<table class="keyvalue-table" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tbody>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Issue Type:</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-avatar-4803d419-6663-4979-85a3-265fba445c22" height="16" width="16" border="0" align="absmiddle" alt="Bug" style="vertical-align: text-bottom"> Bug </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Affects Versions:</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> 5.0.0.Final, 4.3.6 </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Assignee:</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> Unassigned </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Components:</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> hibernate-core </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Created:</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> 12/Jun/2016 04:24 AM </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Labels:</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> entitygraph </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Priority:</th>
<td class="has-icon" style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <img src="cid:jira-generated-image-static-major-1a147255-96ff-4778-b06b-d0184d007c16" height="16" width="16" border="0" align="absmiddle" alt="Major" style="vertical-align: text-bottom"> Major </td>
</tr>
<tr>
<th style="color: #707070; font: normal 14px/20px Arial, sans-serif; text-align: left; vertical-align: top; padding: 2px 0">Reporter:</th>
<td style="padding: 0px; border-collapse: collapse; font: normal 14px/20px Arial, sans-serif; padding: 2px 0 2px 5px; vertical-align: top"> <a class="user-hover" rel="Shoot3R" id="email_Shoot3R" href="https://hibernate.atlassian.net/secure/ViewProfile.jspa?name=Shoot3R" style="color:#6c797f;; color: #3b73af; text-decoration: none">Igor Dmitriev</a> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand issue-description-container" style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff; padding-top: 5px; padding-bottom: 10px" bgcolor="#ffffff">
<table class="text-paragraph-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 2px">
<tbody>
<tr>
<td class="text-paragraph-pattern-container mobile-resize-text " style="padding: 0px; border-collapse: collapse; padding: 0 0 10px 0"> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0; margin-top: 0">Hi. Here is my test shows me that javax.persistence.fetchgraph does not work as documented in java docs(Attributes explicitly specified as AttributeNodes are treated as FetchType.EAGER,attributes that are not specified are treated as FetchType.LAZY:</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Client entity:</p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #cccccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #cccccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; margin-top: 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
@Entity
@Table(name = <span class="code-quote" style="color: #009100">"client"</span>)
@NamedEntityGraphs({
@NamedEntityGraph(name = Client.ACCOUNTS_GRAPH, attributeNodes = @NamedAttributeNode(value = <span class="code-quote" style="color: #009100">"accounts"</span>))
})
@Getter
@Setter
@ToString(of = <span class="code-quote" style="color: #009100">"name"</span>)
<span class="code-keyword" style="color: #000091">public</span> class Client <span class="code-keyword" style="color: #000091">extends</span> BaseEntity<<span class="code-object" style="color: #910091">Integer</span>> {
<span class="code-keyword" style="color: #000091">public</span> <span class="code-keyword" style="color: #000091">static</span> <span class="code-keyword" style="color: #000091">final</span> <span class="code-object" style="color: #910091">String</span> ACCOUNTS_GRAPH = <span class="code-quote" style="color: #009100">"Client.accounts"</span>;
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = <span class="code-quote" style="color: #009100">"c_seq"</span>)
@SequenceGenerator(name = <span class="code-quote" style="color: #009100">"c_seq"</span>, sequenceName = <span class="code-quote" style="color: #009100">"c_seq"</span>, allocationSize = 1)
@Column(name = <span class="code-quote" style="color: #009100">"ID_CLIENT"</span>)
<span class="code-keyword" style="color: #000091">public</span> <span class="code-object" style="color: #910091">Integer</span> id;
@Column(name = <span class="code-quote" style="color: #009100">"NAME"</span>)
@Audited(attribute = AuditAttribute.AGE)
<span class="code-keyword" style="color: #000091">private</span> <span class="code-object" style="color: #910091">String</span> name;
@Column(name = <span class="code-quote" style="color: #009100">"age"</span>)
<span class="code-keyword" style="color: #000091">private</span> <span class="code-object" style="color: #910091">int</span> age;
@OneToMany(mappedBy = <span class="code-quote" style="color: #009100">"client"</span>, cascade = CascadeType.PERSIST)
@Setter(AccessLevel.NONE)
<span class="code-keyword" style="color: #000091">private</span> List<Account> accounts = <span class="code-keyword" style="color: #000091">new</span> ArrayList<>();
@OneToOne(mappedBy = <span class="code-quote" style="color: #009100">"client"</span>, fetch = FetchType.EAGER)
<span class="code-keyword" style="color: #000091">private</span> Passport passport;
@OneToMany(mappedBy = <span class="code-quote" style="color: #009100">"client"</span>, fetch = FetchType.EAGER)
<span class="code-keyword" style="color: #000091">private</span> List<Address> addresses = <span class="code-keyword" style="color: #000091">new</span> ArrayList<>();
<span class="code-keyword" style="color: #000091">public</span> void addAccount(Account account) {
accounts.add(account);
account.setClient(<span class="code-keyword" style="color: #000091">this</span>);
}
}
</pre>
</div>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Main:</p>
<div class="code panel" style="border-width: 1px;; border: 1px solid #cccccc; background: #f5f5f5; font-size: 12px; line-height: 1.333; font-family: monospace; border: 1px solid #cccccc; -moz-border-radius: 3px 3px 3px 3px; border-radius: 3px 3px 3px 3px; margin: 9px 0">
<div class="codeContent panelContent" style="padding: 9px 12px">
<pre class="code-java" style="margin: 10px 0 0 0; margin-top: 0; max-height: 30em; overflow: auto; white-space: pre-wrap; word-wrap: normal">
Map<<span class="code-object" style="color: #910091">String</span>, <span class="code-object" style="color: #910091">Object</span>> hints = <span class="code-keyword" style="color: #000091">new</span> HashMap<>();
hints.put(QueryHints.HINT_FETCHGRAPH, em.getEntityGraph(Client.ACCOUNTS_GRAPH));
em.find(Client.class, 1, hints);
</pre>
</div>
</div> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">Console output:<br> Hibernate:<br> select<br> client0_.id_client as id_clien1_4_0_,<br> client0_.age as age2_4_0_,<br> client0_.name as name3_4_0_,<br> accounts1_.id_client as id_clien3_4_1_,<br> accounts1_.id_account as id_accou1_0_1_,<br> accounts1_.id_account as id_accou1_0_2_,<br> accounts1_.amount as amount2_0_2_,<br> accounts1_.id_client as id_clien3_0_2_ <br> from<br> client client0_ <br> left outer join<br> account accounts1_ <br> on client0_.id_client=accounts1_.id_client <br> where<br> client0_.id_client=1 <br> Hibernate:<br> select<br> passport0_.id_passport as id_passp1_7_0_,<br> passport0_.number as number2_7_0_ <br> from<br> passport passport0_ <br> where<br> passport0_.id_passport=1 <br> Hibernate:<br> select<br> addresses0_.id_client as id_clien4_4_0_,<br> addresses0_.id_address as id_addre1_1_0_,<br> addresses0_.id_address as id_addre1_1_1_,<br> addresses0_.city as city2_1_1_,<br> addresses0_.id_client as id_clien4_1_1_,<br> addresses0_.street as street3_1_1_ <br> from<br> address addresses0_ <br> where<br> addresses0_.id_client=1 </p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0">As we can see LAZY does not work. <br> If I change FETCH_GRAPH to LOAD_GRAPH:</p> <p style="margin-top:0;margin-bottom:10px;; margin: 10px 0 0 0"> select<br> client0_.id_client as id_clien1_4_0_,<br> client0_.age as age2_4_0_,<br> client0_.name as name3_4_0_,<br> accounts1_.id_client as id_clien3_4_1_,<br> accounts1_.id_account as id_accou1_0_1_,<br> accounts1_.id_account as id_accou1_0_2_,<br> accounts1_.amount as amount2_0_2_,<br> accounts1_.id_client as id_clien3_0_2_,<br> addresses2_.id_client as id_clien4_4_3_,<br> addresses2_.id_address as id_addre1_1_3_,<br> addresses2_.id_address as id_addre1_1_4_,<br> addresses2_.city as city2_1_4_,<br> addresses2_.id_client as id_clien4_1_4_,<br> addresses2_.street as street3_1_4_,<br> passport3_.id_passport as id_passp1_7_5_,<br> passport3_.number as number2_7_5_ <br> from<br> client client0_ <br> left outer join<br> account accounts1_ <br> on client0_.id_client=accounts1_.id_client <br> left outer join<br> address addresses2_ <br> on client0_.id_client=addresses2_.id_client <br> left outer join<br> passport passport3_ <br> on client0_.id_client=passport3_.id_passport <br> where<br> client0_.id_client=1</p> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td class="email-content-main mobile-expand " style="padding: 0px; border-collapse: collapse; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-top: 0; border-bottom: 0; padding: 0 15px 0 16px; background-color: #ffffff" bgcolor="#ffffff">
<table id="actions-pattern" cellspacing="0" cellpadding="0" border="0" width="100%" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 1px">
<tbody>
<tr>
<td id="actions-pattern-container" valign="middle" style="padding: 0px; border-collapse: collapse; padding: 10px 0 10px 24px; vertical-align: middle; padding-left: 0">
<table align="left" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tbody>
<tr>
<td class="actions-pattern-action-icon-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 0px; vertical-align: middle"> <a href="https://hibernate.atlassian.net/browse/HHH-10836#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none"> <img class="actions-pattern-action-icon-image" src="cid:jira-generated-image-static-comment-icon-bdfca8c1-fa0b-4aef-845f-6327b98078d9" alt="Add Comment" title="Add Comment" height="16" width="16" border="0" style="vertical-align: middle"> </a> </td>
<td class="actions-pattern-action-text-container" style="padding: 0px; border-collapse: collapse; font-family: Arial, sans-serif; font-size: 14px; line-height: 20px; mso-line-height-rule: exactly; mso-text-raise: 4px; padding-left: 5px"> <a href="https://hibernate.atlassian.net/browse/HHH-10836#add-comment" target="_blank" title="Add Comment" style="color: #3b73af; text-decoration: none">Add Comment</a> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
<!-- there needs to be content in the cell for it to render in some clients -->
<tr>
<td class="email-content-rounded-bottom mobile-expand" style="padding: 0px; border-collapse: collapse; color: #ffffff; padding: 0 15px 0 16px; height: 5px; line-height: 5px; background-color: #ffffff; border-top: 0; border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom-right-radius: 5px; border-bottom-left-radius: 5px; mso-line-height-rule: exactly" height="5" bgcolor="#ffffff"> </td>
</tr>
</tbody>
</table> </td>
</tr>
<tr>
<td id="footer-pattern" style="padding: 0px; border-collapse: collapse; padding: 12px 20px">
<table id="footer-pattern-container" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tbody>
<tr>
<td id="footer-pattern-text" class="mobile-resize-text" width="100%" style="padding: 0px; border-collapse: collapse; color: #999999; font-size: 12px; line-height: 18px; font-family: Arial, sans-serif; mso-line-height-rule: exactly; mso-text-raise: 2px"> This message was sent by Atlassian JIRA <span id="footer-build-information">(v1000.35.1#100001-<span title="4aeecd83f49555e1ee6da2fa274b3f0f28b82223" data-commit-id="4aeecd83f49555e1ee6da2fa274b3f0f28b82223}">sha1:4aeecd8</span>)</span> </td>
<td id="footer-pattern-logo-desktop-container" valign="top" style="padding: 0px; border-collapse: collapse; padding-left: 20px; vertical-align: top">
<table style="border-collapse: collapse; mso-table-lspace: 0pt; mso-table-rspace: 0pt">
<tbody>
<tr>
<td id="footer-pattern-logo-desktop-padding" style="padding: 0px; border-collapse: collapse; padding-top: 3px"> <img id="footer-pattern-logo-desktop" src="cid:jira-generated-image-static-footer-desktop-logo-593c4f24-5e38-4c80-83d5-ed21029025c6" alt="Atlassian logo" title="Atlassian logo" width="169" height="36" class="image_fix"> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table> </td>
</tr>
</tbody>
</table>
</body>
</html>