In our case it turned out a relationship query with a join across DataNodes. Since both DBs were on the same server, and such join was supported in theory, it was fixed by specifying schemas for all tables in 2 DataMaps. If the DBs are on different servers and joins are not possible, I guess you can't map relationships across them.
Not sure whether your case is one of the above? If not, could you post the SQL that is causing the Exception. Andrus On Jun 14, 2012, at 4:01 PM, Andrus Adamchik wrote: > Gary, > > just stumbled on something similar in one of our client projects. > Investigating... Stay tuned. > > Andrus > > > On Jun 12, 2012, at 10:48 AM, Andrus Adamchik wrote: > >> But what happens inside SelectQuery.route(..)? (the failing query is >> SelectQuery, right?). This is where the DataNode to Query mapping logic is, >> so this is the place to look for clues. >> >> Andrus >> >> On Jun 6, 2012, at 11:47 AM, Gary Jarrel wrote: >> >>> I've been debugging & debugging, and for the life of me I can not find >>> where the fault is, both DataNodes are set correctly, I just can't >>> seem to see what I am missing. :( >>> >>> Any further thoughts?! >>> >>> Gary >>> >>> On Tue, Jun 5, 2012 at 10:41 PM, Gary Jarrel <garyjar...@gmail.com> wrote: >>>> Just tried it with an XMLPoolingDataSourceFactory and got the same >>>> error. To the debugger it is! >>>> >>>> On Tue, Jun 5, 2012 at 10:06 PM, Gary Jarrel <garyjar...@gmail.com> wrote: >>>>> Thank you Andrus, I'll run it through a debugger and see what could be >>>>> causing it, I also try perhaps using an XMLPoolingDataSourceFactory to >>>>> see if it makes a difference. Will advise! >>>>> >>>>> G >>>>> >>>>> On Tue, Jun 5, 2012 at 10:01 PM, Andrus Adamchik <and...@objectstyle.org> >>>>> wrote: >>>>>> >>>>>>> I am also using CayenneFilter to initialize Cayenne, >>>>>> >>>>>> This is fine. >>>>>> >>> >> >> > >
