Hi Peter, I see your post is old enough. I need to ask you if you finally found an answer to your question. Because I'm currently in the same situation.
Thank you, Jad Peter Felts wrote > 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) -- View this message in context: http://ofbiz.135035.n4.nabble.com/ViewEntity-across-multiple-databases-tp152683p4646153.html Sent from the OFBiz - User mailing list archive at Nabble.com.
