You are viewing a plain text version of this content. The canonical link for it is here.
Posted to jetspeed-dev@portals.apache.org by "Vitaly Baranovsky (JIRA)" <je...@portals.apache.org> on 2008/06/05 17:17:45 UTC

[jira] Created: (JS2-887) Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.

Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.
------------------------------------------------------------------------------------------------------

                 Key: JS2-887
                 URL: https://issues.apache.org/jira/browse/JS2-887
             Project: Jetspeed 2
          Issue Type: Bug
          Components: Portlet Entities and Preferences
    Affects Versions: 2.1.3
            Reporter: Vitaly Baranovsky


Why Jetspeed adds records in database when storing preferences in edit_defaults mode?

For example, I've changed preference 'entities' in portlet entity with id 'P-111c7f0db23-10032' through edit_defaults custom portlet mode. Yes, psml page was changed. But 3 records was inserted to PREFS_NODE and 2 records was inserted to PREFS_PROPERTY_VALUE:
to PREFS_NODE:
NODE_ID     PARENT_NODE_ID NODE_NAME                                                                                            NODE_TYPE FULL_PATH                                                                                                                                                                                                                                                      CREATION_DATE           MODIFIED_DATE
----------- -------------- ---------------------------------------------------------------------------------------------------- --------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
299112      299090         entities                                                                                             1         /portlet_entity/P-111c7f0db23-10032/preferences/entities                                                                                                                                                                                                       2008-06-05 13:40:02.830 2008-06-05 13:40:02.830
299114      299112         size                                                                                                 1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/size                                                                                                                                                                                                  2008-06-05 13:40:02.837 2008-06-05 13:40:02.837
299113      299112         values                                                                                               1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/values                                                                                                                                                                                                2008-06-05 13:40:02.833 2008-06-05 13:40:02.833

to PREFS_PROPERTY_VALUE (2 entries except one!!!):
PROPERTY_VALUE_ID NODE_ID     PROPERTY_NAME                                                                                        PROPERTY_VALUE                                                                                                                                                                                                                                                   CREATION_DATE           MODIFIED_DATE
----------------- ----------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
365458            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:02.847 2008-06-05 13:40:02.847
365574            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:23.737 2008-06-05 13:40:23.737

As you can see, both records added to PREFS_PROPERTY_VALUE are the same... It's error!
Why Jetspeed adds this entries to database? 
When rendering pages Jetspeed uses preferences from psml, and ignores this database stored preferences.

Is it error?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Resolved: (JS2-887) Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.

Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
     [ https://issues.apache.org/jira/browse/JS2-887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ate Douma resolved JS2-887.
---------------------------

    Resolution: Fixed

I've tested this and can confirm this bug and committed a fix to resolve it to both the 2.1.3-postrelease and 2.1.4 branch.
Fix completely prohibits the creation of default entity preferences in the preferences tables, only the fragment preferences are modified now.


> Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.
> ------------------------------------------------------------------------------------------------------
>
>                 Key: JS2-887
>                 URL: https://issues.apache.org/jira/browse/JS2-887
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Portlet Entities and Preferences
>    Affects Versions: 2.1.3
>            Reporter: Vitaly Baranovsky
>            Assignee: Ate Douma
>             Fix For: 2.1.4
>
>
> Why Jetspeed adds records in database when storing preferences in edit_defaults mode?
> For example, I've changed preference 'entities' in portlet entity with id 'P-111c7f0db23-10032' through edit_defaults custom portlet mode. Yes, psml page was changed. But 3 records was inserted to PREFS_NODE and 2 records was inserted to PREFS_PROPERTY_VALUE:
> to PREFS_NODE:
> NODE_ID     PARENT_NODE_ID NODE_NAME                                                                                            NODE_TYPE FULL_PATH                                                                                                                                                                                                                                                      CREATION_DATE           MODIFIED_DATE
> ----------- -------------- ---------------------------------------------------------------------------------------------------- --------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
> 299112      299090         entities                                                                                             1         /portlet_entity/P-111c7f0db23-10032/preferences/entities                                                                                                                                                                                                       2008-06-05 13:40:02.830 2008-06-05 13:40:02.830
> 299114      299112         size                                                                                                 1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/size                                                                                                                                                                                                  2008-06-05 13:40:02.837 2008-06-05 13:40:02.837
> 299113      299112         values                                                                                               1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/values                                                                                                                                                                                                2008-06-05 13:40:02.833 2008-06-05 13:40:02.833
> to PREFS_PROPERTY_VALUE (2 entries except one!!!):
> PROPERTY_VALUE_ID NODE_ID     PROPERTY_NAME                                                                                        PROPERTY_VALUE                                                                                                                                                                                                                                                   CREATION_DATE           MODIFIED_DATE
> ----------------- ----------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
> 365458            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:02.847 2008-06-05 13:40:02.847
> 365574            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:23.737 2008-06-05 13:40:23.737
> As you can see, both records added to PREFS_PROPERTY_VALUE are the same... It's error!
> Why Jetspeed adds this entries to database? 
> When rendering pages Jetspeed uses preferences from psml, and ignores this database stored preferences.
> Is it error?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Assigned: (JS2-887) Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.

Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
     [ https://issues.apache.org/jira/browse/JS2-887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ate Douma reassigned JS2-887:
-----------------------------

    Assignee: Ate Douma

> Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.
> ------------------------------------------------------------------------------------------------------
>
>                 Key: JS2-887
>                 URL: https://issues.apache.org/jira/browse/JS2-887
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Portlet Entities and Preferences
>    Affects Versions: 2.1.3
>            Reporter: Vitaly Baranovsky
>            Assignee: Ate Douma
>             Fix For: 2.1.4
>
>
> Why Jetspeed adds records in database when storing preferences in edit_defaults mode?
> For example, I've changed preference 'entities' in portlet entity with id 'P-111c7f0db23-10032' through edit_defaults custom portlet mode. Yes, psml page was changed. But 3 records was inserted to PREFS_NODE and 2 records was inserted to PREFS_PROPERTY_VALUE:
> to PREFS_NODE:
> NODE_ID     PARENT_NODE_ID NODE_NAME                                                                                            NODE_TYPE FULL_PATH                                                                                                                                                                                                                                                      CREATION_DATE           MODIFIED_DATE
> ----------- -------------- ---------------------------------------------------------------------------------------------------- --------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
> 299112      299090         entities                                                                                             1         /portlet_entity/P-111c7f0db23-10032/preferences/entities                                                                                                                                                                                                       2008-06-05 13:40:02.830 2008-06-05 13:40:02.830
> 299114      299112         size                                                                                                 1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/size                                                                                                                                                                                                  2008-06-05 13:40:02.837 2008-06-05 13:40:02.837
> 299113      299112         values                                                                                               1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/values                                                                                                                                                                                                2008-06-05 13:40:02.833 2008-06-05 13:40:02.833
> to PREFS_PROPERTY_VALUE (2 entries except one!!!):
> PROPERTY_VALUE_ID NODE_ID     PROPERTY_NAME                                                                                        PROPERTY_VALUE                                                                                                                                                                                                                                                   CREATION_DATE           MODIFIED_DATE
> ----------------- ----------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
> 365458            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:02.847 2008-06-05 13:40:02.847
> 365574            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:23.737 2008-06-05 13:40:23.737
> As you can see, both records added to PREFS_PROPERTY_VALUE are the same... It's error!
> Why Jetspeed adds this entries to database? 
> When rendering pages Jetspeed uses preferences from psml, and ignores this database stored preferences.
> Is it error?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org


[jira] Updated: (JS2-887) Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.

Posted by "Ate Douma (JIRA)" <je...@portals.apache.org>.
     [ https://issues.apache.org/jira/browse/JS2-887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ate Douma updated JS2-887:
--------------------------

    Fix Version/s: 2.1.4

I don't know if this issue is real and/or still valid for the 2.1.4 branch. If so, it should be fixed before the 2.1.4 release otherwise this issue can be closed.

> Jetspeed writes information to database when storing preferences in edit_defaults custom portlet mode.
> ------------------------------------------------------------------------------------------------------
>
>                 Key: JS2-887
>                 URL: https://issues.apache.org/jira/browse/JS2-887
>             Project: Jetspeed 2
>          Issue Type: Bug
>          Components: Portlet Entities and Preferences
>    Affects Versions: 2.1.3
>            Reporter: Vitaly Baranovsky
>             Fix For: 2.1.4
>
>
> Why Jetspeed adds records in database when storing preferences in edit_defaults mode?
> For example, I've changed preference 'entities' in portlet entity with id 'P-111c7f0db23-10032' through edit_defaults custom portlet mode. Yes, psml page was changed. But 3 records was inserted to PREFS_NODE and 2 records was inserted to PREFS_PROPERTY_VALUE:
> to PREFS_NODE:
> NODE_ID     PARENT_NODE_ID NODE_NAME                                                                                            NODE_TYPE FULL_PATH                                                                                                                                                                                                                                                      CREATION_DATE           MODIFIED_DATE
> ----------- -------------- ---------------------------------------------------------------------------------------------------- --------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
> 299112      299090         entities                                                                                             1         /portlet_entity/P-111c7f0db23-10032/preferences/entities                                                                                                                                                                                                       2008-06-05 13:40:02.830 2008-06-05 13:40:02.830
> 299114      299112         size                                                                                                 1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/size                                                                                                                                                                                                  2008-06-05 13:40:02.837 2008-06-05 13:40:02.837
> 299113      299112         values                                                                                               1         /portlet_entity/P-111c7f0db23-10032/preferences/entities/values                                                                                                                                                                                                2008-06-05 13:40:02.833 2008-06-05 13:40:02.833
> to PREFS_PROPERTY_VALUE (2 entries except one!!!):
> PROPERTY_VALUE_ID NODE_ID     PROPERTY_NAME                                                                                        PROPERTY_VALUE                                                                                                                                                                                                                                                   CREATION_DATE           MODIFIED_DATE
> ----------------- ----------- ---------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------------------- -----------------------
> 365458            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:02.847 2008-06-05 13:40:02.847
> 365574            299113      0                                                                                                    ;news;news_comment;                                                                                                                                                                                                                                              2008-06-05 13:40:23.737 2008-06-05 13:40:23.737
> As you can see, both records added to PREFS_PROPERTY_VALUE are the same... It's error!
> Why Jetspeed adds this entries to database? 
> When rendering pages Jetspeed uses preferences from psml, and ignores this database stored preferences.
> Is it error?

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


---------------------------------------------------------------------
To unsubscribe, e-mail: jetspeed-dev-unsubscribe@portals.apache.org
For additional commands, e-mail: jetspeed-dev-help@portals.apache.org