You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Adrian Crum <ad...@sandglass-software.com> on 2011/04/06 20:01:12 UTC
Funambol Integration (was: Entities Id as VARCHAR)
Nothing is impossible.
I would be interested in taking a look at it - even if it doesn't run on
the current trunk.
-Adrian
On 4/6/2011 9:37 AM, Jacques Le Roux wrote:
> 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" <ad...@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
>
>
Re: Funambol Integration (was: Entities Id as VARCHAR)
Posted by Jacques Le Roux <ja...@les7arts.com>.
Mike,
Thanks to vbhansaly, I got this information: it's now an hot-depoy component in Opentaps, see
http://www.opentaps.org/forum/opentaps-general-discussions/general-discussions-english/funambol-admin-otfmadminguidedoc-corr
The good news is I saw it seems there are now support for smartphones (see funambol\_config\com\funambol\server\engine\pipeline).
The bad news I'm afraid, this is not only not directly compatible with OFBiz but even with the previous Opentaps version I adapted
to OFBiz. The joys of forking...
Jacques
From: "Jacques Le Roux" <ja...@les7arts.com>
> Hi Mike, Adrian,
>
> From the start in Opentaps it's only intended to work with Funambol Outlook Plugin. But I think you can extend from there, need
> more
> work...
>
> See https://issues.apache.org/jira/browse/OFBIZ-4247
>
> I have still to attach the certificate I specially created (I don't remember where I put it ;o). For the Opentaps part even after
> clean+export+zip it's still 100MB+. So I can't attach it to Jira (max 10MB). I'm uploading it to my own server and will put a link
> from Jira
>
> I hope I did not forget anything, anyway easy to add later...
>
> Jacques
>
> From: "Mike" <mz...@gmail.com>
>> Hey Jacques. What is the extent of the Funambol integration? What
>> OfBiz features can a smartphone get from it? Thanks.
>>
>> On Wed, Apr 6, 2011 at 1:48 PM, Jacques Le Roux
>> <ja...@les7arts.com> wrote:
>>> Ho, it should run on trunk, I used r1055454. I will try to see the status
>>> tomorrow morning... The Jira was almost done but I got very busy since
>>> then...
>>>
>>> Jacques
>>>
>>> From: "Adrian Crum" <ad...@sandglass-software.com>
>>>>
>>>> Nothing is impossible.
>>>>
>>>> I would be interested in taking a look at it - even if it doesn't run on
>>>> the current trunk.
>>>>
>>>> -Adrian
>>>>
>>>> On 4/6/2011 9:37 AM, Jacques Le Roux wrote:
>>>>>
>>>>> 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" <ad...@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
>>>>>
>>>>>
>>>
>>>
>>>
>>
>
>
Re: Funambol Integration (was: Entities Id as VARCHAR)
Posted by Jacques Le Roux <ja...@les7arts.com>.
Hi Mike, Adrian,
>From the start in Opentaps it's only intended to work with Funambol Outlook Plugin. But I think you can extend from there, need more
work...
See https://issues.apache.org/jira/browse/OFBIZ-4247
I have still to attach the certificate I specially created (I don't remember where I put it ;o). For the Opentaps part even after
clean+export+zip it's still 100MB+. So I can't attach it to Jira (max 10MB). I'm uploading it to my own server and will put a link
from Jira
I hope I did not forget anything, anyway easy to add later...
Jacques
From: "Mike" <mz...@gmail.com>
> Hey Jacques. What is the extent of the Funambol integration? What
> OfBiz features can a smartphone get from it? Thanks.
>
> On Wed, Apr 6, 2011 at 1:48 PM, Jacques Le Roux
> <ja...@les7arts.com> wrote:
>> Ho, it should run on trunk, I used r1055454. I will try to see the status
>> tomorrow morning... The Jira was almost done but I got very busy since
>> then...
>>
>> Jacques
>>
>> From: "Adrian Crum" <ad...@sandglass-software.com>
>>>
>>> Nothing is impossible.
>>>
>>> I would be interested in taking a look at it - even if it doesn't run on
>>> the current trunk.
>>>
>>> -Adrian
>>>
>>> On 4/6/2011 9:37 AM, Jacques Le Roux wrote:
>>>>
>>>> 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" <ad...@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
>>>>
>>>>
>>
>>
>>
>
Re: Funambol Integration (was: Entities Id as VARCHAR)
Posted by Mike <mz...@gmail.com>.
Hey Jacques. What is the extent of the Funambol integration? What
OfBiz features can a smartphone get from it? Thanks.
On Wed, Apr 6, 2011 at 1:48 PM, Jacques Le Roux
<ja...@les7arts.com> wrote:
> Ho, it should run on trunk, I used r1055454. I will try to see the status
> tomorrow morning... The Jira was almost done but I got very busy since
> then...
>
> Jacques
>
> From: "Adrian Crum" <ad...@sandglass-software.com>
>>
>> Nothing is impossible.
>>
>> I would be interested in taking a look at it - even if it doesn't run on
>> the current trunk.
>>
>> -Adrian
>>
>> On 4/6/2011 9:37 AM, Jacques Le Roux wrote:
>>>
>>> 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" <ad...@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
>>>
>>>
>
>
>
Re: Funambol Integration (was: Entities Id as VARCHAR)
Posted by Jacques Le Roux <ja...@les7arts.com>.
Ho, it should run on trunk, I used r1055454. I will try to see the status tomorrow morning... The Jira was almost done but I got
very busy since then...
Jacques
From: "Adrian Crum" <ad...@sandglass-software.com>
> Nothing is impossible.
>
> I would be interested in taking a look at it - even if it doesn't run on the current trunk.
>
> -Adrian
>
> On 4/6/2011 9:37 AM, Jacques Le Roux wrote:
>> 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" <ad...@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
>>
>>