[
https://issues.apache.org/cayenne/browse/CAY-1114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13130#action_13130
]
Andrus Adamchik commented on CAY-1114:
--------------------------------------
Dave, would you mind to post a patch or at least a generated SQL (if it is not
something confidential)?
Thanks, Andrus
> EJBQLQuery fails on joins outside of public schema
> --------------------------------------------------
>
> Key: CAY-1114
> URL: https://issues.apache.org/cayenne/browse/CAY-1114
> Project: Cayenne
> Issue Type: Bug
> Components: Cayenne Core Library
> Affects Versions: 3.0
> Reporter: Dave Dombrosky
> Assignee: Andrus Adamchik
> Attachments: fixEJBQLTableAlias.patch
>
>
> I noticed that my EJBQL queries were failing because of incorrect table
> aliases. I did some troubleshooting and found out that the key for the table
> alias would sometimes be different depending on which translator/appender was
> running.
> The problem turned out to be getting the name from the DBEntity. In some
> places it was just getting the regular name (DbEntity.getName()) while in
> other places, it was getting the full name
> (DbEntity.getFullyQualifiedName()). This is only a problem when you have a
> table in a schema other than public, because for the public schema the two
> method calls return the same value.
> Changing the calls to EJBQLTranslationContext.getTableAlias() to always use
> the fully qualified name seems to have fixed my issues.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
