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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
