ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From BJ Freeman <bjf...@free-man.net>
Subject Re: how to View the Entities after Inducing msql DB
Date Sat, 30 Oct 2010 18:43:23 GMT
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<gargkapil@hotmail.com> wrote:
>>>>>>
>>>>>>> From: Kapil garg<gargkapil@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<gargkapil@hotmail.com>
>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> From: Kapil garg<gargkapil@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<gargkapil@hotmail.com>
>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> From: Kapil garg<gargkapil@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
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
>


Mime
View raw message