Hi does anyone know how I can create a join across multiple databases? I've got my OfBiz database (MySQL) and an external database (Oracle) which I am using in an OFBiz application I'm working on. What I need to do now is create a join across tables in both databases but a view entity will not allow this. Any ideas about how this could be accomplished? Should I create my own query and run it in a java service?
The OFBiz documentation states that you can not create a view-entity across multiple databases: "All member-entitiesin aview-entity must be in the same database, but not necessarily in thesame entitygroup." (http://ofbiz.apache.org/docs/entity.html#View_Entity_Modeling)
