That is a bummer. I was looking to see if I could manipulate those programmatically. Is there a chance this will change?
Thanks, Joris. -----Original Message----- From: David Sean Taylor [mailto:[EMAIL PROTECTED] Sent: Friday, April 20, 2007 3:25 AM To: Jetspeed Users List Subject: Re: Preferences question On Apr 19, 2007, at 4:55 PM, Melchior, Joris wrote: > 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? > Sorry, I was in a hurry when responding Seems that you are asking about PSML preferences, not user preferences PSML preferences are stored just there, in the PSML file (or PSML database) and no where else User preferences are stored in the database > 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] > > -- David Sean Taylor Bluesunrise Software [EMAIL PROTECTED] [office] +01 707 773-4646 [mobile] +01 707 529 9194 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
