Switching dynamically between database schemas using ofbiz

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Switching dynamically between database schemas using ofbiz

HtaraS
 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
   
Reply | Threaded
Open this post in threaded view
|

Re: Switching dynamically between database schemas using ofbiz

David E. Jones-2

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.
>

Reply | Threaded
Open this post in threaded view
|

Re: Switching dynamically between database schemas using ofbiz

BJ Freeman
In reply to this post by HtaraS
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.

Reply | Threaded
Open this post in threaded view
|

Re: Switching dynamically between database schemas using ofbiz

Adrian Crum
In reply to this post by David E. Jones-2
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.
>>
>
>
Reply | Threaded
Open this post in threaded view
|

Re: Switching dynamically between database schemas using ofbiz

David E. Jones-2
In reply to this post by BJ Freeman

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.
>

Reply | Threaded
Open this post in threaded view
|

Re: Switching dynamically between database schemas using ofbiz

BJ Freeman
In reply to this post by BJ Freeman
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.

Reply | Threaded
Open this post in threaded view
|

Re: Switching dynamically between database schemas using ofbiz

lemine youssef
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:[hidden email]:/cvsroot/neogia
login
    cvs -d :pserver:[hidden email]:/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.
>>>
>>>      
>>    
>
>