Thanks Jad,
I'm looking for any open-source equivalent to UnityJDBC but there
doesn't seem to be much out there. Regardless of using such a tool, I
think the OFBiz entity engine will issues joining the external db due to
incompatible primary keys in the external db. I think view-entities
require joins to be on primary keys. In order for the external db to be
joined in my case it would have to be done on non-primary key fields.
So I think the entity engine would have to be changed to allow such a
tool to be employed within OFBiz, but the design seems deliberate and
correct and unlikely to change from requiring primary key joins.
Importing or using the external db tables directly seem to be the main
alternatives.
On 01/14/2014 10:35 AM, Jad El Omeiri wrote:
Thank you UnityJDBC for your reply.
looks like this is the solution I will be opting for.
I will be soon giving my feedback.
note: did anyone have any experience with Ofbiz/UnityJDBC before? it would
probably help.
-----
Jad El Omeiri
--
View this message in context:
http://ofbiz.135035.n4.nabble.com/JOINs-across-different-DBs-tp4647103p4647184.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
