Re: [eclipselink-users] OneToOne always results in two selects

[Tom Ware <tom.ware@xxxxxxxxxx>]

Weaving will be automatically enabled on any Java EE compliant server (GlassFish 
is one)

-Tom

On 04/11/2011 4:23 AM, Leon Derks wrote:
> Hello Tom,
>
> Thank you!
>
> Do I also need to enable weaving when I run my application in a JEE application server like glassfish?
>
> regards,
> Leon
>
>
>
>
> On Nov 3, 2011, at 1:38 PM, Tom Ware wrote:
>
> > The most likely reason you see two selects is that in order to get LAZY loading to work, you need to enable weaving.
> >
> > http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_%28ELUG%29#Using_EclipseLink_JPA_Weaving
> >
> >
> > On 03/11/2011 8:34 AM, Leon Derks wrote:
> > > Hello
> > >
> > > I have a problem with my OneToOne relationship., which always results in two
> > > selects.
> > >
> > > This is my query: select up from UserProfile up where up.profileCode = :profileCode
> > >
> > >
> > > This is my (simplified) UserProfile Class:
> > >
> > > public class UserProfile extends BaseEntity {
> > >
> > > @Column(name = "PROFILE_CODE", nullable = false, unique=true)
> > > privateString profileCode;
> > >
> > > @OneToOne(fetch=FetchType.LAZY, optional=false)
> > > @JoinColumn(name="USER_ID", unique=true, nullable=false)
> > > private User user = new User();
> > > }
> > >
> > > These are the SQL Queries:
> > >
> > > SELECT ID, PROFILE_CODE, USER_ID FROM USER_PROFILES WHERE (PROFILE_CODE = ?)
> > > SELECT ID, EMAIL, GENDER, INITIALS, LAST_NAME, PHONE_NUMBER, SIGNUP_DATE, CITY,
> > > HOUSE_NUMBER, POSTCODE, STREET FROM USERS WHERE (ID = ?)
> > >
> > > No matter what I do (FetchType.Lazy, optional=false etc), Eclipselink always
> > > generates 2 selects.
> > > What I want is just one select for the UserProfile with the profileCode!
> > >
> > > Can somebody explain to me why there is always an additional select for the user
> > > object?
> > >
> > > Thank you!
> > > Leon
> > >
> > >
> > >
> > > _______________________________________________
> > > eclipselink-users mailing list
> > > eclipselink-users@xxxxxxxxxxx
> > > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
> > _______________________________________________
> > eclipselink-users mailing list
> > eclipselink-users@xxxxxxxxxxx
> > https://dev.eclipse.org/mailman/listinfo/eclipselink-users
>
> _______________________________________________
> eclipselink-users mailing list
> eclipselink-users@xxxxxxxxxxx
> https://dev.eclipse.org/mailman/listinfo/eclipselink-users