[Hibernate-JIRA] Created: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
2:10 p.m.
Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:44 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
Gail Badner commented on HHH-5143:
----------------------------------
Please attach a runnable test case (Java + mapping) that reproduces this issue.
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:29 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
j nadler commented on HHH-5143:
-------------------------------
Unfortunately that is proving to be quite difficult. I have been working on it nonstop
since your comment. We have a big object model; simply creating two classes with the one
relationship does not reproduce this problem. I tried setting hibernate logging to TRACE
but there does not seem to be any logging around how the decision is made to eagerly load
these properties.
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:54 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
j nadler commented on HHH-5143:
-------------------------------
I can grab the source debug this on my end since it seems difficult to reproduce in a
trivial project. Can anyone suggest where I start looking:
The first thing I'd like to do is to confirm that the properties are being lazy loaded
(rather than being loaded by an event listener related to Hibernate Search, for example).
Where would I add some logging statements to make this clear?
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:56 p.m.
New subject: [Hibernate-JIRA] Issue Comment Edited: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
j nadler edited comment on HHH-5143 at 4/23/10 2:54 PM:
--------------------------------------------------------
I can grab the source and debug this prooblem on my end since it seems difficult to
reproduce in a trivial project. Can anyone suggest where I start looking:
The first thing I'd like to do is to confirm that the properties are being lazy loaded
(rather than being loaded by an event listener related to Hibernate Search, for example).
Where would I add some logging statements to make this clear?
was (Author: jnadler):
I can grab the source debug this on my end since it seems difficult to reproduce in a
trivial project. Can anyone suggest where I start looking:
The first thing I'd like to do is to confirm that the properties are being lazy loaded
(rather than being loaded by an event listener related to Hibernate Search, for example).
Where would I add some logging statements to make this clear?
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
3:41 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
Gail Badner commented on HHH-5143:
----------------------------------
This may be related to HHH-5109. Please take a look at the test case attached to that
issue and see if you can tweak it and reproduce your issue.
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:50 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
j nadler commented on HHH-5143:
-------------------------------
Yes, probably related. Thanks Gail.
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:52 p.m.
New subject: [Hibernate-JIRA] Updated: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
j nadler updated HHH-5143:
--------------------------
Attachment: OneToOneLoadTest.java
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
Attachments: OneToOneLoadTest.java
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:59 a.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
j nadler commented on HHH-5143:
-------------------------------
I tried Shareth's suggestion from HHH-5109 here and it's no help in this case. I
actually don't think HHH-5109 is a real bug (the submitter just forgot the
"optional=false"). Obviously I do think that this one is a real bug, though
I'd be happy to be proven wrong :)
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
Attachments: OneToOneLoadTest.java
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
12:22 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
Gail Badner commented on HHH-5143:
----------------------------------
Both Owner and Owned are mapped with:
@Proxy(lazy=false)
I don't think it is possible to override this setting using:
@LazyToOne(LazyToOneOption.PROXY)
Please try removing @Proxy(lazy=false) on the child entity class.
Thanks,
Gail
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
Attachments: OneToOneLoadTest.java
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:24 p.m.
New subject: [Hibernate-JIRA] Commented: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
j nadler commented on HHH-5143:
-------------------------------
Right on, that does it. I also had to remove the logic in the setter from the HHH-5109
example, because the setter was triggering the Owned class to load.
In googling this I found a significant # of people having similar problems. Tonight
I'll blog a checklist of all the things that have to go right to get a {One|Many}ToOne
lazy. In the meantime it might be worth adding a few trace-level log statements that show
how the determination of lazy-or-not is made; I would have been able to easily figure this
out without hassling you guys.
Thanks!
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
Attachments: OneToOneLoadTest.java
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
1:40 p.m.
New subject: [Hibernate-JIRA] Resolved: (HHH-5143) Lazy Loading Not Working for @OneToOne Associations With LazyToOneOption.PROXY
[
http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143?page=c...
]
Gail Badner resolved HHH-5143.
------------------------------
Assignee: Gail Badner
Resolution: Rejected
If you or someone opens a new issue with a patch for logging this, I'll apply it.
Lazy Loading Not Working for @OneToOne Associations With
LazyToOneOption.PROXY
------------------------------------------------------------------------------
Key: HHH-5143
URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5143
Project: Hibernate Core
Issue Type: Bug
Components: core
Affects Versions: 3.5.1
Environment: Hibernate Core 3.5.1-Final, MySQL 5.1
Reporter: j nadler
Assignee: Gail Badner
Attachments: OneToOneLoadTest.java
I'm using 3.5.1. Two persistent entities, parent and child, are in a one to one
relationship:
In Parent, the reference to Child:
@OneToOne(optional=false, fetch=FetchType.LAZY, cascade={ CascadeType.MERGE,
CascadeType.REMOVE, CascadeType.REFRESH, CascadeType.PERSIST })
@LazyToOne(LazyToOneOption.PROXY)
@JoinColumn(name = "childId")
@ForeignKey(name="FK_Parent_Child")
@IndexedEmbedded()
public Child getChild() {
return child;
}
public void setChild(Child child) {
this.child = child;
}
And in Child, the reference to Parent:
@OneToOne(mappedBy="child", fetch=FetchType.LAZY)
@LazyToOne(LazyToOneOption.PROXY)
@ContainedIn
public Parent getParent() {
return parent;
}
public void setParent(Parent parent) {
this.parent = parent;
}
When I load a Parent entity via HQL, I see three SQL queries:
-one that corresponds to my HQL query
-one that loads Child
-one that loads Parent from the Child's perspective
I'm watching it in JProfiler and it's hurting our app performance significantly
because Child contains LOBs that are rarely needed.
I tried making it a unidirectional association (no reference from Child back to Parent)
but the expensive SQL call (loading Child) still happens. That gets it down to two SQL
queries:
-one that corresponds to my HQL query
-one that loads Child (the expensive one)
We are using the stock javassist proxies and no bytecode enhancement.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://opensource.atlassian.com/projects/hibernate/secure/Administrators....
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5311
days inactive
5317
days old
hibernate-issues@lists.jboss.org
11 comments
2 participants
participants (2)
-
Gail Badner (JIRA) -
j nadler (JIRA)