You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by HtaraS <sa...@gmail.com> on 2009/07/30 19:41:37 UTC
Switching dynamically between database schemas using ofbiz
Hii everyone,
Am learning and researching on OfBiz, and am looking to change
the database flow, which in the present case of OfBiz supports only a single
Data Base schema. Am planning to make it support multiple schemas within a
single data base [MySql in my case], which I would like to switch to
different schemas dynamically based on the user's login
details[DepartmentId,UserName,password].
I have added two new tables named Department and Groups,
where Department contains a foreign key relationship with groups. Groups
table contains details of the various delegators in entityengine.xml and
based on the departmentId entered in the login page by the end user, OfBiz
should dynamically shift to their respective schema in the data base.
I would be very glad to receive your suggestions and views
......
Thank you in advance ........
Sarath
--
View this message in context: http://www.nabble.com/Switching-dynamically-between-database-schemas-using-ofbiz-tp24743344p24743344.html
Sent from the OFBiz - User mailing list archive at Nabble.com.
Re: Switching dynamically between database schemas using ofbiz
Posted by Adrian Crum <ad...@hlmksw.com>.
If the different OFBiz instances were on different URLs, it seems to me
you could modify the Servlet so the request URL maps to a Delegator name
- via a properties file or something.
-Adrian
David E Jones wrote:
>
> You should check out the issue created by Marc Morin related to this:
>
> https://issues.apache.org/jira/browse/OFBIZ-2766
>
> They are taking a different approach than you described, and I think
> Marc and others would like to discuss alternative ways of going about
> this, and alternative ways to implement it.
>
> BTW, I know that Marc and others at Emforium have done quite a bit of
> research on multi-tenancy and they have a successful implementation
> already done (ie don't worry about what BJ wrote in his reply on that
> issue).
>
> -David
>
>
> On Jul 30, 2009, at 11:41 AM, HtaraS wrote:
>
>>
>> Hii everyone,
>>
>> Am learning and researching on OfBiz, and am looking to
>> change
>> the database flow, which in the present case of OfBiz supports only a
>> single
>> Data Base schema. Am planning to make it support multiple schemas
>> within a
>> single data base [MySql in my case], which I would like to switch to
>> different schemas dynamically based on the user's login
>> details[DepartmentId,UserName,password].
>> I have added two new tables named Department and Groups,
>> where Department contains a foreign key relationship with groups. Groups
>> table contains details of the various delegators in entityengine.xml and
>> based on the departmentId entered in the login page by the end user,
>> OfBiz
>> should dynamically shift to their respective schema in the data base.
>>
>> I would be very glad to receive your suggestions and views
>> ......
>>
>> Thank you in advance ........
>>
>> Sarath
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Switching-dynamically-between-database-schemas-using-ofbiz-tp24743344p24743344.html
>>
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
Re: Switching dynamically between database schemas using ofbiz
Posted by David E Jones <de...@me.com>.
You should check out the issue created by Marc Morin related to this:
https://issues.apache.org/jira/browse/OFBIZ-2766
They are taking a different approach than you described, and I think
Marc and others would like to discuss alternative ways of going about
this, and alternative ways to implement it.
BTW, I know that Marc and others at Emforium have done quite a bit of
research on multi-tenancy and they have a successful implementation
already done (ie don't worry about what BJ wrote in his reply on that
issue).
-David
On Jul 30, 2009, at 11:41 AM, HtaraS wrote:
>
> Hii everyone,
>
> Am learning and researching on OfBiz, and am looking to
> change
> the database flow, which in the present case of OfBiz supports only
> a single
> Data Base schema. Am planning to make it support multiple schemas
> within a
> single data base [MySql in my case], which I would like to switch to
> different schemas dynamically based on the user's login
> details[DepartmentId,UserName,password].
> I have added two new tables named Department and
> Groups,
> where Department contains a foreign key relationship with groups.
> Groups
> table contains details of the various delegators in entityengine.xml
> and
> based on the departmentId entered in the login page by the end user,
> OfBiz
> should dynamically shift to their respective schema in the data base.
>
> I would be very glad to receive your suggestions and views
> ......
>
> Thank you in advance ........
>
> Sarath
>
> --
> View this message in context: http://www.nabble.com/Switching-dynamically-between-database-schemas-using-ofbiz-tp24743344p24743344.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>
Re: Switching dynamically between database schemas using ofbiz
Posted by David E Jones <de...@me.com>.
It's great that you express your opinion BJ. What gets in the way of
discussion is more personal and unfounded remarks, like: "I can tell
be your comments you have not really gotten into ofbiz and how it
works."
I'm guessing at what you're trying to get at with this suggestion, but
you could phrase it like "how much have you gotten into OFBiz and how
it works?" Or even better (and I'm guessing more about your thoughts):
"What did you mean when you mentioned ODBC? OFBiz does everything
through JDBC." My guess is that Marc was just generalizing.
-David
On Jul 30, 2009, at 2:04 PM, BJ Freeman wrote:
> I deleted david:
> apparently I am in over my head.
>
>
> David E Jones sent the following on 7/30/2009 11:45 AM:
>>
>> You should check out the issue created by Marc Morin related to this:
>>
>> https://issues.apache.org/jira/browse/OFBIZ-2766
>>
>> They are taking a different approach than you described, and I think
>> Marc and others would like to discuss alternative ways of going about
>> this, and alternative ways to implement it.
>>
>> BTW, I know that Marc and others at Emforium have done quite a bit of
>> research on multi-tenancy and they have a successful implementation
>> already done (ie don't worry about what BJ wrote in his reply on that
>> issue).
>>
>> -David
>>
>>
>> On Jul 30, 2009, at 11:41 AM, HtaraS wrote:
>>
>>>
>>> Hii everyone,
>>>
>>> Am learning and researching on OfBiz, and am looking to
>>> change
>>> the database flow, which in the present case of OfBiz supports
>>> only a
>>> single
>>> Data Base schema. Am planning to make it support multiple schemas
>>> within a
>>> single data base [MySql in my case], which I would like to switch to
>>> different schemas dynamically based on the user's login
>>> details[DepartmentId,UserName,password].
>>> I have added two new tables named Department and
>>> Groups,
>>> where Department contains a foreign key relationship with groups.
>>> Groups
>>> table contains details of the various delegators in
>>> entityengine.xml and
>>> based on the departmentId entered in the login page by the end user,
>>> OfBiz
>>> should dynamically shift to their respective schema in the data
>>> base.
>>>
>>> I would be very glad to receive your suggestions and views
>>> ......
>>>
>>> Thank you in advance ........
>>>
>>> Sarath
>>>
>>> --
>>> View this message in context:
>>> http://www.nabble.com/Switching-dynamically-between-database-schemas-using-ofbiz-tp24743344p24743344.html
>>>
>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>
>>
>>
>
> --
> BJ Freeman
> http://www.businessesnetwork.com/automation
> http://bjfreeman.elance.com
> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
> Systems Integrator.
>
Re: Switching dynamically between database schemas using ofbiz
Posted by lemine youssef <yo...@nereide.biz>.
Hi everyone;
At Néréide, We have implemented successfully a multi-tenant OFBiz
instance which is provided as an ofbiz-addon.
It can be installed (introducing modifications by applying a set of a
patches).
to checkout the addon from cvs:
cvs -d :pserver:anonymous@labs.libre-entreprise.org:/cvsroot/neogia
login
cvs -d :pserver:anonymous@labs.libre-entreprise.org:/cvsroot/neogia
checkout ofbizAddOn/multi-delegator
More about addon-manager at : http://www.neogia.org/Add-on_Manager
GoodLack
Youssef Lemine.
BJ Freeman a écrit :
> Ok communications was never my strong suite
> guess I just have to accept people being upset with me.
> :D
>
> David E Jones sent the following on 7/30/2009 1:59 PM:
>
>> It's great that you express your opinion BJ. What gets in the way of
>> discussion is more personal and unfounded remarks, like: "I can tell be
>> your comments you have not really gotten into ofbiz and how it works."
>>
>> I'm guessing at what you're trying to get at with this suggestion, but
>> you could phrase it like "how much have you gotten into OFBiz and how it
>> works?" Or even better (and I'm guessing more about your thoughts):
>> "What did you mean when you mentioned ODBC? OFBiz does everything
>> through JDBC." My guess is that Marc was just generalizing.
>>
>> -David
>>
>>
>> On Jul 30, 2009, at 2:04 PM, BJ Freeman wrote:
>>
>>
>>> I deleted david:
>>> apparently I am in over my head.
>>>
>>>
>>> David E Jones sent the following on 7/30/2009 11:45 AM:
>>>
>>>> You should check out the issue created by Marc Morin related to this:
>>>>
>>>> https://issues.apache.org/jira/browse/OFBIZ-2766
>>>>
>>>> They are taking a different approach than you described, and I think
>>>> Marc and others would like to discuss alternative ways of going about
>>>> this, and alternative ways to implement it.
>>>>
>>>> BTW, I know that Marc and others at Emforium have done quite a bit of
>>>> research on multi-tenancy and they have a successful implementation
>>>> already done (ie don't worry about what BJ wrote in his reply on that
>>>> issue).
>>>>
>>>> -David
>>>>
>>>>
>>>> On Jul 30, 2009, at 11:41 AM, HtaraS wrote:
>>>>
>>>>
>>>>> Hii everyone,
>>>>>
>>>>> Am learning and researching on OfBiz, and am looking to
>>>>> change
>>>>> the database flow, which in the present case of OfBiz supports only a
>>>>> single
>>>>> Data Base schema. Am planning to make it support multiple schemas
>>>>> within a
>>>>> single data base [MySql in my case], which I would like to switch to
>>>>> different schemas dynamically based on the user's login
>>>>> details[DepartmentId,UserName,password].
>>>>> I have added two new tables named Department and Groups,
>>>>> where Department contains a foreign key relationship with groups.
>>>>> Groups
>>>>> table contains details of the various delegators in entityengine.xml
>>>>> and
>>>>> based on the departmentId entered in the login page by the end user,
>>>>> OfBiz
>>>>> should dynamically shift to their respective schema in the data base.
>>>>>
>>>>> I would be very glad to receive your suggestions and views
>>>>> ......
>>>>>
>>>>> Thank you in advance ........
>>>>>
>>>>> Sarath
>>>>>
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/Switching-dynamically-between-database-schemas-using-ofbiz-tp24743344p24743344.html
>>>>>
>>>>>
>>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>>
>>>>>
>>>>
>>> --
>>> BJ Freeman
>>> http://www.businessesnetwork.com/automation
>>> http://bjfreeman.elance.com
>>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
>>>
>>> Systems Integrator.
>>>
>>>
>>
>
>
Re: Switching dynamically between database schemas using ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
Ok communications was never my strong suite
guess I just have to accept people being upset with me.
:D
David E Jones sent the following on 7/30/2009 1:59 PM:
>
> It's great that you express your opinion BJ. What gets in the way of
> discussion is more personal and unfounded remarks, like: "I can tell be
> your comments you have not really gotten into ofbiz and how it works."
>
> I'm guessing at what you're trying to get at with this suggestion, but
> you could phrase it like "how much have you gotten into OFBiz and how it
> works?" Or even better (and I'm guessing more about your thoughts):
> "What did you mean when you mentioned ODBC? OFBiz does everything
> through JDBC." My guess is that Marc was just generalizing.
>
> -David
>
>
> On Jul 30, 2009, at 2:04 PM, BJ Freeman wrote:
>
>> I deleted david:
>> apparently I am in over my head.
>>
>>
>> David E Jones sent the following on 7/30/2009 11:45 AM:
>>>
>>> You should check out the issue created by Marc Morin related to this:
>>>
>>> https://issues.apache.org/jira/browse/OFBIZ-2766
>>>
>>> They are taking a different approach than you described, and I think
>>> Marc and others would like to discuss alternative ways of going about
>>> this, and alternative ways to implement it.
>>>
>>> BTW, I know that Marc and others at Emforium have done quite a bit of
>>> research on multi-tenancy and they have a successful implementation
>>> already done (ie don't worry about what BJ wrote in his reply on that
>>> issue).
>>>
>>> -David
>>>
>>>
>>> On Jul 30, 2009, at 11:41 AM, HtaraS wrote:
>>>
>>>>
>>>> Hii everyone,
>>>>
>>>> Am learning and researching on OfBiz, and am looking to
>>>> change
>>>> the database flow, which in the present case of OfBiz supports only a
>>>> single
>>>> Data Base schema. Am planning to make it support multiple schemas
>>>> within a
>>>> single data base [MySql in my case], which I would like to switch to
>>>> different schemas dynamically based on the user's login
>>>> details[DepartmentId,UserName,password].
>>>> I have added two new tables named Department and Groups,
>>>> where Department contains a foreign key relationship with groups.
>>>> Groups
>>>> table contains details of the various delegators in entityengine.xml
>>>> and
>>>> based on the departmentId entered in the login page by the end user,
>>>> OfBiz
>>>> should dynamically shift to their respective schema in the data base.
>>>>
>>>> I would be very glad to receive your suggestions and views
>>>> ......
>>>>
>>>> Thank you in advance ........
>>>>
>>>> Sarath
>>>>
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/Switching-dynamically-between-database-schemas-using-ofbiz-tp24743344p24743344.html
>>>>
>>>>
>>>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>>>
>>>
>>>
>>
>> --
>> BJ Freeman
>> http://www.businessesnetwork.com/automation
>> http://bjfreeman.elance.com
>> http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
>>
>> Systems Integrator.
>>
>
>
--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.
Re: Switching dynamically between database schemas using ofbiz
Posted by BJ Freeman <bj...@free-man.net>.
I deleted david:
apparently I am in over my head.
David E Jones sent the following on 7/30/2009 11:45 AM:
>
> You should check out the issue created by Marc Morin related to this:
>
> https://issues.apache.org/jira/browse/OFBIZ-2766
>
> They are taking a different approach than you described, and I think
> Marc and others would like to discuss alternative ways of going about
> this, and alternative ways to implement it.
>
> BTW, I know that Marc and others at Emforium have done quite a bit of
> research on multi-tenancy and they have a successful implementation
> already done (ie don't worry about what BJ wrote in his reply on that
> issue).
>
> -David
>
>
> On Jul 30, 2009, at 11:41 AM, HtaraS wrote:
>
>>
>> Hii everyone,
>>
>> Am learning and researching on OfBiz, and am looking to
>> change
>> the database flow, which in the present case of OfBiz supports only a
>> single
>> Data Base schema. Am planning to make it support multiple schemas
>> within a
>> single data base [MySql in my case], which I would like to switch to
>> different schemas dynamically based on the user's login
>> details[DepartmentId,UserName,password].
>> I have added two new tables named Department and Groups,
>> where Department contains a foreign key relationship with groups. Groups
>> table contains details of the various delegators in entityengine.xml and
>> based on the departmentId entered in the login page by the end user,
>> OfBiz
>> should dynamically shift to their respective schema in the data base.
>>
>> I would be very glad to receive your suggestions and views
>> ......
>>
>> Thank you in advance ........
>>
>> Sarath
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Switching-dynamically-between-database-schemas-using-ofbiz-tp24743344p24743344.html
>>
>> Sent from the OFBiz - User mailing list archive at Nabble.com.
>>
>
>
--
BJ Freeman
http://www.businessesnetwork.com/automation
http://bjfreeman.elance.com
http://www.linkedin.com/profile?viewProfile=&key=1237480&locale=en_US&trk=tab_pro
Systems Integrator.