Yes, BJ explained it in details at
https://cwiki.apache.org/confluence/display/OFBIZ/Handling+of+External+data
Jacques
From: "Adrian Crum" <[email protected]>
You would create entity definitions for your external tables (each table would be an entity). Assign those entities to a unique
group-name by including them in an entity-group.xml file. Add the new group-name to the group-map element in entityengine.xml file
and you are ready to go. You can then access your external entities using the delegator.
-Adrian
--- On Sat, 10/30/10, Kapil garg <[email protected]> wrote:
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: [email protected]
> Subject: RE: Issues Creating Entities in Ofbiz from
existing Schema
> To: [email protected]
>
> 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 <[email protected]>
wrote:
>
> > From: Kapil garg <[email protected]>
> > Subject: RE: Issues Creating Entities in Ofbiz
from existing Schema
> > To: [email protected]
> > 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: [email protected]
> > > Subject: RE: Issues Creating Entities in
Ofbiz from
> > existing Schema
> > > To: [email protected]
> > >
> > > 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 <[email protected]>
> > wrote:
> > >
> > > > From: Kapil garg <[email protected]>
> > > > Subject: RE: Issues Creating Entities
in Ofbiz
> > from existing Schema
> > > > To: [email protected]
> > > > 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: [email protected]
> > > > > Subject: Re: Issues Creating
Entities in
> > Ofbiz from
> > > > existing Schema
> > > > > To: [email protected]
> > > > >
> > > > > 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
<[email protected]>
> > > > wrote:
> > > > >
> > > > > > From: Kapil garg <[email protected]>
> > > > > > Subject: Issues Creating
Entities in
> > Ofbiz from
> > > > existing Schema
> > > > > > To: [email protected]
> > > > > > 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
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> >
>
>
>
