Hi,
I am using cocoon2 and tomcat 4.
The problem is to do with pipelines caching dynamic input.
For example, I have a pipeline which uses an XML file as it's source. This
file contains some tags which are SQL queries to be processed by the SQL
transformer. This works OK as a single pipeline. When I update the db
contents it is reflected in the web page on the next request.
I cannot use esql because the results of the queries are themselves queries
( I query the DB to find out what queries are needed for the requested
page); as esql can only be used in a generate step it can presumably only be
used once per request.
The output from the pipeline is an XSP page. I use this as the input to
another pipeline where I will use XSP request info etc. However, a class is
created in the work directory which hardcodes the results of the DB queries
in the first pipeline. In other words, I have to restart Tomcat and delete
the work directory every time the db is updated! This is not possible
because the intention is to allow the user to effectively personalise the db
contents from a web page.
The sitemap entries:
<map:pipeline>
<map:match pattern="getPageDef/*">
<map:generate type="file" src="pagedef.xml"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="mydb"/>
<map:parameter name="pageId" value="{1}"/>
</map:transform>
<map:serialize type="xml"/>
</map:match>
<map:match pattern="generatePage/*">
<map:generate type="serverpages"
src="cocoon://pages/getPageDef/{1}"/>
<map:serialize type="html"/>
</map:match>
</map:pipeline>
I have seen other similar questions asked but cannot remember seeing a
definitive solution or workaround. The online docs suggest the
ProgramGenerator is doing the caching. Does this mean I have to write a new
ProgramGenerator which doesn't cache? Will this effect other operations and
make cocoon intolerably slow?
If there is no solution to this problem then we may have to drop the use of
cocoon as we keep running into this particular caching issue. Does anyone
else use a different approach to solve the same kind of problem?
Thanks for your help,
Grant
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
---------------------------------------------------------------------
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]>
