RE: Preferences question

[Melchior, Joris]

I've looked in the database and could not find the node that represents
the fragment. Are you sure it is stored there? I tried searching on the
fragment id and on the name but neither node_name nor full_path have any
traces of this instance.

Any suggestions?

Thanks, Joris. 

-----Original Message-----
From: David Sean Taylor [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, April 18, 2007 9:25 PM
To: Jetspeed Users List
Subject: Re: Preferences question


On Apr 16, 2007, at 9:43 PM, Melchior, Joris wrote:

> Given the following snippet:
>
> <fragment id="experiment-562" type="portlet"  
> name="DCLPortlet::DCLTest">
>       <preference name="context" readOnly="false">
>               <value>defaultCommon</value>
>       </preference>
>       <preference name="subContext" readOnly="false">
>               <value>header</value>
>       </preference>
> </fragment>
>
> Does Jetspeed store the preference information in its database? If so,
> where does that information go?
>

Yes, it goes in two tables (XML DDL defs):

<database name="j2">

     <!--
        prefs_property_value
     -->
     <table name="PREFS_PROPERTY_VALUE">
         <column name="PROPERTY_VALUE_ID" primaryKey="true"  
required="true" type="INTEGER"/>
         <column name="NODE_ID" type="INTEGER"/>
         <column name="PROPERTY_NAME" size="100" type="VARCHAR"/>
         <column name="PROPERTY_VALUE" size="254" type="VARCHAR"/>
         <column name="CREATION_DATE" type="TIMESTAMP"/>
         <column name="MODIFIED_DATE" type="TIMESTAMP"/>
         <!-- Still an issue with OJB 1.0.3 when deleting M-N.  
Foreign Key Violation.
         <foreign-key foreignTable="PREFS_NODE">
             <reference foreign="NODE_ID" local="NODE_ID"/>
         </foreign-key>
         -->
     </table>

     <!--
        pref_node
     -->
     <table name="PREFS_NODE">
         <column name="NODE_ID" primaryKey="true" required="true"  
type="INTEGER"/>
         <column name="PARENT_NODE_ID" type="INTEGER"/>
         <column name="NODE_NAME" size="100" type="VARCHAR"/>
         <column name="NODE_TYPE" type="SMALLINT"/>
         <column name="FULL_PATH" size="254" type="VARCHAR"/>
         <column name="CREATION_DATE" type="TIMESTAMP"/>
         <column name="MODIFIED_DATE" type="TIMESTAMP"/>
         <foreign-key foreignTable="PREFS_NODE" name="FK_PREFS_NODE_1">
             <reference foreign="NODE_ID" local="PARENT_NODE_ID"/>
         </foreign-key>
     </table>

</database>



Some Documentation here:

http://portals.apache.org/jetspeed-2/multiproject/jetspeed-prefs/ 
jetspeed-prefs.pdf





---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]