e you seeing any anomaly w.r.t.
>>>>> embedded fields in a fetch plan?
>>>>>
>>>>>
>>>>> StevenK wrote:
>>>>>>
>>>>>> I am trying to optomize a query by using fetch groups. One of the
>>>>>> fields I'd like to include in the group is an embedded entity. When
>>>>>> I turn sql tracing on, run my query, and then display the value of
>>>>>> the fields that were returned, I can see that the non-embedded fields
>>>>>> in my entry display without additional selects from the database -
>>>>>> which is exactly what I expect. The embedded fields however generate
>>>>>> a select to the database to get their contents - which I am trying to
>>>>>> avoid by including those fields in the fetch group. Has anyone else
>>>>>> worked with fetch groups and embedded fields? Are their any
>>>>>> restrictions, constraints, or other complications that anyone is
>>>>>> aware of?
>>>>>>
>>>>>> Thanks!
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
--
View this message in context:
http://n2.nabble.com/FetchGroups-and-Embeddable-Fields-tp4200062p4253242.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
t;>>
>>>>> I am trying to optomize a query by using fetch groups. One of the
>>>>> fields I'd like to include in the group is an embedded entity. When I
>>>>> turn sql tracing on, run my query, and then display the value of the
>>>>>
play the value of the
>>>> fields that were returned, I can see that the non-embedded fields in my
>>>> entry display without additional selects from the database - which is
>>>> exactly what I expect. The embedded fields however generate a select
>>>>
te a select to
>>> the database to get their contents - which I am trying to avoid by
>>> including those fields in the fetch group. Has anyone else worked with
>>> fetch groups and embedded fields? Are their any restrictions,
>>> constraints, or other complications that anyone is aware of?
>>>
>>> Thanks!
>>>
>>
>>
>
>
-
Pinaki
--
View this message in context:
http://n2.nabble.com/FetchGroups-and-Embeddable-Fields-tp4200062p4209859.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
ds? Are their any restrictions, constraints, or other
>> complications that anyone is aware of?
>>
>> Thanks!
>>
>
>
--
View this message in context:
http://n2.nabble.com/FetchGroups-and-Embeddable-Fields-tp4200062p4209525.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
traints, or other complications
> that anyone is aware of?
>
> Thanks!
>
-
Pinaki
--
View this message in context:
http://n2.nabble.com/FetchGroups-and-Embeddable-Fields-tp4200062p4208800.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.
ields? Are
their any restrictions, constraints, or other complications that anyone is
aware of?
Thanks!
--
View this message in context:
http://n2.nabble.com/FetchGroups-and-Embeddable-Fields-tp4200062p4200062.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.