Entities Id as VARCHAR
Locked
 
|
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"? |
Re: Entities Id as VARCHAR
|
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"? > > > > > 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 |
|
|
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 |
|
|
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 > |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
Can anyone tell me what exactly i have to do after i get the training in
the Apache Ofbiz . On Wed, Apr 6, 2011 at 6:27 AM, Mansour Al Akeel <[hidden email]>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 > |
|
|
Conquer the world.
Regards Scott On 6/04/2011, at 7:06 PM, Sumit Sabu wrote: > Can anyone tell me what exactly i have to do after i get the training in > the Apache Ofbiz . > > On Wed, Apr 6, 2011 at 6:27 AM, Mansour Al Akeel > <[hidden email]>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 >> |
smime.p7s (3K) |
|
In reply to this post by Mansour
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 |
|
|
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" <[hidden email]> > 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 |
|
|
In reply to this post by Scott Gray-2
"Can anyone tell me what exactly i have to do after i get the training in
the Apache Ofbiz ." Answer - After you learn Ofbiz, you won't have to ask the question. -----Original Message----- From: Scott Gray [mailto:[hidden email]] Sent: Wednesday, April 06, 2011 5:56 AM To: [hidden email] Subject: Re: Entities Id as VARCHAR Conquer the world. Regards Scott On 6/04/2011, at 7:06 PM, Sumit Sabu wrote: > Can anyone tell me what exactly i have to do after i get the training in > the Apache Ofbiz . > > On Wed, Apr 6, 2011 at 6:27 AM, Mansour Al Akeel > <[hidden email]>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 >> 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 : >> z-td146555.html#a146562 >>>>>>>> >>>>>>>> Cheers, >>>>>>>> >>>>>>>> -- >>>>>>>> Erwan de FERRIERES >>>>>>>> www.nereide.biz >> |
Funambol Integration (was: Entities Id as VARCHAR)
|
|
In reply to this post by Jacques Le Roux-4
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" <[hidden email]> >> 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)
Administrator
|
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" <[hidden email]> > 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" <[hidden email]> >>> 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 >> >> |
|
|
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 <[hidden email]> 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" <[hidden email]> >> >> 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" <[hidden email]> >>>> >>>> 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)
|
Administrator
|
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" <[hidden email]> > 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 > <[hidden email]> 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" <[hidden email]> >>> >>> 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" <[hidden email]> >>>>> >>>>> 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)
|
Administrator
|
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" <[hidden email]> > 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" <[hidden email]> >> 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 >> <[hidden email]> 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" <[hidden email]> >>>> >>>> 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" <[hidden email]> >>>>>> >>>>>> 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)
|
Administrator
|
In reply to this post by Adrian Crum-3
Oops sorry, this already existed in previous version. I did not notice as I have still not needed them, but it's in the zip file on
my server also. Not sure how it works, and looks like there is nothing for Android, it's a bit old I guess, not sure... Jacques From: "Jacques Le Roux" <[hidden email]> > 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" <[hidden email]> >> 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" <[hidden email]> >>> 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 >>> <[hidden email]> 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" <[hidden email]> >>>>> >>>>> 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" <[hidden email]> >>>>>>> >>>>>>> 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 >>>>>> >>>>>> >>>> >>>> >>>> >>> >> >> > |
«
Return to OFBiz - User
|
1 view|%1 views
| Free forum by Nabble | Edit this page |