ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adrian Crum <adrian.c...@yahoo.com>
Subject RE: Issues Creating Entities in Ofbiz from existing Schema
Date Sat, 30 Oct 2010 15:13:53 GMT
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