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
