[jira] [Commented] (OFBIZ-12672) Strip data to maximum column length for initialRequest and initialReferrer

["Jacques Le Roux (Jira)" <ji...@apache.org>]

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

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

Thanks Georg,

That sounds like a good idea to me. 

If nobody see a problem with that (are other DBMS more conciliant than 2000 chars?) I'll push the PR in trunk after this weekend. We could even backport in releases branches (we usually do only for bugs) if nobody is against. The code is quite simple, no possible side-effects.

> Strip data to maximum column length for initialRequest and initialReferrer
> --------------------------------------------------------------------------
>
>                 Key: OFBIZ-12672
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-12672
>             Project: OFBiz
>          Issue Type: Improvement
>          Components: framework/webapp
>    Affects Versions: 18.12.05, 22.01.01, Upcoming Branch
>            Reporter: Georg Beck
>            Assignee: Jacques Le Roux
>            Priority: Minor
>
> Analogous to the existing limitation of the "initialUserAgent" to 250 characters, installation of a limitation of 2000 characters for initialRequest and initialReferrer, so as not to exit with "MysqlDataTruncation: Data truncation: Data too long for column 'INITIAL_REFERRER' at row 1" in the case of very long requests.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)