ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Le Roux" <jacques.lerou...@sfr.fr>
Subject Re: Entities Id as VARCHAR
Date Wed, 06 Apr 2011 16:37:10 GMT
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



Mime
View raw message