[jira] [Commented] (OFBIZ-8343) Make data type field length of id fields accept guid ids

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-8343?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15699481#comment-15699481 ]

Jacques Le Roux commented on OFBIZ-8343:
----------------------------------------

First you need to read https://cwiki.apache.org/confluence/display/OFBADMIN/Coding+Conventions#CodingConventions-EntityFieldNames but of course things can change.

Because it does not need any installation and can be embedded we deliver OFBiz with Derby. Derby has a limitations of 30 chars for column names https://db.apache.org/derby/docs/10.0/manuals/reference/sqlj268.html#Identifier+length+limitations

If you know a mean to override this situation please share (don't forget the JDBC driver aspect). Then rests that this would be an important change and would need a migration service  https://cwiki.apache.org/confluence/display/OFBIZ/Revisions+Requiring+Data+Migration+-+upgrade+ofbiz

Anyway this kind of topic needs to be prior discussed in the dev ML... Else please close...

> Make data type field length of id fields accept guid ids
> --------------------------------------------------------
>
>                 Key: OFBIZ-8343
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-8343
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework
>    Affects Versions: Trunk
>            Reporter: Pierre Smits
>            Assignee: Pierre Smits
>         Attachments: OFBIZ-8343-fieldtype-36.patch, OFBIZ-8343-fieldtype.patch
>
>
> Currently the length of id fields is limited to 20 characters. In order for these fields to accept GUIIDs the length should be increased to 32 characters.

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)