Re: OfBiz Data Model

[rajsaini]

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 [hidden email]?
>    
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  [phone]
> t    [phone]
> e   [hidden email]
> www.sword-group.com
>
>
> -----Original Message-----
> From: Raj Saini [mailto:[hidden email]]
> Sent: Wednesday, December 01, 2010 3:36 PM
> To: [hidden email]
> 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  [phone]
>> t    [phone]
>> e   [hidden email]
>> 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.
>
>
>    

[Abhishake Agarwal]

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 <[hidden email]> 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 [hidden email]?
>>
>>
> 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  [phone]
>> t    [phone]
>> e   [hidden email]
>> www.sword-group.com
>>
>>
>> -----Original Message-----
>> From: Raj Saini [mailto:[hidden email]]
>> Sent: Wednesday, December 01, 2010 3:36 PM
>> To: [hidden email]
>> 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  [phone]
>>> t    [phone]
>>> e   [hidden email]
>>> 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.
>>
>>
>>
>>
>
>

[BJ Freeman]

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  [phone]
> t    [phone]
> e   [hidden email]
> 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.
>