You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by BJ Freeman <bj...@free-man.net> on 2010/10/30 19:46:26 UTC
Re: how to View the Entities after Inducing msql DB
please explain more what you mean by view
=========================
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
Kapil garg sent the following on 10/30/2010 11:33 AM:
>
> Hello All
> I was able to induce successfully the database with some error for unknown primary key without any group file or model file. I am not sure what was wrong with the
>
> I need to now view the entities.
>
> HOw do I do it?
>
>
> Kapil Garg
>
>
>
>
>
>> From: gargkapil@hotmail.com
>> To: user@ofbiz.apache.org
>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>> Date: Sun, 31 Oct 2010 03:47:41 +1000
>>
>>
>> Sure Adrian
>> Appreciate your reply.
>> My question was while creating entity-group.xml file what is the entity name I need to give? Does it map to some table name. IF I do create this file with entity attribute then what do I need to put in entity-model.xml file for this entity?
>>
>>
>> Kapil Garg
>>
>>
>>
>>
>>
>>> Date: Sat, 30 Oct 2010 08:29:37 -0700
>>> From: adrian.crum@yahoo.com
>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>> To: user@ofbiz.apache.org
>>>
>>> You are asking a lot of questions, and they can all be answered, but it might be best to answer them one at a time.
>>>
>>> I thought you were trying to connect OFBiz to an external database - and my instructions will do that. Once you have that working, we can move on to the other questions.
>>>
>>> -Adrian
>>>
>>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com> wrote:
>>>
>>>> From: Kapil garg<ga...@hotmail.com>
>>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>>> To: user@ofbiz.apache.org
>>>> Date: Saturday, October 30, 2010, 8:21 AM
>>>>
>>>> how do we know which table or view does it map to? May it
>>>> does not map to any of the tables and is just an entity by
>>>> itself needed for ofbiz framework? If I were to put this
>>>> entity entry then I would need to also create an
>>>> entitymodel.xml file which would have some field tags? How
>>>> do i now which ones are they? Are they mapping to one on one
>>>> to a table in the schema? I would have imgined if that is
>>>> the case then is there an ant target to create entity group
>>>> or enity model xml files as it could be error prone given
>>>> they conform to in built entity-model.xsd schemas
>>>>
>>>> Aain how many such entitties do I need to create. If it is
>>>> one per table then I have to create as many entites equal to
>>>> the total numer off tables in the schemas. What about views
>>>> oe indices etc How are they mapped? What about Stored
>>>> Procedures, can they be converted to mmini lang or service
>>>> classes?
>>>>
>>>>
>>>> Kapil Garg
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> Date: Sat, 30 Oct 2010 08:13:53 -0700
>>>>> From: adrian.crum@yahoo.com
>>>>> Subject: RE: Issues Creating Entities in Ofbiz from
>>>> existing Schema
>>>>> To: user@ofbiz.apache.org
>>>>>
>>>>> Correct, you will need an entity-group.xml file. It
>>>> should cntain one entry per external entity (or table).
>>>>>
>>>>> -Adrian
>>>>>
>>>>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com>
>>>> wrote:
>>>>>
>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>> Subject: RE: Issues Creating Entities in Ofbiz
>>>> from existing Schema
>>>>>> To: user@ofbiz.apache.org
>>>>>> Date: Saturday, October 30, 2010, 8:11 AM
>>>>>>
>>>>>> but if it is in a default group then do I need to
>>>> create an
>>>>>> enity-group.xml file? Since all the groups within
>>>> the
>>>>>> default group do not have an entity-group.xml
>>>> file I assumed
>>>>>> creating a datasource within a default group does
>>>> not
>>>>>> require an entity-group.xml file. There isnt one
>>>> for
>>>>>> locaderby datasource which is a default one. But
>>>> I could be
>>>>>> wrong
>>>>>> While creating the enitygroup file what name do I
>>>> need to
>>>>>> give to Entity atritbute of entity-group?
>>>> Random or
>>>>>> schema name? Does each of this entity name map to
>>>> a specific
>>>>>> table or just the whole DB?
>>>>>> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>>>>
>>>>>> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
>>>>>>
>>>>>>
>>>>>> <entity-group
>>>> group="org.ofbiz" entity="IS
>>>>>> THIS A RANDOM NAME??"/>
>>>>>>
>>>>>>
>>>>>> <entity-group
>>>> group="org.ofbiz"
>>>>>> entity="HOW MANY ENTITIES DO I NEED TO HAVE??ONE
>>>> per
>>>>>> Datasource or ONE Per Schema???"/>
>>>>>>
>>>>>> </entitygroup>
>>>>>>
>>>>>> Kapil Garg
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Date: Sat, 30 Oct 2010 08:04:51 -0700
>>>>>>> From: adrian.crum@yahoo.com
>>>>>>> Subject: Re: Issues Creating Entities in
>>>> Ofbiz from
>>>>>> existing Schema
>>>>>>> To: user@ofbiz.apache.org
>>>>>>>
>>>>>>> You need to give your external datasource a
>>>>>> group-name. Then in your external entity
>>>> definitions, assign
>>>>>> the entities to that group.
>>>>>>>
>>>>>>> -Adrian
>>>>>>>
>>>>>>> --- On Fri, 10/29/10, Kapil garg<ga...@hotmail.com>
>>>>>> wrote:
>>>>>>>
>>>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>>>> Subject: Issues Creating Entities in
>>>> Ofbiz from
>>>>>> existing Schema
>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>> Date: Friday, October 29, 2010, 12:09
>>>> PM
>>>>>>>>
>>>>>>>> I am trying to create a entities within
>>>> OFbiz out
>>>>>> of an
>>>>>>>> existing schema in production. Not sure
>>>> if this
>>>>>> is the best
>>>>>>>> way to create entties out of an
>>>> existing schema.
>>>>>> Suggestions
>>>>>>>> are welcomed!!
>>>>>>>>
>>>>>>>> I tried to add a datasource tag in
>>>> default
>>>>>> delegator in
>>>>>>>> entity-engine.xml
>>>>>>>> Followed the instructions on
>>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
>>>>>>>> Would like to know where I am going
>>>> wrong. On
>>>>>> restart, I
>>>>>>>> realised that ofbiz does not finish to
>>>> the point
>>>>>> that I can
>>>>>>>> get webtools or even login for
>>>> ecommerce. IT has
>>>>>> just stuck
>>>>>>>> at soem point saying
>>>> ServiceDispatcher.java
>>>>>> 584 INFO
>>>>>>>> Sync service..
>>>>>>>> There is no exception or anything but
>>>> OFbiz does
>>>>>> not go
>>>>>>>> further with complete laoding. Anything
>>>> I am
>>>>>> doing wrong?
>>>>>>>> Being a default delegaotr, there was no
>>>> special
>>>>>>>> entity-group.xml file in the ofbiz 9_04
>>>> code
>>>>>> base. Hence I
>>>>>>>> did not bother to create an
>>>> entity-group.xml
>>>>>> file
>>>>>>>> My schema name is lronline, following
>>>> are the
>>>>>> entries I had
>>>>>>>> in entity-engine.xml
>>>>>>>> <delegator name="default"
>>>>>> entity-model-reader="main"
>>>>>>>> entity-group-reader="main"
>>>>>> entity-eca-reader="main"
>>>>>>>>
>>>> distributed-cache-clear-enabled="false">
>>>>>>>>
>>>>>> <group-map
>>>>>>>> group-name="org.ofbiz"
>>>>>> datasource-name="localderby"/>
>>>>>>>>
>>>>>> <group-map
>>>>>>>> group-name="org.ofbiz.olap"
>>>>>>>> datasource-name="localderbyolap"/>
>>>>>>>>
>>>>>> <group-map
>>>>>>>> group-name="org.ofbiz"
>>>>>> datasource-name="mysql"/>
>>>>>>>>
>>>> </delegator>
>>>>>>>>
>>>>>>>> <datasource name="mysql"
>>>>>>>>
>>>>
>>>>>>>>
>>>>>>
>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>>>>>
>>>>
>>>>>>>> field-type-name="mysql"
>>>>>>>>
>>>>
>>>>>>>> check-on-start="true"
>>>>>>>>
>>>>
>>>>>>>> add-missing-on-start="true"
>>>>>>>>
>>>>
>>>>>>>> check-pks-on-start="false"
>>>>>>>>
>>>>
>>>>>>>> use-foreign-keys="true"
>>>>>>>>
>>>>
>>>>>>>> join-style="ansi-no-parenthesis"
>>>>>>>>
>>>>
>>>>>>>> alias-view-columns="false"
>>>>>>>>
>>>>
>>>>>>>> drop-fk-use-foreign-key-keyword="true"
>>>>>>>>
>>>>
>>>>>>>> table-type="InnoDB"
>>>>>>>>
>>>>
>>>>>>>> character-set="latin1"
>>>>>>>>
>>>>
>>>>>>>> collate="latin1_general_cs">
>>>>>>>>
>>>>>> <read-data
>>>>>>>> reader-name="seed"/>
>>>>>>>>
>>>>>> <read-data
>>>>>>>> reader-name="seed-initial"/>
>>>>>>>>
>>>>>> <read-data
>>>>>>>> reader-name="demo"/>
>>>>>>>>
>>>>>> <read-data
>>>>>>>> reader-name="ext"/>
>>>>>>>>
>>>>>> <inline-jdbc
>>>>>>>>
>>>>
>>>>>>
>>>>>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>>>>>>
>>>>
>>>>>>
>>>>>>>>
>>>>>>
>>>> jdbc-uri="jdbc:mysql://127.0.0.1/lronlineonedb?autoReconnect=true"
>>>>>>>>
>>>>
>>>>>>
>>>>>>>> jdbc-username="root"
>>>>>>>>
>>>>
>>>>>>
>>>>>>>> jdbc-password=""
>>>>>>>>
>>>>
>>>>>>
>>>>>>>> isolation-level="ReadCommitted"
>>>>>>>>
>>>>
>>>>>>
>>>>>>>> pool-minsize="2"
>>>>>>>>
>>>>
>>>>>>
>>>>>>>> pool-maxsize="250"/>
>>>>>>>>
>>>> <!--
>>>>>> <jndi-jdbc
>>>>>>>> jndi-server-name="localjndi"
>>>>>>>> jndi-name="java:/MySqlDataSource"
>>>>>>>> isolation-level="Serializable"/>
>>>> -->
>>>>>>>>
>>>> </datasource>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Kapil Garg
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>
Re: how to View the Entities after Inducing msql DB
Posted by BJ Freeman <bj...@free-man.net>.
I updated
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
=========================
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
BJ Freeman sent the following on 10/30/2010 11:11 AM:
> you do a view source of the resultant webpage, then copy and paste into
> hot-deploy/mycomponetname/entitydef/entitymodel.xml
> it is recomended you use
> ./ant create-component
> this will put the necessary structure for you component in hot-deploy
> next you need to clean up the entities that match your current DB.
>
> you can use
> https://cwiki.apache.org/OFBIZ/ofbiz-tutorial-a-beginners-development-guide.html
>
> as a reference.
>
> =========================
>
> 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
>
>
> Kapil garg sent the following on 10/30/2010 11:52 AM:
>>
>> I d like to know what exact entities have been created . Perhaps what
>> has just happened after successful induction? What does this induce do
>> eventually? What is the end result?Are there a list of entities
>> created mapped to tables in the database?Can I see them in webtools
>> under entity performance or somewhere? What all activities I could do
>> with these entities if at at all they are created? Can they be used in
>> any other component? How so? If I were to use them in Ecommerce
>> component, do I need to add them in that component's entity def folder?
>>
>>
>> Kapil Garg
>>
>>
>>
>>
>>
>>> Date: Sat, 30 Oct 2010 10:46:26 -0700
>>> From: bjfree@free-man.net
>>> To: user@ofbiz.apache.org
>>> Subject: Re: how to View the Entities after Inducing msql DB
>>>
>>> please explain more what you mean by view
>>>
>>> =========================
>>> 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
>>>
>>>
>>> Kapil garg sent the following on 10/30/2010 11:33 AM:
>>>>
>>>> Hello All
>>>> I was able to induce successfully the database with some error for
>>>> unknown primary key without any group file or model file. I am not
>>>> sure what was wrong with the
>>>>
>>>> I need to now view the entities.
>>>>
>>>> HOw do I do it?
>>>>
>>>>
>>>> Kapil Garg
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> From: gargkapil@hotmail.com
>>>>> To: user@ofbiz.apache.org
>>>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>>>> Date: Sun, 31 Oct 2010 03:47:41 +1000
>>>>>
>>>>>
>>>>> Sure Adrian
>>>>> Appreciate your reply.
>>>>> My question was while creating entity-group.xml file what is the
>>>>> entity name I need to give? Does it map to some table name. IF I do
>>>>> create this file with entity attribute then what do I need to put
>>>>> in entity-model.xml file for this entity?
>>>>>
>>>>>
>>>>> Kapil Garg
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>> Date: Sat, 30 Oct 2010 08:29:37 -0700
>>>>>> From: adrian.crum@yahoo.com
>>>>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>>>>> To: user@ofbiz.apache.org
>>>>>>
>>>>>> You are asking a lot of questions, and they can all be answered,
>>>>>> but it might be best to answer them one at a time.
>>>>>>
>>>>>> I thought you were trying to connect OFBiz to an external database
>>>>>> - and my instructions will do that. Once you have that working, we
>>>>>> can move on to the other questions.
>>>>>>
>>>>>> -Adrian
>>>>>>
>>>>>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com> wrote:
>>>>>>
>>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>>>>>> To: user@ofbiz.apache.org
>>>>>>> Date: Saturday, October 30, 2010, 8:21 AM
>>>>>>>
>>>>>>> how do we know which table or view does it map to? May it
>>>>>>> does not map to any of the tables and is just an entity by
>>>>>>> itself needed for ofbiz framework? If I were to put this
>>>>>>> entity entry then I would need to also create an
>>>>>>> entitymodel.xml file which would have some field tags? How
>>>>>>> do i now which ones are they? Are they mapping to one on one
>>>>>>> to a table in the schema? I would have imgined if that is
>>>>>>> the case then is there an ant target to create entity group
>>>>>>> or enity model xml files as it could be error prone given
>>>>>>> they conform to in built entity-model.xsd schemas
>>>>>>>
>>>>>>> Aain how many such entitties do I need to create. If it is
>>>>>>> one per table then I have to create as many entites equal to
>>>>>>> the total numer off tables in the schemas. What about views
>>>>>>> oe indices etc How are they mapped? What about Stored
>>>>>>> Procedures, can they be converted to mmini lang or service
>>>>>>> classes?
>>>>>>>
>>>>>>>
>>>>>>> Kapil Garg
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>> Date: Sat, 30 Oct 2010 08:13:53 -0700
>>>>>>>> From: adrian.crum@yahoo.com
>>>>>>>> Subject: RE: Issues Creating Entities in Ofbiz from
>>>>>>> existing Schema
>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>
>>>>>>>> Correct, you will need an entity-group.xml file. It
>>>>>>> should cntain one entry per external entity (or table).
>>>>>>>>
>>>>>>>> -Adrian
>>>>>>>>
>>>>>>>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com>
>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>>>>> Subject: RE: Issues Creating Entities in Ofbiz
>>>>>>> from existing Schema
>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>> Date: Saturday, October 30, 2010, 8:11 AM
>>>>>>>>>
>>>>>>>>> but if it is in a default group then do I need to
>>>>>>> create an
>>>>>>>>> enity-group.xml file? Since all the groups within
>>>>>>> the
>>>>>>>>> default group do not have an entity-group.xml
>>>>>>> file I assumed
>>>>>>>>> creating a datasource within a default group does
>>>>>>> not
>>>>>>>>> require an entity-group.xml file. There isnt one
>>>>>>> for
>>>>>>>>> locaderby datasource which is a default one. But
>>>>>>> I could be
>>>>>>>>> wrong
>>>>>>>>> While creating the enitygroup file what name do I
>>>>>>> need to
>>>>>>>>> give to Entity atritbute of entity-group?
>>>>>>> Random or
>>>>>>>>> schema name? Does each of this entity name map to
>>>>>>> a specific
>>>>>>>>> table or just the whole DB?
>>>>>>>>> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>>>>>>>
>>>>>>>>> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> <entity-group
>>>>>>> group="org.ofbiz" entity="IS
>>>>>>>>> THIS A RANDOM NAME??"/>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> <entity-group
>>>>>>> group="org.ofbiz"
>>>>>>>>> entity="HOW MANY ENTITIES DO I NEED TO HAVE??ONE
>>>>>>> per
>>>>>>>>> Datasource or ONE Per Schema???"/>
>>>>>>>>>
>>>>>>>>> </entitygroup>
>>>>>>>>>
>>>>>>>>> Kapil Garg
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>> Date: Sat, 30 Oct 2010 08:04:51 -0700
>>>>>>>>>> From: adrian.crum@yahoo.com
>>>>>>>>>> Subject: Re: Issues Creating Entities in
>>>>>>> Ofbiz from
>>>>>>>>> existing Schema
>>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>>>
>>>>>>>>>> You need to give your external datasource a
>>>>>>>>> group-name. Then in your external entity
>>>>>>> definitions, assign
>>>>>>>>> the entities to that group.
>>>>>>>>>>
>>>>>>>>>> -Adrian
>>>>>>>>>>
>>>>>>>>>> --- On Fri, 10/29/10, Kapil garg<ga...@hotmail.com>
>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>>>>>>> Subject: Issues Creating Entities in
>>>>>>> Ofbiz from
>>>>>>>>> existing Schema
>>>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>>>> Date: Friday, October 29, 2010, 12:09
>>>>>>> PM
>>>>>>>>>>>
>>>>>>>>>>> I am trying to create a entities within
>>>>>>> OFbiz out
>>>>>>>>> of an
>>>>>>>>>>> existing schema in production. Not sure
>>>>>>> if this
>>>>>>>>> is the best
>>>>>>>>>>> way to create entties out of an
>>>>>>> existing schema.
>>>>>>>>> Suggestions
>>>>>>>>>>> are welcomed!!
>>>>>>>>>>>
>>>>>>>>>>> I tried to add a datasource tag in
>>>>>>> default
>>>>>>>>> delegator in
>>>>>>>>>>> entity-engine.xml
>>>>>>>>>>> Followed the instructions on
>>>>>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
>>>>>>>>>>>
>>>>>>>>>>> Would like to know where I am going
>>>>>>> wrong. On
>>>>>>>>> restart, I
>>>>>>>>>>> realised that ofbiz does not finish to
>>>>>>> the point
>>>>>>>>> that I can
>>>>>>>>>>> get webtools or even login for
>>>>>>> ecommerce. IT has
>>>>>>>>> just stuck
>>>>>>>>>>> at soem point saying
>>>>>>> ServiceDispatcher.java
>>>>>>>>> 584 INFO
>>>>>>>>>>> Sync service..
>>>>>>>>>>> There is no exception or anything but
>>>>>>> OFbiz does
>>>>>>>>> not go
>>>>>>>>>>> further with complete laoding. Anything
>>>>>>> I am
>>>>>>>>> doing wrong?
>>>>>>>>>>> Being a default delegaotr, there was no
>>>>>>> special
>>>>>>>>>>> entity-group.xml file in the ofbiz 9_04
>>>>>>> code
>>>>>>>>> base. Hence I
>>>>>>>>>>> did not bother to create an
>>>>>>> entity-group.xml
>>>>>>>>> file
>>>>>>>>>>> My schema name is lronline, following
>>>>>>> are the
>>>>>>>>> entries I had
>>>>>>>>>>> in entity-engine.xml
>>>>>>>>>>> <delegator name="default"
>>>>>>>>> entity-model-reader="main"
>>>>>>>>>>> entity-group-reader="main"
>>>>>>>>> entity-eca-reader="main"
>>>>>>>>>>>
>>>>>>> distributed-cache-clear-enabled="false">
>>>>>>>>>>>
>>>>>>>>> <group-map
>>>>>>>>>>> group-name="org.ofbiz"
>>>>>>>>> datasource-name="localderby"/>
>>>>>>>>>>>
>>>>>>>>> <group-map
>>>>>>>>>>> group-name="org.ofbiz.olap"
>>>>>>>>>>> datasource-name="localderbyolap"/>
>>>>>>>>>>>
>>>>>>>>> <group-map
>>>>>>>>>>> group-name="org.ofbiz"
>>>>>>>>> datasource-name="mysql"/>
>>>>>>>>>>>
>>>>>>> </delegator>
>>>>>>>>>>>
>>>>>>>>>>> <datasource name="mysql"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> field-type-name="mysql"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> check-on-start="true"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> add-missing-on-start="true"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> check-pks-on-start="false"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> use-foreign-keys="true"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> join-style="ansi-no-parenthesis"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> alias-view-columns="false"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> drop-fk-use-foreign-key-keyword="true"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> table-type="InnoDB"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> character-set="latin1"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>> collate="latin1_general_cs">
>>>>>>>>>>>
>>>>>>>>> <read-data
>>>>>>>>>>> reader-name="seed"/>
>>>>>>>>>>>
>>>>>>>>> <read-data
>>>>>>>>>>> reader-name="seed-initial"/>
>>>>>>>>>>>
>>>>>>>>> <read-data
>>>>>>>>>>> reader-name="demo"/>
>>>>>>>>>>>
>>>>>>>>> <read-data
>>>>>>>>>>> reader-name="ext"/>
>>>>>>>>>>>
>>>>>>>>> <inline-jdbc
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>
>>>>>>>>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>
>>>>>>> jdbc-uri="jdbc:mysql://127.0.0.1/lronlineonedb?autoReconnect=true"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>
>>>>>>>>>>> jdbc-username="root"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>
>>>>>>>>>>> jdbc-password=""
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>
>>>>>>>>>>> isolation-level="ReadCommitted"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>
>>>>>>>>>>> pool-minsize="2"
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>
>>>>>>>>>>> pool-maxsize="250"/>
>>>>>>>>>>>
>>>>>>> <!--
>>>>>>>>> <jndi-jdbc
>>>>>>>>>>> jndi-server-name="localjndi"
>>>>>>>>>>> jndi-name="java:/MySqlDataSource"
>>>>>>>>>>> isolation-level="Serializable"/>
>>>>>>> -->
>>>>>>>>>>>
>>>>>>> </datasource>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Kapil Garg
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
>
Re: how to View the Entities after Inducing msql DB
Posted by BJ Freeman <bj...@free-man.net>.
you do a view source of the resultant webpage, then copy and paste into
hot-deploy/mycomponetname/entitydef/entitymodel.xml
it is recomended you use
./ant create-component
this will put the necessary structure for you component in hot-deploy
next you need to clean up the entities that match your current DB.
you can use
https://cwiki.apache.org/OFBIZ/ofbiz-tutorial-a-beginners-development-guide.html
as a reference.
=========================
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
Kapil garg sent the following on 10/30/2010 11:52 AM:
>
> I d like to know what exact entities have been created . Perhaps what has just happened after successful induction? What does this induce do eventually? What is the end result?Are there a list of entities created mapped to tables in the database?Can I see them in webtools under entity performance or somewhere? What all activities I could do with these entities if at at all they are created? Can they be used in any other component? How so? If I were to use them in Ecommerce component, do I need to add them in that component's entity def folder?
>
>
> Kapil Garg
>
>
>
>
>
>> Date: Sat, 30 Oct 2010 10:46:26 -0700
>> From: bjfree@free-man.net
>> To: user@ofbiz.apache.org
>> Subject: Re: how to View the Entities after Inducing msql DB
>>
>> please explain more what you mean by view
>>
>> =========================
>> 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
>>
>>
>> Kapil garg sent the following on 10/30/2010 11:33 AM:
>>>
>>> Hello All
>>> I was able to induce successfully the database with some error for unknown primary key without any group file or model file. I am not sure what was wrong with the
>>>
>>> I need to now view the entities.
>>>
>>> HOw do I do it?
>>>
>>>
>>> Kapil Garg
>>>
>>>
>>>
>>>
>>>
>>>> From: gargkapil@hotmail.com
>>>> To: user@ofbiz.apache.org
>>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>>> Date: Sun, 31 Oct 2010 03:47:41 +1000
>>>>
>>>>
>>>> Sure Adrian
>>>> Appreciate your reply.
>>>> My question was while creating entity-group.xml file what is the entity name I need to give? Does it map to some table name. IF I do create this file with entity attribute then what do I need to put in entity-model.xml file for this entity?
>>>>
>>>>
>>>> Kapil Garg
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>> Date: Sat, 30 Oct 2010 08:29:37 -0700
>>>>> From: adrian.crum@yahoo.com
>>>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>>>> To: user@ofbiz.apache.org
>>>>>
>>>>> You are asking a lot of questions, and they can all be answered, but it might be best to answer them one at a time.
>>>>>
>>>>> I thought you were trying to connect OFBiz to an external database - and my instructions will do that. Once you have that working, we can move on to the other questions.
>>>>>
>>>>> -Adrian
>>>>>
>>>>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com> wrote:
>>>>>
>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
>>>>>> To: user@ofbiz.apache.org
>>>>>> Date: Saturday, October 30, 2010, 8:21 AM
>>>>>>
>>>>>> how do we know which table or view does it map to? May it
>>>>>> does not map to any of the tables and is just an entity by
>>>>>> itself needed for ofbiz framework? If I were to put this
>>>>>> entity entry then I would need to also create an
>>>>>> entitymodel.xml file which would have some field tags? How
>>>>>> do i now which ones are they? Are they mapping to one on one
>>>>>> to a table in the schema? I would have imgined if that is
>>>>>> the case then is there an ant target to create entity group
>>>>>> or enity model xml files as it could be error prone given
>>>>>> they conform to in built entity-model.xsd schemas
>>>>>>
>>>>>> Aain how many such entitties do I need to create. If it is
>>>>>> one per table then I have to create as many entites equal to
>>>>>> the total numer off tables in the schemas. What about views
>>>>>> oe indices etc How are they mapped? What about Stored
>>>>>> Procedures, can they be converted to mmini lang or service
>>>>>> classes?
>>>>>>
>>>>>>
>>>>>> Kapil Garg
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>> Date: Sat, 30 Oct 2010 08:13:53 -0700
>>>>>>> From: adrian.crum@yahoo.com
>>>>>>> Subject: RE: Issues Creating Entities in Ofbiz from
>>>>>> existing Schema
>>>>>>> To: user@ofbiz.apache.org
>>>>>>>
>>>>>>> Correct, you will need an entity-group.xml file. It
>>>>>> should cntain one entry per external entity (or table).
>>>>>>>
>>>>>>> -Adrian
>>>>>>>
>>>>>>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com>
>>>>>> wrote:
>>>>>>>
>>>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>>>> Subject: RE: Issues Creating Entities in Ofbiz
>>>>>> from existing Schema
>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>> Date: Saturday, October 30, 2010, 8:11 AM
>>>>>>>>
>>>>>>>> but if it is in a default group then do I need to
>>>>>> create an
>>>>>>>> enity-group.xml file? Since all the groups within
>>>>>> the
>>>>>>>> default group do not have an entity-group.xml
>>>>>> file I assumed
>>>>>>>> creating a datasource within a default group does
>>>>>> not
>>>>>>>> require an entity-group.xml file. There isnt one
>>>>>> for
>>>>>>>> locaderby datasource which is a default one. But
>>>>>> I could be
>>>>>>>> wrong
>>>>>>>> While creating the enitygroup file what name do I
>>>>>> need to
>>>>>>>> give to Entity atritbute of entity-group?
>>>>>> Random or
>>>>>>>> schema name? Does each of this entity name map to
>>>>>> a specific
>>>>>>>> table or just the whole DB?
>>>>>>>> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>>>>>>>>
>>>>>>>> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
>>>>>>>>
>>>>>>>>
>>>>>>>> <entity-group
>>>>>> group="org.ofbiz" entity="IS
>>>>>>>> THIS A RANDOM NAME??"/>
>>>>>>>>
>>>>>>>>
>>>>>>>> <entity-group
>>>>>> group="org.ofbiz"
>>>>>>>> entity="HOW MANY ENTITIES DO I NEED TO HAVE??ONE
>>>>>> per
>>>>>>>> Datasource or ONE Per Schema???"/>
>>>>>>>>
>>>>>>>> </entitygroup>
>>>>>>>>
>>>>>>>> Kapil Garg
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>> Date: Sat, 30 Oct 2010 08:04:51 -0700
>>>>>>>>> From: adrian.crum@yahoo.com
>>>>>>>>> Subject: Re: Issues Creating Entities in
>>>>>> Ofbiz from
>>>>>>>> existing Schema
>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>>
>>>>>>>>> You need to give your external datasource a
>>>>>>>> group-name. Then in your external entity
>>>>>> definitions, assign
>>>>>>>> the entities to that group.
>>>>>>>>>
>>>>>>>>> -Adrian
>>>>>>>>>
>>>>>>>>> --- On Fri, 10/29/10, Kapil garg<ga...@hotmail.com>
>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> From: Kapil garg<ga...@hotmail.com>
>>>>>>>>>> Subject: Issues Creating Entities in
>>>>>> Ofbiz from
>>>>>>>> existing Schema
>>>>>>>>>> To: user@ofbiz.apache.org
>>>>>>>>>> Date: Friday, October 29, 2010, 12:09
>>>>>> PM
>>>>>>>>>>
>>>>>>>>>> I am trying to create a entities within
>>>>>> OFbiz out
>>>>>>>> of an
>>>>>>>>>> existing schema in production. Not sure
>>>>>> if this
>>>>>>>> is the best
>>>>>>>>>> way to create entties out of an
>>>>>> existing schema.
>>>>>>>> Suggestions
>>>>>>>>>> are welcomed!!
>>>>>>>>>>
>>>>>>>>>> I tried to add a datasource tag in
>>>>>> default
>>>>>>>> delegator in
>>>>>>>>>> entity-engine.xml
>>>>>>>>>> Followed the instructions on
>>>>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
>>>>>>>>>> Would like to know where I am going
>>>>>> wrong. On
>>>>>>>> restart, I
>>>>>>>>>> realised that ofbiz does not finish to
>>>>>> the point
>>>>>>>> that I can
>>>>>>>>>> get webtools or even login for
>>>>>> ecommerce. IT has
>>>>>>>> just stuck
>>>>>>>>>> at soem point saying
>>>>>> ServiceDispatcher.java
>>>>>>>> 584 INFO
>>>>>>>>>> Sync service..
>>>>>>>>>> There is no exception or anything but
>>>>>> OFbiz does
>>>>>>>> not go
>>>>>>>>>> further with complete laoding. Anything
>>>>>> I am
>>>>>>>> doing wrong?
>>>>>>>>>> Being a default delegaotr, there was no
>>>>>> special
>>>>>>>>>> entity-group.xml file in the ofbiz 9_04
>>>>>> code
>>>>>>>> base. Hence I
>>>>>>>>>> did not bother to create an
>>>>>> entity-group.xml
>>>>>>>> file
>>>>>>>>>> My schema name is lronline, following
>>>>>> are the
>>>>>>>> entries I had
>>>>>>>>>> in entity-engine.xml
>>>>>>>>>> <delegator name="default"
>>>>>>>> entity-model-reader="main"
>>>>>>>>>> entity-group-reader="main"
>>>>>>>> entity-eca-reader="main"
>>>>>>>>>>
>>>>>> distributed-cache-clear-enabled="false">
>>>>>>>>>>
>>>>>>>> <group-map
>>>>>>>>>> group-name="org.ofbiz"
>>>>>>>> datasource-name="localderby"/>
>>>>>>>>>>
>>>>>>>> <group-map
>>>>>>>>>> group-name="org.ofbiz.olap"
>>>>>>>>>> datasource-name="localderbyolap"/>
>>>>>>>>>>
>>>>>>>> <group-map
>>>>>>>>>> group-name="org.ofbiz"
>>>>>>>> datasource-name="mysql"/>
>>>>>>>>>>
>>>>>> </delegator>
>>>>>>>>>>
>>>>>>>>>> <datasource name="mysql"
>>>>>>>>>>
>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> field-type-name="mysql"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> check-on-start="true"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> add-missing-on-start="true"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> check-pks-on-start="false"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> use-foreign-keys="true"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> join-style="ansi-no-parenthesis"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> alias-view-columns="false"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> drop-fk-use-foreign-key-keyword="true"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> table-type="InnoDB"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> character-set="latin1"
>>>>>>>>>>
>>>>>>
>>>>>>>>>> collate="latin1_general_cs">
>>>>>>>>>>
>>>>>>>> <read-data
>>>>>>>>>> reader-name="seed"/>
>>>>>>>>>>
>>>>>>>> <read-data
>>>>>>>>>> reader-name="seed-initial"/>
>>>>>>>>>>
>>>>>>>> <read-data
>>>>>>>>>> reader-name="demo"/>
>>>>>>>>>>
>>>>>>>> <read-data
>>>>>>>>>> reader-name="ext"/>
>>>>>>>>>>
>>>>>>>> <inline-jdbc
>>>>>>>>>>
>>>>>>
>>>>>>>>
>>>>>>>>>> jdbc-driver="com.mysql.jdbc.Driver"
>>>>>>>>>>
>>>>>>
>>>>>>>>
>>>>>>>>>>
>>>>>>>>
>>>>>> jdbc-uri="jdbc:mysql://127.0.0.1/lronlineonedb?autoReconnect=true"
>>>>>>>>>>
>>>>>>
>>>>>>>>
>>>>>>>>>> jdbc-username="root"
>>>>>>>>>>
>>>>>>
>>>>>>>>
>>>>>>>>>> jdbc-password=""
>>>>>>>>>>
>>>>>>
>>>>>>>>
>>>>>>>>>> isolation-level="ReadCommitted"
>>>>>>>>>>
>>>>>>
>>>>>>>>
>>>>>>>>>> pool-minsize="2"
>>>>>>>>>>
>>>>>>
>>>>>>>>
>>>>>>>>>> pool-maxsize="250"/>
>>>>>>>>>>
>>>>>> <!--
>>>>>>>> <jndi-jdbc
>>>>>>>>>> jndi-server-name="localjndi"
>>>>>>>>>> jndi-name="java:/MySqlDataSource"
>>>>>>>>>> isolation-level="Serializable"/>
>>>>>> -->
>>>>>>>>>>
>>>>>> </datasource>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Kapil Garg
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>
RE: how to View the Entities after Inducing msql DB
Posted by Kapil garg <ga...@hotmail.com>.
I d like to know what exact entities have been created . Perhaps what has just happened after successful induction? What does this induce do eventually? What is the end result?Are there a list of entities created mapped to tables in the database?Can I see them in webtools under entity performance or somewhere? What all activities I could do with these entities if at at all they are created? Can they be used in any other component? How so? If I were to use them in Ecommerce component, do I need to add them in that component's entity def folder?
Kapil Garg
> Date: Sat, 30 Oct 2010 10:46:26 -0700
> From: bjfree@free-man.net
> To: user@ofbiz.apache.org
> Subject: Re: how to View the Entities after Inducing msql DB
>
> please explain more what you mean by view
>
> =========================
> 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
>
>
> Kapil garg sent the following on 10/30/2010 11:33 AM:
> >
> > Hello All
> > I was able to induce successfully the database with some error for unknown primary key without any group file or model file. I am not sure what was wrong with the
> >
> > I need to now view the entities.
> >
> > HOw do I do it?
> >
> >
> > Kapil Garg
> >
> >
> >
> >
> >
> >> From: gargkapil@hotmail.com
> >> To: user@ofbiz.apache.org
> >> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
> >> Date: Sun, 31 Oct 2010 03:47:41 +1000
> >>
> >>
> >> Sure Adrian
> >> Appreciate your reply.
> >> My question was while creating entity-group.xml file what is the entity name I need to give? Does it map to some table name. IF I do create this file with entity attribute then what do I need to put in entity-model.xml file for this entity?
> >>
> >>
> >> Kapil Garg
> >>
> >>
> >>
> >>
> >>
> >>> Date: Sat, 30 Oct 2010 08:29:37 -0700
> >>> From: adrian.crum@yahoo.com
> >>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
> >>> To: user@ofbiz.apache.org
> >>>
> >>> You are asking a lot of questions, and they can all be answered, but it might be best to answer them one at a time.
> >>>
> >>> I thought you were trying to connect OFBiz to an external database - and my instructions will do that. Once you have that working, we can move on to the other questions.
> >>>
> >>> -Adrian
> >>>
> >>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com> wrote:
> >>>
> >>>> From: Kapil garg<ga...@hotmail.com>
> >>>> Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
> >>>> To: user@ofbiz.apache.org
> >>>> Date: Saturday, October 30, 2010, 8:21 AM
> >>>>
> >>>> how do we know which table or view does it map to? May it
> >>>> does not map to any of the tables and is just an entity by
> >>>> itself needed for ofbiz framework? If I were to put this
> >>>> entity entry then I would need to also create an
> >>>> entitymodel.xml file which would have some field tags? How
> >>>> do i now which ones are they? Are they mapping to one on one
> >>>> to a table in the schema? I would have imgined if that is
> >>>> the case then is there an ant target to create entity group
> >>>> or enity model xml files as it could be error prone given
> >>>> they conform to in built entity-model.xsd schemas
> >>>>
> >>>> Aain how many such entitties do I need to create. If it is
> >>>> one per table then I have to create as many entites equal to
> >>>> the total numer off tables in the schemas. What about views
> >>>> oe indices etc How are they mapped? What about Stored
> >>>> Procedures, can they be converted to mmini lang or service
> >>>> classes?
> >>>>
> >>>>
> >>>> Kapil Garg
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>> Date: Sat, 30 Oct 2010 08:13:53 -0700
> >>>>> From: adrian.crum@yahoo.com
> >>>>> Subject: RE: Issues Creating Entities in Ofbiz from
> >>>> existing Schema
> >>>>> To: user@ofbiz.apache.org
> >>>>>
> >>>>> Correct, you will need an entity-group.xml file. It
> >>>> should cntain one entry per external entity (or table).
> >>>>>
> >>>>> -Adrian
> >>>>>
> >>>>> --- On Sat, 10/30/10, Kapil garg<ga...@hotmail.com>
> >>>> wrote:
> >>>>>
> >>>>>> From: Kapil garg<ga...@hotmail.com>
> >>>>>> Subject: RE: Issues Creating Entities in Ofbiz
> >>>> from existing Schema
> >>>>>> To: user@ofbiz.apache.org
> >>>>>> Date: Saturday, October 30, 2010, 8:11 AM
> >>>>>>
> >>>>>> but if it is in a default group then do I need to
> >>>> create an
> >>>>>> enity-group.xml file? Since all the groups within
> >>>> the
> >>>>>> default group do not have an entity-group.xml
> >>>> file I assumed
> >>>>>> creating a datasource within a default group does
> >>>> not
> >>>>>> require an entity-group.xml file. There isnt one
> >>>> for
> >>>>>> locaderby datasource which is a default one. But
> >>>> I could be
> >>>>>> wrong
> >>>>>> While creating the enitygroup file what name do I
> >>>> need to
> >>>>>> give to Entity atritbute of entity-group?
> >>>> Random or
> >>>>>> schema name? Does each of this entity name map to
> >>>> a specific
> >>>>>> table or just the whole DB?
> >>>>>> <entitygroup xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> >>>>>>
> >>>>>> xsi:noNamespaceSchemaLocation="http://ofbiz.apache.org/dtds/entitygroup.xsd">
> >>>>>>
> >>>>>>
> >>>>>> <entity-group
> >>>> group="org.ofbiz" entity="IS
> >>>>>> THIS A RANDOM NAME??"/>
> >>>>>>
> >>>>>>
> >>>>>> <entity-group
> >>>> group="org.ofbiz"
> >>>>>> entity="HOW MANY ENTITIES DO I NEED TO HAVE??ONE
> >>>> per
> >>>>>> Datasource or ONE Per Schema???"/>
> >>>>>>
> >>>>>> </entitygroup>
> >>>>>>
> >>>>>> Kapil Garg
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>> Date: Sat, 30 Oct 2010 08:04:51 -0700
> >>>>>>> From: adrian.crum@yahoo.com
> >>>>>>> Subject: Re: Issues Creating Entities in
> >>>> Ofbiz from
> >>>>>> existing Schema
> >>>>>>> To: user@ofbiz.apache.org
> >>>>>>>
> >>>>>>> You need to give your external datasource a
> >>>>>> group-name. Then in your external entity
> >>>> definitions, assign
> >>>>>> the entities to that group.
> >>>>>>>
> >>>>>>> -Adrian
> >>>>>>>
> >>>>>>> --- On Fri, 10/29/10, Kapil garg<ga...@hotmail.com>
> >>>>>> wrote:
> >>>>>>>
> >>>>>>>> From: Kapil garg<ga...@hotmail.com>
> >>>>>>>> Subject: Issues Creating Entities in
> >>>> Ofbiz from
> >>>>>> existing Schema
> >>>>>>>> To: user@ofbiz.apache.org
> >>>>>>>> Date: Friday, October 29, 2010, 12:09
> >>>> PM
> >>>>>>>>
> >>>>>>>> I am trying to create a entities within
> >>>> OFbiz out
> >>>>>> of an
> >>>>>>>> existing schema in production. Not sure
> >>>> if this
> >>>>>> is the best
> >>>>>>>> way to create entties out of an
> >>>> existing schema.
> >>>>>> Suggestions
> >>>>>>>> are welcomed!!
> >>>>>>>>
> >>>>>>>> I tried to add a datasource tag in
> >>>> default
> >>>>>> delegator in
> >>>>>>>> entity-engine.xml
> >>>>>>>> Followed the instructions on
> >>>>>>>> https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
> >>>>>>>> Would like to know where I am going
> >>>> wrong. On
> >>>>>> restart, I
> >>>>>>>> realised that ofbiz does not finish to
> >>>> the point
> >>>>>> that I can
> >>>>>>>> get webtools or even login for
> >>>> ecommerce. IT has
> >>>>>> just stuck
> >>>>>>>> at soem point saying
> >>>> ServiceDispatcher.java
> >>>>>> 584 INFO
> >>>>>>>> Sync service..
> >>>>>>>> There is no exception or anything but
> >>>> OFbiz does
> >>>>>> not go
> >>>>>>>> further with complete laoding. Anything
> >>>> I am
> >>>>>> doing wrong?
> >>>>>>>> Being a default delegaotr, there was no
> >>>> special
> >>>>>>>> entity-group.xml file in the ofbiz 9_04
> >>>> code
> >>>>>> base. Hence I
> >>>>>>>> did not bother to create an
> >>>> entity-group.xml
> >>>>>> file
> >>>>>>>> My schema name is lronline, following
> >>>> are the
> >>>>>> entries I had
> >>>>>>>> in entity-engine.xml
> >>>>>>>> <delegator name="default"
> >>>>>> entity-model-reader="main"
> >>>>>>>> entity-group-reader="main"
> >>>>>> entity-eca-reader="main"
> >>>>>>>>
> >>>> distributed-cache-clear-enabled="false">
> >>>>>>>>
> >>>>>> <group-map
> >>>>>>>> group-name="org.ofbiz"
> >>>>>> datasource-name="localderby"/>
> >>>>>>>>
> >>>>>> <group-map
> >>>>>>>> group-name="org.ofbiz.olap"
> >>>>>>>> datasource-name="localderbyolap"/>
> >>>>>>>>
> >>>>>> <group-map
> >>>>>>>> group-name="org.ofbiz"
> >>>>>> datasource-name="mysql"/>
> >>>>>>>>
> >>>> </delegator>
> >>>>>>>>
> >>>>>>>> <datasource name="mysql"
> >>>>>>>>
> >>>>
> >>>>>>>>
> >>>>>>
> >>>> helper-class="org.ofbiz.entity.datasource.GenericHelperDAO"
> >>>>>>>>
> >>>>
> >>>>>>>> field-type-name="mysql"
> >>>>>>>>
> >>>>
> >>>>>>>> check-on-start="true"
> >>>>>>>>
> >>>>
> >>>>>>>> add-missing-on-start="true"
> >>>>>>>>
> >>>>
> >>>>>>>> check-pks-on-start="false"
> >>>>>>>>
> >>>>
> >>>>>>>> use-foreign-keys="true"
> >>>>>>>>
> >>>>
> >>>>>>>> join-style="ansi-no-parenthesis"
> >>>>>>>>
> >>>>
> >>>>>>>> alias-view-columns="false"
> >>>>>>>>
> >>>>
> >>>>>>>> drop-fk-use-foreign-key-keyword="true"
> >>>>>>>>
> >>>>
> >>>>>>>> table-type="InnoDB"
> >>>>>>>>
> >>>>
> >>>>>>>> character-set="latin1"
> >>>>>>>>
> >>>>
> >>>>>>>> collate="latin1_general_cs">
> >>>>>>>>
> >>>>>> <read-data
> >>>>>>>> reader-name="seed"/>
> >>>>>>>>
> >>>>>> <read-data
> >>>>>>>> reader-name="seed-initial"/>
> >>>>>>>>
> >>>>>> <read-data
> >>>>>>>> reader-name="demo"/>
> >>>>>>>>
> >>>>>> <read-data
> >>>>>>>> reader-name="ext"/>
> >>>>>>>>
> >>>>>> <inline-jdbc
> >>>>>>>>
> >>>>
> >>>>>>
> >>>>>>>> jdbc-driver="com.mysql.jdbc.Driver"
> >>>>>>>>
> >>>>
> >>>>>>
> >>>>>>>>
> >>>>>>
> >>>> jdbc-uri="jdbc:mysql://127.0.0.1/lronlineonedb?autoReconnect=true"
> >>>>>>>>
> >>>>
> >>>>>>
> >>>>>>>> jdbc-username="root"
> >>>>>>>>
> >>>>
> >>>>>>
> >>>>>>>> jdbc-password=""
> >>>>>>>>
> >>>>
> >>>>>>
> >>>>>>>> isolation-level="ReadCommitted"
> >>>>>>>>
> >>>>
> >>>>>>
> >>>>>>>> pool-minsize="2"
> >>>>>>>>
> >>>>
> >>>>>>
> >>>>>>>> pool-maxsize="250"/>
> >>>>>>>>
> >>>> <!--
> >>>>>> <jndi-jdbc
> >>>>>>>> jndi-server-name="localjndi"
> >>>>>>>> jndi-name="java:/MySqlDataSource"
> >>>>>>>> isolation-level="Serializable"/>
> >>>> -->
> >>>>>>>>
> >>>> </datasource>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> Kapil Garg
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>
> >>>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>
> >>>
> >>>
> >>
> >
>