[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-438) Preference Values whose length is greater than 255 characters cannot be saved

[Marcelo Mazza (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBPORTAL-438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12437878#action_12437878 ] 

Marcelo Mazza commented on JBPORTAL-438:
----------------------------------------

Why don't you define the field jbp_user_pref_value.jbp_value as TEXT? I do have the same problem, but in the table
jbp_portlet_state_entry_value (field jbp_value).


> Preference Values whose length is greater than 255 characters cannot be saved
> -----------------------------------------------------------------------------
>
>                 Key: JBPORTAL-438
>                 URL: https://jira.jboss.org/jira/browse/JBPORTAL-438
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal Portlet
>    Affects Versions: 2.0 Final, 2.0 Branch, 2.2 Branch, 2.4 Final
>         Environment: Windows 2000, JBAS 4.02
>            Reporter: Dennis Meers
>
> If you create a portlet that supports EDIT mode and a logged-in user edits a preference, if the value they put in has more than 255 chars, an error occurs.  This is because the table that saves user preference values (jbp_user_pref_value) has a column called 'jbp_value' that is defined as 'VARCHAR(255)'.
> I don't know if the portlet spec defines how many characters are allowed in a preference value, but 255 characters seems small for some portlets.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira