once you induce the entities from your db you will see a lot of those
answered.
=========================
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 10:47 AM:
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
