[
https://issues.apache.org/jira/browse/CAY-1685?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13224943#comment-13224943
]
Andrus Adamchik commented on CAY-1685:
--------------------------------------
Interesting ... looks like we'll need to do some escaping here. Will take a look
> Working with a database that has dots "." in column names- "Quote SQL
> identifiers" does not seem to help.
> ----------------------------------------------------------------------------------------------------------
>
> Key: CAY-1685
> URL: https://issues.apache.org/jira/browse/CAY-1685
> Project: Cayenne
> Issue Type: Bug
> Affects Versions: 3.0.1
> Environment: apache cayenne 3.0.0.1, tomcat 6.x
> Reporter: Eric Cobb
>
> Unfortunately I have no control over the column names, I am trying to
> integrate my project with a database that my client already uses/maintains.
> One of their tables uses dots (".") in column names. For example:
> <db-attribute name="Division.t" type="VARCHAR"/>
> Cayenne reports that it can not resolve that path component:
> Caused by: org.apache.cayenne.exp.ExpressionException: [v.3.0.1.LB Oct 24
> 2011 22:29:11] Can't resolve path component: [FILE_NAME.Division'].
> at org.apache.cayenne.map.Entity$PathIterator.next(Entity.java:439)
> at org.apache.cayenne.map.Entity$PathIterator.next(Entity.java:388)
> at
> org.apache.cayenne.map.ObjAttribute.getDbAttribute(ObjAttribute.java:170)
> at
> com.routeto1.data.impl.DynamicDataObjectClassFactory.getDataObjectClass(DynamicDataObjectClassFactory.java:128)
> at
> com.routeto1.data.impl.DynamicDataObjectClassFactory.getDataObjectClasses(DynamicDataObjectClassFactory.java:91)
> at
> com.routeto1.data.meta.persist.MetaModelDAO.afterPropertiesSet(MetaModelDAO.java:149)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1369)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
> ... 51 more
> I lose everything after the "." .Turning on "quote sql identifiers" does not
> seem to help. Any workarounds and/or fixes would be appreciated.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
