cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From casiyatrucha-caye...@yahoo.com
Subject Re: Reserverd words mapping question
Date Thu, 11 Nov 2010 14:59:44 GMT
Done: https://issues.apache.org/jira/browse/CAY-1506

Best regards

Lautaro





________________________________
De: Andrus Adamchik <andrus@objectstyle.org>
Para: user@cayenne.apache.org
Enviado: jueves, 11 de noviembre, 2010 11:24:42
Asunto: 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.
> 
> 
> 


      
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message