You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cayenne.apache.org by Lautaro Brasseur <la...@brasseur.com.ar> on 2010/11/11 13:38:56 UTC

Reserverd words mapping question

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.

Re: Reserverd words mapping question

Posted by ca...@yahoo.com.

Done: https://issues.apache.org/jira/browse/CAY-1506

Best regards

Lautaro





________________________________
De: Andrus Adamchik <an...@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.
> 
> 
>

Re: Reserverd words mapping question

Posted by Andrus Adamchik <an...@objectstyle.org>.

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.
> 
> 
>