I think that the root of the problems here is to store information in the id fields (e.g. productId). It would instead be better to let the system generate a unique id and then store the more meaningful identifiers (e.g. UPC for products) in separate entities or fields (e.g. GoodIdentification for products, PartyIdentification for parties etc...). If the id fields are simply used to store a unique identifier then the current size will not be a problem. I know that the (seed and demo) data we release are misleading because they suggest information should be stored in the ids and similarly most of the applications (where for example, we have several search forms to search by product id or input fields for the productId) and I wish we will slowly improve them to provide a better implementation that hides the db ids to the user by implementing a better UX.
Jacopo On Wed, Apr 5, 2017 at 7:06 PM, 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 > > > > > > > > > > > > > > > > > > > > >
