Grokbase › Groups › Cayenne › user › March 2008
FAQ
Hello,

I want to use left join fetch, but currently Cayenne throws the
following Exception:

java.lang.UnsupportedOperationException: Fetch joins are not yet supported

Does Cayenne support outer joins (I think about a non-EJBQL support)?

Do you have a roadmap for EJBQL?

Thanks,

Laszlo

Search Discussions

  • Andrus Adamchik at Mar 25, 2008 at 3:32 pm ⇧
    Hi there,
    On Mar 25, 2008, at 5:28 PM, Laszlo Sas wrote:

    Hello,

    I want to use left join fetch, but currently Cayenne throws the
    following Exception:

    java.lang.UnsupportedOperationException: Fetch joins are not yet
    supported

    Does Cayenne support outer joins (I think about a non-EJBQL support)?
    Yes, but not the fetch joins.
    Do you have a roadmap for EJBQL?
    Yes, we want to implement it 100%. If you are asking about timelines -
    no, we will not give you any.

    Cheers,
    Andrus
  • Andrus Adamchik at Mar 25, 2008 at 3:36 pm ⇧

    On Mar 25, 2008, at 5:31 PM, Andrus Adamchik wrote:


    Does Cayenne support outer joins (I think about a non-EJBQL support)?
    Yes, but not the fetch joins.
    Sorry... non-EJBQL queries (i.e. SelectQuery) does not support outer
    joins (there are some patches in Jira to support that, but they are
    not integrated). SelectQuery prefetching is analogous to the FETCH
    join...

    Andrus
  • Mike Kienenberger at Mar 26, 2008 at 12:40 am ⇧
    Laszlo,

    CAY-560 is where you can find the patch.
    I'm not using Cayenne 3 yet, so it's only available for 1.2 and 2.0.
    Not sure how hard it would be to migrate the 2.0 patches to 3.0.

    On 3/25/08, Andrus Adamchik wrote:
    On Mar 25, 2008, at 5:31 PM, Andrus Adamchik wrote:


    Does Cayenne support outer joins (I think about a non-EJBQL support)?
    Yes, but not the fetch joins.

    Sorry... non-EJBQL queries (i.e. SelectQuery) does not support outer
    joins (there are some patches in Jira to support that, but they are
    not integrated). SelectQuery prefetching is analogous to the FETCH
    join...


    Andrus
  • Laszlo Sas at Mar 25, 2008 at 3:43 pm ⇧
    Hello Andrus,

    Ok. No timelines. :)

    Can you post me a thread which explains the current support? Or which
    part of the documentation explains outer joins?

    Thanks,

    Laszlo

    Andrus Adamchik írta:
    Hi there,
    On Mar 25, 2008, at 5:28 PM, Laszlo Sas wrote:

    Hello,

    I want to use left join fetch, but currently Cayenne throws the
    following Exception:

    java.lang.UnsupportedOperationException: Fetch joins are not yet
    supported

    Does Cayenne support outer joins (I think about a non-EJBQL support)?
    Yes, but not the fetch joins.
    Do you have a roadmap for EJBQL?
    Yes, we want to implement it 100%. If you are asking about timelines -
    no, we will not give you any.

    Cheers,
    Andrus

    _____________ NOD32 2971 (20080325) Információ _____________

    Az üzenetet a NOD32 antivirus system megvizsgálta.
    http://www.nod32.hu

  • Andrus Adamchik at Mar 25, 2008 at 3:47 pm ⇧

    On Mar 25, 2008, at 5:42 PM, Laszlo Sas wrote:

    Hello Andrus,

    Ok. No timelines. :)

    Can you post me a thread which explains the current support?
    Almost everything is supported. What's missing is this: fetch joins,
    constructors in SELECT, and probably a few more edge cases that we are
    discovering as we go during testing.
    Or which part of the documentation explains outer joins?
    See my second message on OUTER joins.

    Andrus
  • Laszlo Sas at Mar 25, 2008 at 3:57 pm ⇧
    Very promising. :)

    Thanks,

    Laszlo
    Andrus Adamchik írta:
    Almost everything is supported. What's missing is this: fetch joins,
    constructors in SELECT, and probably a few more edge cases that we are
    discovering as we go during testing.
  • Mike Kienenberger at Mar 26, 2008 at 12:42 am ⇧
    Your other short-term option is to use an SQLTemplate()
    On 3/25/08, Laszlo Sas wrote:
    Hello,

    I want to use left join fetch, but currently Cayenne throws the
    following Exception:

    java.lang.UnsupportedOperationException: Fetch joins are not yet supported

    Does Cayenne support outer joins (I think about a non-EJBQL support)?

    Do you have a roadmap for EJBQL?

    Thanks,


    Laszlo
  • Laszlo Sas at Mar 26, 2008 at 8:34 am ⇧
    Thanks!

    Mike Kienenberger írta:
    Your other short-term option is to use an SQLTemplate()

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupuser @
categoriescayenne
postedMar 25, '08 at 3:29p
activeMar 26, '08 at 8:34a
posts9
users3
websitecayenne.apache.org

3 users in discussion

Laszlo Sas: 4 posts Andrus Adamchik: 3 posts Mike Kienenberger: 2 posts

Content

People

Support

Translate

site design / logo © 2023 Grokbase