Re: SQLTemplate & HSQLDB question

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Wed Feb 08 2006 - 11:42:54 EST

  • Next message: Ahmed Mohombe: "Re: Using Cayenne with a GUI Builder"

    On Feb 8, 2006, at 10:47 AM, Bruce Alspaugh wrote:

    > I'm a new user coming from the Hibernate world, so I may not
    > understand the question/response below completely. In a Hibernate
    > mapping file, you can surround table and column names using a
    > single backquote: ` Hibernate will then translate the quote into
    > the one most appropriate for the particular SQL dialect you are
    > using. This makes the uppercase/lowercase match regardless of the
    > DB you are using.
    >
    > Would it make sense to do something similar in Cayenne?
    >
    > Bruce

    In SelectQuery - yes. In SQLTemplate - no. SQLTemplate is just that -
    a textual template used to generate SQL valid for the target DB, but
    Cayenne doesn't attempt to make sense of it or parse the SQL semantics.

    Andrus



    This archive was generated by hypermail 2.0.0 : Wed Feb 08 2006 - 11:42:57 EST