Pierre, here is an example from the demo data:
accounting_OrganizationData.xml: <PartyRole partyId="RECEIVING"
roleTypeId="INTERNAL_ORGANIZATIO"/>
The default of ID (20 chrs) is so small that you can't even properly spell
"INTERNAL_ORGANIZATION"... I work with databases every day, and I would be
so limited if I had to work with such small primary IDs.
The thing is you don't want to not limit yourself when you first build a
database. The jira is interesting, and GUIDs are a good example.
Personally, I use postgresql, using the "localpostnew" type... Removed from
trunk for some reason.. It has unlimited primary ID sizes (ok, 2.1G), which
allows me to create any sort of primary key I want.
<field-type-def type="id" sql-type="TEXT" java-type="String"/>
<field-type-def type="id-long" sql-type="TEXT" java-type="String"/>
<field-type-def type="id-vlong" sql-type="TEXT" java-type="String"/>
If you think that type=TEXT is slow or less efficient.. Here is what
postgres says about type "TEXT"..
https://www.postgresql.org/docs/9.3/static/datatype-character.html
*Tip:* There is no performance difference among these three types, apart
from increased storage space when using the blank-padded type, and a few
extra CPU cycles to check the length when storing into a length-constrained
column. While character(n) has performance advantages in some other
database systems, there is no such advantage inPostgreSQL; in fact
character(n) is usually the slowest of the three because of its additional
storage costs. In most situations text or character varying should be used
instead.
Mysql has a similar type... I personally haven't tested it.
On Wed, Apr 5, 2017 at 10:06 AM, Pierre Smits <[email protected]>
wrote:
> HI Mike, all,
>
> Re 2: Talk about adjustment of default key size
> Why is that absurd? You believe it is too long/too short?
> Following JIRA issue may be of interest:
> https://issues.apache.org/jira/browse/OFBIZ-8343
>
> Best regards,
>
> Pierre Smits
>
> ORRTIZ.COM <http://www.orrtiz.com>
> OFBiz based solutions & services
>
> OFBiz Extensions Marketplace
> http://oem.ofbizci.net/oci-2/
>
> On Wed, Apr 5, 2017 at 5:10 PM, Mike <[email protected]> wrote:
>
> > Nice videos. Regarding the mysql setup, you may want to include two
> items:
> >
> > 1) Make sure mysql is setup as UTF8, discussed earlier in this mail
> group.
> > Requires tweaking:
> >
> > framework/entity/config/entityengine.xml
> > /etc/mysql/my.cnf
> >
> > 2) Talk about adjusting the default sizes of primary keys (ID). The
> > default is an absurd 20 characters:
> >
> > framework/entity/fieldtype/fieldtypemysql.xml
> >
> > <field-type-def type="id" sql-type="VARCHAR(20)" java-type="String"/>
> > <field-type-def type="id-long" sql-type="VARCHAR(60)"
> > java-type="String"/>
> > <field-type-def type="id-vlong" sql-type="VARCHAR(250)"
> > java-type="String"/>
> >
> >
> >
> > On Wed, Apr 5, 2017 at 6:03 AM, Pranay Pandey <
> > [email protected]> wrote:
> >
> > > Thanks so much Deepak!
> > >
> > > Best regards,
> > >
> > > Pranay Pandey
> > >
> > >
> > > On Wed, Apr 5, 2017 at 5:51 PM, Deepak Dixit
> <deepak.dixit@hotwaxsystems.
> > > com
> > > > wrote:
> > >
> > > > Hi Team,
> > > >
> > > > Here are some more videos from Pranay
> > > >
> > > > - Setup OFBiz in IntelliJ IDEA IDE - Release 16.11 and Trunk
> > > > <https://youtu.be/mxToh2rX7NY>
> > > > - Setup OFBiz with MySQL <https://youtu.be/Lzmv0DCC5N4>
> > > >
> > > >
> > > > Thanks Pranay for your effort.
> > > >
> > > >
> > > > Thanks & Regards
> > > > --
> > > > Deepak Dixit
> > > > www.hotwaxsystems.com
> > > >
> > > > On Wed, Mar 22, 2017 at 7:07 PM, akash jain <[email protected]>
> > > > wrote:
> > > >
> > > > > Nice videos, thanks Pranay!
> > > > >
> > > > > Thanks and Regards
> > > > > --
> > > > > Akash Jain
> > > > >
> > > > > On Thu, Mar 9, 2017 at 6:18 PM, Deepak Dixit
> > > <deepak.dixit@hotwaxsystems.
> > > > > com
> > > > > > wrote:
> > > > >
> > > > > > Hi Everyone,
> > > > > >
> > > > > > Pranay has created two video tutorials, these have been published
> > on
> > > > our
> > > > > > OFBiz YouTube channel <https://www.youtube.com/user/ofbiz>:
> > > > > > 1 - Apache OFBiz Mailing Lists <https://www.youtube.com/
> > > > > > watch?v=bIS2kftvsq4>
> > > > > > 2 - OFBiz Beginners Tutorial - Basic Setup Release16.11
> > > > > > <https://youtu.be/efkB_aN-ODw>
> > > > > >
> > > > > > Thanks Pranay for these helpful videos.
> > > > > >
> > > > > > Thanks & Regards
> > > > > > --
> > > > > > Deepak Dixit
> > > > > > www.hotwaxsystems.com
> > > > > >
> > > > >
> > > >
> > >
> >
>
