Switching dynamically between database schemas using ofbiz
Locked
 
|
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 |
Re: Switching dynamically between database schemas using ofbiz
|
|
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
|
|
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. |
Re: Switching dynamically between database schemas using ofbiz
|
|
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. >> > > |
Re: Switching dynamically between database schemas using ofbiz
|
|
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. > |
Re: Switching dynamically between database schemas using ofbiz
|
|
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. |
Re: Switching dynamically between database schemas using ofbiz
|
|
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. >>> >>> >> > > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |