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: [email protected] > To: [email protected] > 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: [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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
