I have been poking around trying to find out whether
DatabaseSelectAction can help me.
There is very little written about this action and I wonder whether it
has ever been used (or even tested).
My problem is as follows:
I have a column in a table in a database that I am able to access from
XSP and Java with no problems. In the interest of elegance I would like
to make the item available to an XSLT Transformation as a parameter.
All I want to do is supply the key column 'name', get the corresponding
row and then use the value of the field 'company' later in my pipeline
as: {company}.
Sitemap.xmap contains:
<map:actions>
<map:action name="select-user" logger="databaseselectaction"
src="org.apache.cocoon.acting.DatabaseSelectAction"/>
</map:actions>
And the matching pipeline entry is:
<map:match pattern="process">
<!-- first validate whether user has logged in -->
<map:act type="session-validator">
<map:parameter name="descriptor"
value="context://alpha/descriptors/params.xml"/>
<map:parameter name="validate" value="username"/>
<!-- generate protected content -->
<map:act type="form-validator">
<map:parameter name="descriptor"
value="context://alpha/descriptors/getfiles_form.xml"/>
<map:parameter name="validate" value="filename"/>
<!-- form-validation success -->
<map:act type="select-user">
<map:parameter name="descriptor"
value="context://alpha/descriptors/getuser.xml"/>
<map:generate type="serverpages" src="docs/process.xsp"/>
<map:transform src="stylesheets/dynamic-page2html.xsl">
</map:transform>
<map:serialize/>
</map:act>
</map:act>
<!-- form-validation failure -->
<map:redirect-to uri="pickdoc"/>
</map:act>
<!-- session-validation failed ==> redirect to login-page -->
<map:redirect-to session="true" uri="login"/>
</map:match>
The value "username" is captured by a form earlier in the session and
exists as a session attribute.
<root>
<parameter name="username" type="string" nullable="no"/>
<!--parameter name="company" type="string"/-->
<connection>phoenix</connection>
<table name="users">
<keys>
<key param="username" dbcol="name" type="string" mode="form"/>
</keys>
<values>
<value param="company" dbcol="company" type="string"/>
</values>
</table>
</root>
I include the username in the URL as I don't know how else to supply it
to the Action.
I have read the databaseSelectAction code and understand how the SELECT
statement is generated.
I have recompiled cocoon.jar with additional getLogger().debug(
"yadayadayada." ) statements but these never generate output. Anyone
care to tell me why ?
I have had some success with cocoon but I am finding it difficult to
get through to some advanced features because of the sparse
documentation.
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faqs.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
