Re: Reserverd words mapping question

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Nov 11 2010 - 14:24:42 UTC

  • Next message: casiyatrucha-cayenn..ahoo.com: "Re: Reserverd words mapping question"

    Looks like a bug to me. Appreciate if you could open a bug report, we'll take a look:

    https://issues.apache.org/jira/browse/CAY

    Thanks,
    Andrus

    On Nov 11, 2010, at 7:38 AM, Lautaro Brasseur wrote:

    > Hi. I need to map a database schema which has reserverd words in column names
    > (with Cayenne 3.0 nad MSSQLServer). For example, the USER table has a column
    > called GROUP.
    >
    > I solved partially the problem, by setting Cayenne to quote identifiers:
    >
    > DataMap dataMap = new DataMap(DUMMY_NAME);
    > dataMap.setQuotingSQLIdentifiers(true);
    >
    > but this just quotes columns in the SELECT section. This generated query fails:
    >
    > SELECT [t0].[NAME], [t0].[GROUP], [t0].[ID] FROM [USER] [t0] WHERE t0.GROUP = ?
    > [bind: 1->GROUP:29]
    >
    > because the GROUP column is used in the WHERE clause. Does anybody know if this
    > can be solved?
    >
    > Thanks in advance.
    >
    >
    >

    This archive was generated by hypermail 2.0.0 : Thu Nov 11 2010 - 14:25:12 UTC