Return-Path: 
 <user-return-35386-apmail-ofbiz-user-archive=ofbiz.apache.org@ofbiz.apache.org>
Delivered-To: apmail-ofbiz-user-archive@www.apache.org
Received: (qmail 88928 invoked from network); 30 Oct 2010 15:11:38 -0000
Received: from unknown (HELO mail.apache.org) (140.211.11.3)
  by 140.211.11.9 with SMTP; 30 Oct 2010 15:11:38 -0000
Received: (qmail 75299 invoked by uid 500); 30 Oct 2010 15:11:37 -0000
Delivered-To: apmail-ofbiz-user-archive@ofbiz.apache.org
Received: (qmail 75221 invoked by uid 500); 30 Oct 2010 15:11:36 -0000
Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ofbiz.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ofbiz.apache.org>
List-Post: <mailto:user@ofbiz.apache.org>
List-Id: <user.ofbiz.apache.org>
Reply-To: user@ofbiz.apache.org
Delivered-To: mailing list user@ofbiz.apache.org
Received: (qmail 75209 invoked by uid 99); 30 Oct 2010 15:11:35 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 30 Oct 2010 15:11:35 +0000
X-ASF-Spam-Status: No, hits=4.7 required=10.0
	tests=FREEMAIL_FROM,FREEMAIL_REPLY,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (athena.apache.org: domain of gargkapil@hotmail.com
 designates 65.55.116.20 as permitted sender)
Received: from [65.55.116.20] (HELO blu0-omc1-s9.blu0.hotmail.com)
 (65.55.116.20)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 30 Oct 2010 15:11:27 +0000
Received: from BLU159-W48 ([65.55.116.9]) by blu0-omc1-s9.blu0.hotmail.com
 with Microsoft SMTPSVC(6.0.3790.4675);
	 Sat, 30 Oct 2010 08:11:05 -0700
Message-ID: <BLU159-w48933353CB4170C9070748A3460@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_b88c6d40-5dbd-4498-a914-29cbcb91df47_"
X-Originating-IP: [134.101.216.100]
From: Kapil garg <gargkapil@hotmail.com>
To: <user@ofbiz.apache.org>
Subject: RE: Issues Creating Entities in Ofbiz from existing Schema
Date: Sun, 31 Oct 2010 01:11:05 +1000
Importance: Normal
In-Reply-To: <110311.41114.qm@web63107.mail.re1.yahoo.com>
References: 
 <BLU159-w111D6D4953FCA5D1FE2DB9A3450@phx.gbl>,<110311.41114.qm@web63107.mail.re1.yahoo.com>
MIME-Version: 1.0
X-OriginalArrivalTime: 30 Oct 2010 15:11:05.0869 (UTC)
 FILETIME=[AC9423D0:01CB7844]

--_b88c6d40-5dbd-4498-a914-29cbcb91df47_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


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 datasour=
ce which is a default one. But I could be wrong
While creating the enitygroup file what name do I need to give to Entity at=
ritbute of  entity-group? Random or schema name? Does each of this entity n=
ame map to a specific table or just the whole DB?
<entitygroup xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation=3D"http://ofbiz.apache.org/dtds/entit=
ygroup.xsd">

 =20
    <entity-group group=3D"org.ofbiz" entity=3D"IS THIS A RANDOM NAME??"/>

=20
    <entity-group group=3D"org.ofbiz" entity=3D"HOW MANY ENTITIES DO I NEED=
 TO HAVE??ONE per Datasource or ONE Per Schema???"/>

</entitygroup>

Kapil Garg
=20




> Date: Sat=2C 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
>=20
> You need to give your external datasource a group-name. Then in your exte=
rnal entity definitions=2C assign the entities to that group.
>=20
> -Adrian
>=20
> --- On Fri=2C 10/29/10=2C Kapil garg <gargkapil@hotmail.com> wrote:
>=20
> > From: Kapil garg <gargkapil@hotmail.com>
> > Subject: Issues Creating Entities in Ofbiz from existing Schema
> > To: user@ofbiz.apache.org
> > Date: Friday=2C October 29=2C 2010=2C 12:09 PM
> >=20
> > 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!!
> >=20
> > 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=2C 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=2C 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=2C following are the entries I had
> > in entity-engine.xml
> >  <delegator name=3D"default" entity-model-reader=3D"main"
> > entity-group-reader=3D"main" entity-eca-reader=3D"main"
> > distributed-cache-clear-enabled=3D"false">
> >         <group-map
> > group-name=3D"org.ofbiz" datasource-name=3D"localderby"/>
> >         <group-map
> > group-name=3D"org.ofbiz.olap"
> > datasource-name=3D"localderbyolap"/>
> >         <group-map
> > group-name=3D"org.ofbiz" datasource-name=3D"mysql"/>
> >     </delegator>
> >=20
> > <datasource name=3D"mysql"
> >           =20
> > helper-class=3D"org.ofbiz.entity.datasource.GenericHelperDAO"
> >           =20
> > field-type-name=3D"mysql"
> >           =20
> > check-on-start=3D"true"
> >           =20
> > add-missing-on-start=3D"true"
> >           =20
> > check-pks-on-start=3D"false"
> >           =20
> > use-foreign-keys=3D"true"
> >           =20
> > join-style=3D"ansi-no-parenthesis"
> >           =20
> > alias-view-columns=3D"false"
> >           =20
> > drop-fk-use-foreign-key-keyword=3D"true"
> >           =20
> > table-type=3D"InnoDB"
> >           =20
> > character-set=3D"latin1"
> >           =20
> > collate=3D"latin1_general_cs">
> >         <read-data
> > reader-name=3D"seed"/>
> >         <read-data
> > reader-name=3D"seed-initial"/>
> >         <read-data
> > reader-name=3D"demo"/>
> >         <read-data
> > reader-name=3D"ext"/>
> >         <inline-jdbc
> >               =20
> > jdbc-driver=3D"com.mysql.jdbc.Driver"
> >               =20
> > jdbc-uri=3D"jdbc:mysql://127.0.0.1/lronlineonedb?autoReconnect=3Dtrue"
> >               =20
> > jdbc-username=3D"root"
> >               =20
> > jdbc-password=3D""
> >               =20
> > isolation-level=3D"ReadCommitted"
> >               =20
> > pool-minsize=3D"2"
> >               =20
> > pool-maxsize=3D"250"/>
> >         <!-- <jndi-jdbc
> > jndi-server-name=3D"localjndi"
> > jndi-name=3D"java:/MySqlDataSource"
> > isolation-level=3D"Serializable"/> -->
> >     </datasource>
> >    =20
> >=20
> >=20
> > Kapil Garg
> > =20
> >=20
> >=20
> >    =20
> >        =20
> >          =20
> >  =20
>=20
>=20
>      =20
 		 	   		  =

--_b88c6d40-5dbd-4498-a914-29cbcb91df47_--