You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Ganapathyraman Venkatraman <ga...@sword-in.com> on 2010/12/01 10:48:04 UTC
OfBiz Data Model
Hi,
Appreciate if someone can guide me to get access to the schema dump of OfBiz database. I am on to bringing up OfBiz instance in my m/c. Thanks ahead...
Regards,
G.Raman
Senior Technical Director
Sword Global India Pvt Ltd.
5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore, Chennai - 600 004, India
_____________________________________
m +91 95000 53613
t +91 44 6636 3650
e ganapathyraman.venkatraman@sword-in.com
www.sword-group.com<http://www.sword-group.com/>
The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.
Re: OfBiz Data Model
Posted by BJ Freeman <bj...@free-man.net>.
it is best if you become familiar with how ofbiz works.
https://cwiki.apache.org/confluence/display/OFBADMIN/OFBiz+Documentation+Index
look under
Data Model Documents & Diagrams
and
Technical Training Videos
=========================
BJ Freeman
Strategic Power Office with Supplier Automation <http://www.businessesnetwork.com/automation/viewforum.php?f=52>
Specialtymarket.com <http://www.specialtymarket.com/>
Systems Integrator-- Glad to Assist
Chat Y! messenger: bjfr33man
Ganapathyraman Venkatraman sent the following on 12/1/2010 1:48 AM:
> Hi,
>
> Appreciate if someone can guide me to get access to the schema dump of OfBiz database. I am on to bringing up OfBiz instance in my m/c. Thanks ahead...
>
> Regards,
> G.Raman
> Senior Technical Director
> Sword Global India Pvt Ltd.
> 5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore, Chennai - 600 004, India
> _____________________________________
> m +91 95000 53613
> t +91 44 6636 3650
> e ganapathyraman.venkatraman@sword-in.com
> www.sword-group.com<http://www.sword-group.com/>
>
>
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.
>
Re: OfBiz Data Model
Posted by Abhishake Agarwal <ab...@gmail.com>.
Hi,
EntityDataLoadContainer.java setup's the delegator and creates the DB
schema through DataBaseUtil.java. Data is loaded by EntityDataLoadContainer
in start method which internally calls delegator's create method to insert
from xml seed data. If you look in this method it internally generates sql
query.
Regards,
Abhishake
On Wed, Dec 1, 2010 at 3:54 PM, Raj Saini <ra...@gmail.com> wrote:
> Hi Raman,
>
> See inline:
>
>
> Thanks Raj. I am sorry, since I was a first-timer and desperate to get
>> things up, I had to fire the 'q' in this mail group.
>>
>> Appreciate if you can guide me on
>> 1) is the user group user@ofbiz.apache.org?
>>
>>
> Yes this is correct.
>
>> 2) how do I know as to where the schema is created? Or where are the DDL
>> statements to create the DB objects?
>>
>>
> If you are not using any other external database, OFBiz will use embedded
> derby database. And derby data location is ${ofbiz.home}/runtime/data/derby.
>
> There are no DDL statements in OFBiz. OFBiz components define their entity
> in entity model files and these definition files are used to create the
> database schema.
>
> Thanks,
>
> Raj
>
> Regards,
>> G.Raman
>> Senior Technical Director
>> Sword Global India Pvt Ltd.
>> 5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore,
>> Chennai - 600 004, India
>> _____________________________________
>> m +91 95000 53613
>> t +91 44 6636 3650
>> e ganapathyraman.venkatraman@sword-in.com
>> www.sword-group.com
>>
>>
>> -----Original Message-----
>> From: Raj Saini [mailto:rajsaini@gmail.com]
>> Sent: Wednesday, December 01, 2010 3:36 PM
>> To: dev@ofbiz.apache.org
>> Cc: Ganapathyraman Venkatraman
>> Subject: Re: OfBiz Data Model
>>
>> Hello G Raman,
>>
>> You can run the "run-install" ant target and OFBiz will create schema
>> along with demo data.
>>
>> Also, such questions should be asked in user mailing list as dev mailing
>> list is used for OFBiz development discussion.
>>
>> Thanks,
>>
>> Raj
>>
>> On Wednesday 01 December 2010 03:18 PM, Ganapathyraman Venkatraman wrote:
>>
>>
>>> Hi,
>>>
>>> Appreciate if someone can guide me to get access to the schema dump of
>>> OfBiz database. I am on to bringing up OfBiz instance in my m/c. Thanks
>>> ahead...
>>>
>>> Regards,
>>> G.Raman
>>> Senior Technical Director
>>> Sword Global India Pvt Ltd.
>>> 5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore,
>>> Chennai - 600 004, India
>>> _____________________________________
>>> m +91 95000 53613
>>> t +91 44 6636 3650
>>> e ganapathyraman.venkatraman@sword-in.com
>>> www.sword-group.com<http://www.sword-group.com/>
>>>
>>>
>>> The information contained in this electronic message and any attachments
>>> to this message are intended for the exclusive use of the addressee(s) and
>>> may contain proprietary, confidential or privileged information. If you are
>>> not the intended recipient, you should not disseminate, distribute or copy
>>> this e-mail. Please notify the sender immediately and destroy all copies of
>>> this message and any attachments contained in it.
>>>
>>>
>>>
>>>
>>
>> The information contained in this electronic message and any attachments
>> to this message are intended for the exclusive use of the addressee(s) and
>> may contain proprietary, confidential or privileged information. If you are
>> not the intended recipient, you should not disseminate, distribute or copy
>> this e-mail. Please notify the sender immediately and destroy all copies of
>> this message and any attachments contained in it.
>>
>>
>>
>>
>
>
Re: OfBiz Data Model
Posted by Raj Saini <ra...@gmail.com>.
Hi Raman,
See inline:
> Thanks Raj. I am sorry, since I was a first-timer and desperate to get things up, I had to fire the 'q' in this mail group.
>
> Appreciate if you can guide me on
> 1) is the user group user@ofbiz.apache.org?
>
Yes this is correct.
> 2) how do I know as to where the schema is created? Or where are the DDL statements to create the DB objects?
>
If you are not using any other external database, OFBiz will use
embedded derby database. And derby data location is
${ofbiz.home}/runtime/data/derby.
There are no DDL statements in OFBiz. OFBiz components define their
entity in entity model files and these definition files are used to
create the database schema.
Thanks,
Raj
> Regards,
> G.Raman
> Senior Technical Director
> Sword Global India Pvt Ltd.
> 5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore, Chennai - 600 004, India
> _____________________________________
> m +91 95000 53613
> t +91 44 6636 3650
> e ganapathyraman.venkatraman@sword-in.com
> www.sword-group.com
>
>
> -----Original Message-----
> From: Raj Saini [mailto:rajsaini@gmail.com]
> Sent: Wednesday, December 01, 2010 3:36 PM
> To: dev@ofbiz.apache.org
> Cc: Ganapathyraman Venkatraman
> Subject: Re: OfBiz Data Model
>
> Hello G Raman,
>
> You can run the "run-install" ant target and OFBiz will create schema
> along with demo data.
>
> Also, such questions should be asked in user mailing list as dev mailing
> list is used for OFBiz development discussion.
>
> Thanks,
>
> Raj
>
> On Wednesday 01 December 2010 03:18 PM, Ganapathyraman Venkatraman wrote:
>
>> Hi,
>>
>> Appreciate if someone can guide me to get access to the schema dump of OfBiz database. I am on to bringing up OfBiz instance in my m/c. Thanks ahead...
>>
>> Regards,
>> G.Raman
>> Senior Technical Director
>> Sword Global India Pvt Ltd.
>> 5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore, Chennai - 600 004, India
>> _____________________________________
>> m +91 95000 53613
>> t +91 44 6636 3650
>> e ganapathyraman.venkatraman@sword-in.com
>> www.sword-group.com<http://www.sword-group.com/>
>>
>>
>> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.
>>
>>
>>
>
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.
>
>
>
Re: OfBiz Data Model
Posted by Raj Saini <ra...@gmail.com>.
Hello G Raman,
You can run the "run-install" ant target and OFBiz will create schema
along with demo data.
Also, such questions should be asked in user mailing list as dev mailing
list is used for OFBiz development discussion.
Thanks,
Raj
On Wednesday 01 December 2010 03:18 PM, Ganapathyraman Venkatraman wrote:
> Hi,
>
> Appreciate if someone can guide me to get access to the schema dump of OfBiz database. I am on to bringing up OfBiz instance in my m/c. Thanks ahead...
>
> Regards,
> G.Raman
> Senior Technical Director
> Sword Global India Pvt Ltd.
> 5th Floor, Arihant Nitco Park, 90, Dr. Radhakrishnan Salai, Mylapore, Chennai - 600 004, India
> _____________________________________
> m +91 95000 53613
> t +91 44 6636 3650
> e ganapathyraman.venkatraman@sword-in.com
> www.sword-group.com<http://www.sword-group.com/>
>
>
> The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it.
>
>
Re: OfBiz Data Model
Posted by James McGill <ja...@ableengineering.com>.
On Wed, Dec 1, 2010 at 2:48 AM, Ganapathyraman Venkatraman
<ga...@sword-in.com> wrote:
> Hi,
>
> Appreciate if someone can guide me to get access to the schema dump of OfBiz database. I am on to bringing up OfBiz instance in my m/c. Thanks ahead...
It's fairly large, on the order of 800 tables and many relational
constraints. If you want an E-R diagram, the best approach may be to
install OFBiz and then use an E-R tool to extract the schema as
deployed. There are View entities defined in OFBiz that are very
important but will not be represented from your schema perspective. I
believe the Entity Reference tool and Artifact Info in the Webtools
application are far more useful than a schema dump.
When working with OFBiz we tend to rely directly on the
entitymodel.xml definitions directly. We aren't doing the kind of
Object-Relational mapping that is found in other frameworks; we are
dealing directly in terms of an entity model. This is one of the main
things that sets OFBiz apart from other frameworks. We simply don't
think in terms of "data binding" to a relational schema, we use a
relational schema *directly* without the object layer. The object
binding is done through a loosely coupled Map abstraction, which gives
us enormous flexibility while doing away with the heavy emphasis on
type safety and strict coupling that we'd have in an ORM.
--
James McGill
Phoenix AZ