[jboss-jira] [JBoss JIRA] Commented: (JBPORTAL-1999) Adding properties through the admin portlet on Oracle fails

[Mike Millson (JIRA)]

    [ http://jira.jboss.com/jira/browse/JBPORTAL-1999?page=comments#action_12409896 ] 
            
Mike Millson commented on JBPORTAL-1999:
----------------------------------------

The properties are stored in the database, so a work-around would be to data fix the jbp_portal_object_props table and restart portal. For example (assuming the a schema named 'portal'):

update portal.jbp_portal_object_props set jbp_value='undefined' where jbp_value is null;

Then the properties will appear in the Admin portal and can be updated. However, if the user changes the value to the empty string, they will disappear and would have to be datafixed again.

> Adding properties through the admin portlet on Oracle fails
> -----------------------------------------------------------
>
>                 Key: JBPORTAL-1999
>                 URL: http://jira.jboss.com/jira/browse/JBPORTAL-1999
>             Project: JBoss Portal
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: Portal Core
>    Affects Versions: 2.6.4 Final
>            Reporter: Thomas Heute
>         Assigned To: Thomas Heute
>             Fix For: 2.7 Final, 2.6.5 Final
>
>
> When assigning a property on a portal object through the admin portlet using an Oracle database, it fails.
> This is due to the fact that Oracle considers "" (empty String) as NULL... (Stupid)
> The following scenario happens:
> - Store the property value "" on portal object A
> - Get the property of portal Object A --> NULL

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