Re: [JIRA] Commented: (CAY-560) Add support for outer joins

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Jun 13 2007 - 08:16:01 EDT

  • Next message: Andrus Adamchik: "Fwd: Call for Papers Opens for OS Summit Asia 2007"

    On Jun 12, 2007, at 7:04 PM, Mike Kienenberger wrote:

    > As long as 3.0 query translation logic isn't exceedingly divergent
    > from 1.2, I should be able to port my patch to it.

    An algorithm note. While we are not yet rewriting SelectQuery
    translator (so that's an FYI), in EJBQL work I find it very helpful
    to convert the object query to n intermediate SQLTemplate, instead of
    converting it to SQL directly. This allows to define parameters in
    the generated SQL and use Velocity directives. Makes the translator
    code much cleaner, and results in the PreparedStatement code reuse.
    On the downside, that's an extra step in the query pipeline, so there
    may be a performance hit.

    Andrus



    This archive was generated by hypermail 2.0.0 : Wed Jun 13 2007 - 08:16:24 EDT