ViewEntity across multiple databases?

[Peter Felts <pe...@yahoo.com>]

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)

Re: ViewEntity across multiple databases?

[jadelomeiri <ja...@robertheath.co.uk>]

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.