cayenne-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Olga Tkacheva (JIRA)" <j...@apache.org>
Subject [jira] Closed: (CAY-1506) Reserverd words mapping in WHERE clause
Date Mon, 10 Jan 2011 10:52:45 GMT

     [ https://issues.apache.org/jira/browse/CAY-1506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Olga Tkacheva closed CAY-1506.
------------------------------

       Resolution: Fixed
    Fix Version/s: 3.0.2

> Reserverd words mapping in WHERE clause
> ---------------------------------------
>
>                 Key: CAY-1506
>                 URL: https://issues.apache.org/jira/browse/CAY-1506
>             Project: Cayenne
>          Issue Type: Bug
>          Components: Core Library
>    Affects Versions: 3.0
>         Environment: Cayenne 3.0 + MSSQLServer (running in an OSGi environment)
>            Reporter: Lautaro Brasseur
>            Assignee: Olga Tkacheva
>             Fix For: 3.0.2
>
>
> I need to map a database schema which has reserverd words in column names. 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 and it is not quoted. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message