Mailing-List: contact user-help@ofbiz.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@ofbiz.apache.org
Received-SPF: neutral (nike.apache.org: 93.17.128.1 is neither permitted nor
 denied by domain of jacques.leroux60@sfr.fr)
Message-ID: <968F0BDA02AD41A5AFCF6D397EB96881@inspiron530>
From: "Jacques Le Roux" <jacques.leroux60@sfr.fr>
To: <user@ofbiz.apache.org>
References: <20110403041526.GA15246@localhost.phub.net.cable.rogers.com>
 <4D996301.8040801@nereide.fr> <4353DB01-DCD3-4D29-9495-159FE6C99029@me.com>
 <20110405231318.GA5569@localhost.phub.net.cable.rogers.com>
 <4D9BDB9D.6080703@sandglass-software.com>
 <20110406001907.GB5569@localhost.phub.net.cable.rogers.com>
 <4D9BEAF9.8060908@sandglass-software.com>
 <20110406005757.GC5569@localhost.phub.net.cable.rogers.com>
 <4D9C8AA5.4040609@sandglass-software.com>
Subject: Re: Entities Id as VARCHAR
Date: Wed, 6 Apr 2011 18:37:10 +0200
MIME-Version: 1.0
Content-Type: text/plain;
	format=flowed;
	charset="iso-8859-1";
	reply-type=original
Content-Transfer-Encoding: 8bit

H� wait Adrian, during fall I have already re-written their Funambol module, with doc ready and all. It's just that I have not
enough time to publish it on Jira (was done for previous client in a custom app). I just need to test it again in OFBiz OOTB...

If you are interested there is only one point I could not handle (and I think it's impossible)
https://core.forge.funambol.org/ds/viewMessage.do?dsForumId=405&dsMessageId=139101

Jacques

From: "Adrian Crum" <adrian.crum@sandglass-software.com>
> Opentaps going with Hibernate (and Spring) was a useless effort, in my opinion.
>
> Coincidentally, I'm currently working on rewriting their Funambol module so it will run on plain OFBiz, and I can assure you,
> adding those technologies does nothing more than make a simple task unnecessarily complicated.
>
> OFBiz has the ability to generate UI artifacts from the database.
>
> -Adrian
>
>
> On 4/5/2011 5:57 PM, Mansour Al Akeel wrote:
>> Adrian,
>>
>> Evalutating other technologies and how I can utilize them and combine
>> them with ofbiz database is not a waste of time, like you claim.
>>
>> There are technologies available that allow us to generate data model,
>> and services from the database, and leave us with only UI to create. Some frameworks
>> like isis may even create the UI using naked objects, from the database.
>>
>> I wanted to see how far I can go, generating JPA entities using ofbiz database.
>> That's why I wanted to name an id "id", and make it an integer.
>>
>> This is not useless effort. Opentaps, have gone with hibernate already !
>>
>> I trully value your advice about how to use my time productively.
>>
>>
>> On Tue Apr 05,2011 09:24 pm, Adrian Crum wrote:
>>> Huh? What does Isis have to do with OFBiz?
>>>
>>> -Adrian
>>>
>>> On 4/5/2011 5:19 PM, Mansour Al Akeel wrote:
>>>> http://incubator.apache.org/isis/
>>>>
>>>>
>>>> On Tue Apr 05,2011 08:18 pm, Adrian Crum wrote:
>>>>> Why would you want to do that? It would result in rewriting the entire
>>>>> project to change the field names.
>>>>>
>>>>> It seems to me you will be wasting a lot of time trying to make OFBiz
>>>>> code look the way you want it to look - without adding anything new or
>>>>> fixing anything. Instead, why not use the project in the way it was
>>>>> intended, and spend your time getting something useful accomplished?
>>>>>
>>>>> -Adrian
>>>>>
>>>>> On 4/5/2011 4:13 PM, Mansour Al Akeel wrote:
>>>>>> Thank you all. I understand now the reasons behind using VARCHAR.
>>>>>>
>>>>>> I found my way around this. I can just change the data type in the
>>>>>> fieldtypepostnew.xml. This way I can declare all the ids as integers,
>>>>>> and indicators as boolean instead of CHAR(1).
>>>>>>
>>>>>> However still wondering if there is a way to change the name of the ids
>>>>>> to only id without having to go through each foriegn key.
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Mon Apr 04,2011 05:08 am, David E Jones wrote:
>>>>>>> As for naming all "id" fields just plain "id", it makes it far more difficult to keep track of foreign keys. The nice thing
>>>>>>> about giving even sequenced ID fields a somewhat unique name is that you can use that same name on other entities/tables and
>>>>>>> have them match up automatically.
>>>>>>>
>>>>>>> The Entity Engine does a lot with field name mapping for relationships between entities, and there are thousands of these in
>>>>>>> the OFBiz data model, so the few extra characters goes a long way toward making things easier to understand and maintain.
>>>>>>>
>>>>>>> -David
>>>>>>>
>>>>>>>
>>>>>>> On Apr 4, 2011, at 12:19 AM, Erwan de FERRIERES wrote:
>>>>>>>
>>>>>>>> Le 03/04/2011 06:15, Mansour Al Akeel a ?crit :
>>>>>>>>> Hello all,
>>>>>>>>>
>>>>>>>>> I am wondering about the reasons behind using VARCHAR for entities Id,
>>>>>>>>> instead of a numeric value with autoincrement. Another thing is the
>>>>>>>>> naming of the primary key. For example, accommodation_class has it's
>>>>>>>>> primary key as "accommodation_class_id". Wouldn't it be easier just to
>>>>>>>>> name it "id"?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>> Hi Mansour,
>>>>>>>>
>>>>>>>> just go to this page : http://ofbiz.135035.n4.nabble.com/Why-primary-keys-are-VAR-CHAR-type-in-OFBiz-td146555.html#a146562
>>>>>>>>
>>>>>>>> Cheers,
>>>>>>>>
>>>>>>>> -- 
>>>>>>>> Erwan de FERRIERES
>>>>>>>> www.nereide.biz