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:
{code}
<db-attribute name="Division.t" type="VARCHAR"/>
{code}
Cayenne reports that it can not resolve that path component:
{code}
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
{code}
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
