Two ESQL Questions
I have a couple of ESQL questions: 1) If an ESQL query throws a database exception, is there any way to log the stack trace to a file? 2) If an ESQL query throws a database exception, is there any way to handle this using the map:handle-errors section of the sitemap, so that all exceptions thrown, whether during pipeline processing or application exceptions, are displayed in the same manner? Regards Michael -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Displaying 'progress' screen for long running reports
Hi I have a Cocoon application that provides a front-end to a reporting system, and some of the reports take quite a while to run - in the order of 5-10 minutes. I need to provide a feature whereby the user submits the report request and a screen appears that polls the report every 10 seconds or so to determine if the reporting file has been created. When it has, it will be displayed, otherwise the screen will keep displaying a helpful message to the user. Any ideas on how to do this using Cocoon? The workflow is something like this: 1) User clicks 'Run Report' 2) Request is submitted to reporting system and a helpful 'progress' screen is returned to the user 3) The progress screen checks for the report by submitting a URL. If a 404 is returned, continue to display the 'progress' screen, otherwise display the report. Regards Michael -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: cocoon-users Digest 25 Oct 2002 14:33:49 -0000 Issue 1662
Why would it be a bad design, Chris? My understanding of ESQL is that it exists specifically for the purpose of extracting data from a database and formatting it as XML. What benefit is there to having a SELECT in an action, besides having people such as yourself consider it a good design. Regards Michael - Message from Christian Haul [EMAIL PROTECTED] on Fri, 25 Oct 2002 13:13:56 +0200 - To: [EMAIL PROTECTED] Subject: Re: Throwing an Exception within ESQL On 25.Oct.2002 -- 10:42 AM, Michael Edge wrote: Hi In the XSP snippet below I'd like to throw an exception from within esql:no-results. My questions are: how do I do this and will the exception be caught by the map:handle-errors section of the sitemap? If you really want, you could throw an exception as you like. I think it should be a processing exception. However, you should really consider to do the select in an action, for example the existing database or modular database actions. I would cosider your request as extremely bad design. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Cocoon Connection Pooling and Database Shutdown
Could anyone shed some light on what happens to the Cocoon connection pool when the database it depends on is shutdown and then restarted. I expect an exception to be thrown as the connections are invalid, and though I don't explicitly catch it using esql:error-results in my XSP page, I expect that this exception should appear somewhere; perhaps in a log file or returned as part of the XML generated by the XSP. However, if my database has been shutdown and then restarted, the XSP below returns tradingbookSorry, no trading book results!/tradingbook. I have to restart Tomcat to get it working again. tradingbook esql:connection esql:poolmosaic/esql:pool esql:execute-query esql:querySELECT distinct vm_tradingbook_id as tradingbook_code, tradingbookname FROM V_TRADINGBOOK_VM order by 2/esql:query esql:results esql:row-results tradingbookcodeesql:get-string column=tradingbook_code//tradingbookcode tradingbookesql:get-string column=tradingbookname//tradingbook /esql:row-results /esql:results esql:no-results tradingbookSorry, no trading book results!/tradingbook /esql:no-results /esql:execute-query /esql:connection /tradingbook Regards Michael --- Michael Edge Global Markets Technology Institutional Client Group Phone: +44 (0) 20 7545 3204 Fax : +44 (0) 20 7545 1559 Internet email:[EMAIL PROTECTED] -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Cocoon Connection Pooling and Database Shutdown
Why should I use carriage returns in my messages, Berin? Michael - Message from Berin Loritsch [EMAIL PROTECTED] on Wed, 16 Oct 2002 09:01:01 -0400 - To: [EMAIL PROTECTED] Subject: Re: Cocoon Connection Pooling and Database Shutdown ot please use carriage returns in your messages /ot -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: XSP Redirect in Cocoon 2
Thanks Vadim, it's now 100%. Michael To: [EMAIL PROTECTED] Subject: Re: XSP Redirect in Cocoon 2 Michael Edge wrote: Thanks Litrik, I have written my action and it works 95%. I have one small, simple problem. My sitemap entry is below, and below that is an abbreviated version of my XSP. The XSP constructs a URL dynamically and needs to pass this back to the XSP. How do I do this? It works fine if the xsp-action:set-result name=report-url value={url}/ has a hardcoded URL in the value attribute, but I need to pass in a variable. If I can get this to work, it will be 100% xsp-action:set-result name=report-url xsp-action:param name=valuexsp:logicconstruct + url/xsp:logic/xsp-action:param /xsp-action:set-result Vadim -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
XSP Redirect in Cocoon 2
Hi All It seems to me that the following code will not work in Cocoon 2. I believe it works in Cocoon 1, but for some reason the request and response objects available within XSP for Cocoon 2 are not HttpServletRequest and HttpServletResponse objects, but rather some cocoon equivalents, org.apache.cocoon.environment.Response and org.apache.cocoon.environment.Request. Unfortunately these new classes do not include the sendRedirect method. Any ideas how I would do this? I need to construct a URL in my code and redirect to that URL. xsp:logic String url = URLEncoder.encode(url + whatever + parameters); response.sendRedirect(url); /xsp:logic Thanks Michael -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: cocoon-users Digest 5 Sep 2002 15:13:14 -0000 Issue 1567
Thanks for the suggestion Nicola. Could you point me in the direction of an example on how to do this? I've spent hours searching for information on redirects, and as with most Cocoon documentation, it's pretty vague. Thanks Michael Michael Edge wrote: Hi All It seems to me that the following code will not work in Cocoon 2. I believe it works in Cocoon 1, but for some reason the request and response objects available within XSP for Cocoon 2 are not HttpServletRequest and HttpServletResponse objects, but rather some cocoon equivalents, org.apache.cocoon.environment.Response and org.apache.cocoon.environment.Request. Unfortunately these new classes do not include the sendRedirect method. Any ideas how I would do this? I need to construct a URL in my code and redirect to that URL. xsp:logic String url = URLEncoder.encode(url + whatever + parameters); response.sendRedirect(url); /xsp:logic Thanks Don't use XSPs for flow control, use the sitemap. Add an Action that does this and redirect. You can write Actions using XSPs BTW. Better still, use the action to return the url and then do a redirect in the sitemap; it makes your action more reusable. -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) - Content-Transfer-Encoding: 7bit Message-ID: [EMAIL PROTECTED] Date: Thu, 05 Sep 2002 15:29:27 +0200 From: Nicola Ken Barozzi [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] MIME-Version: 1.0 To: [EMAIL PROTECTED] Subject: Re: XSP Redirect in Cocoon 2 Content-Type: text/plain; charset=us-ascii; format=flowed http://outerthought.net/wiki/Wiki.jsp?page=Redirecting -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) - Content-Transfer-Encoding: 7bit Message-ID: 01d201c254e1$3aff7470$0100a8c0@MAUCHI From: Ivelin Ivanov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: XMLForm - Howto - Mailing List - Not working Date: Thu, 5 Sep 2002 08:36:24 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Can you reach these links: http://localhost:8080/cocoon/samples/welcome http://localhost:8080/cocoon/samples/xmlform/wizard - Original Message - From: Gerry Reno [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 5:46 PM Subject: XMLForm - Howto - Mailing List - Not working I installed Cocoon 2.1 successfully (at least I can browse to http://localhost:8080/cocoon) and I am trying to get the Howto Mailing List example working. I've double checked all of my steps but I can't get it to work. I'm using Tomcat 4.1.9 and Cocoon 2.1 (09/02). I put all the .xml (start, registration, interest, organicGardening, cooking, smallholdingManagement, confirm, end) files in: %COCOON_HOME%\src\webapp\samples\xmlform\howto I put the howto-xmlform-sch-report.xml file in: %COCOON_HOME%\src\scratchpad\webapp\samples\xmlform\howto\schematron I put the HowToBean.java and HowtoWizardAction.java files in: %COCOON_HOME%\src\java\org\apache\cocoon\samples\xmlform\howto I added the sitemap entries to the sitemap in: %COCOON_HOME%\src\webapp\samples\xmlform I open a Command Prompt window and type: cd %COCOON_HOME% build webapp -Dinclude.webapp.libs=true webapp (lots of building goes on) Build Successful I copy the cocoon.war to the Tomcat webapps dir. I recycle Tomcat - cocoon.war is expanded. I browse to http://localhost:8080/cocoon/samples/xmlform/howto-wizard.html I receive this error: Cocoon 2 - Resource not found -- -- type resource-not-found message Resource not found description The requested URI /cocoon/samples/xmlform/howto-wizard.html was not found. sender org.apache.cocoon.servlet.CocoonServlet source Cocoon servlet request-uri /cocoon/samples/xmlform/howto-wizard.html path-info samples/xmlform/howto-wizard.html -- --- Any ideas on what may be wrong here. I cannot find a howto-wizard.html file anywhere. __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message-ID: 009c01c254e3$0315b9a0$a73ca8c0@john From: Ganael LAPLANCHE [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject
Re: XSP Redirect in Cocoon 2
Thanks for the suggestion Nicola. Could you point me in the direction of an example on how to do this? I've spent hours searching for information on redirects, and as with most Cocoon documentation, it's pretty vague. Thanks Michael Michael Edge wrote: Hi All It seems to me that the following code will not work in Cocoon 2. I believe it works in Cocoon 1, but for some reason the request and response objects available within XSP for Cocoon 2 are not HttpServletRequest and HttpServletResponse objects, but rather some cocoon equivalents, org.apache.cocoon.environment.Response and org.apache.cocoon.environment.Request. Unfortunately these new classes do not include the sendRedirect method. Any ideas how I would do this? I need to construct a URL in my code and redirect to that URL. xsp:logic String url = URLEncoder.encode(url + whatever + parameters); response.sendRedirect(url); /xsp:logic Thanks Don't use XSPs for flow control, use the sitemap. Add an Action that does this and redirect. You can write Actions using XSPs BTW. Better still, use the action to return the url and then do a redirect in the sitemap; it makes your action more reusable. -- Nicola Ken Barozzi [EMAIL PROTECTED] - verba volant, scripta manent - (discussions get forgotten, just code remains) - -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Sorry for attaching entire digest
My humbles apologies for replying to a message and attaching the entire cocoon users digest to it. I know it's irritating. Sorry about that, an accident caused by me not checking that Lotus Notes had correctly deleted the rest of the digest. Regards Michael -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
XSP Best Practise Question
Hi All I have a question regarding the use and purpose of XSP. I believe that XSP is an attempt to separate content/logic from presentation, and I believe it's possible to use it in this way. However, in many of the samples (such as results-dept.xsp below, found in the tutorial) XSP is used to retrieve XML from a database and wrap it in some sort of pseudo-html, which is then processed by a logicsheet to produce proper HTML. To me this defeats the whole purpose of XSP. The XSP below mixes content and presentation, and if it contained xsp:logic sections it would be even worse, mixing content, logic and presentation. My thoughts are that, as the XSP is a generator it should generate XML in some suitable form. If logic is needed within the XSP dynamic tags can be used and translated using a logicsheet (or made part of XSP if they are not resuable). However, the actual presentation of this XML should be left to a stylesheet. I would really appreciate your comments and thoughts on this as we are trying to implement multiple projects here using Cocoon and want to use a consistent, best-practise approach. Thanks for your time :-) Michael xsp:page xmlns:xsp=http://apache.org/xsp; xmlns:xsp-request=http://apache.org/xsp/request/2.0; xmlns:esql=http://apache.org/cocoon/SQL/v2; document header titleSearch Results/title /header body s1 title=Department Search Results p You can edit a department by clicking on the edit button, and you can delete a department by clicking on the delete button. /p esql:connection esql:poolpersonnel/esql:pool esql:execute-query esql:query SELECT id, name FROM department WHERE name LIKE esql:parameter%xsp-request:get-parameter name=name/%/esql:parameter ORDER BY name /esql:query esql:results esql:row-results s2 xsp:attribute name=titleesql:get-string column=name//xsp:attribute form handler=edit-dept.html xsp:attribute name=nameesql:get-string column=id//xsp:attribute p parameter name=id xsp:attribute name=valueesql:get-string column=id//xsp:attribute /parameter submit name=Edit Department/submit name=Delete Department/ /p /form /s2 /esql:row-results /esql:results esql:no-results p We could find any departments that matched your search criteria of xsp-request:get-parameter name=name/. link href=search-dept.htmlGo back and try again?/link /p /esql:no-results /esql:execute-query /esql:connection /s1 /body /document /xsp:page --- Michael Edge Global Markets Technology Institutional Client Group Phone: +44 (0) 20 7545 3204 Fax : +44 (0) 20 7545 1559 Internet email:[EMAIL PROTECTED] -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Merging Dynamic Content and Static HTML in Same Page
Hi All Is it possible within Cocoon to produce a single page that is made up of both static and dynamic content. For example, I would like to produce reports that all contain a standard header with images and toolbars, etc., but where the dynamic part of the page is generated by an XSP using ESQL. Within Cocoon I can see ways of generating static pages using either map:read or map:generate, as in: map:match pattern=head.html map:read src=docs/head.htm mime-type=text/html/ /map:match map:match pattern=head map:generate type=html src=docs/head.htm/ map:serialize/ /map:match And there are ways of generating dynamic pages using XSP, as in: map:match pattern=reports map:generate type=serverpages src=docs/PCTeamProduct.xsp/ map:transform src=stylesheets/PCTeamProduct.xsl/ map:serialize/ /map:match Now how can I put these both together so that I get a single HTML page with head.htm at the top followed by the output of PCTeamProduct.xsp? Thanks for the help Regards Michael -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Merging Dynamic Content and Static HTML in Same Page
Thanks again for the help. It now works. My sitemap entry is as follows, and I get a proper header and footer surrounding my report. Thanks to you Stefan for your Apache suggestion. I'll keep that in mind. Regards Michael map:match pattern=header map:generate type=html src=docs/MosaicHeader.htm/ map:serialize/ /map:match map:match pattern=footer map:generate type=html src=docs/MosaicFooter.htm/ map:serialize/ /map:match map:match pattern=reports map:generate type=serverpages src=docs/PCTeamProduct.xsp/ map:transform src=stylesheets/PCTeamProduct.xsl/ map:serialize/ /map:match map:match pattern=aggreg map:aggregate element=one map:part src=cocoon:/header/ map:part src=cocoon:/reports/ map:part src=cocoon:/footer/ /map:aggregate map:serialize/ /map:match Michael, you can just aggregate without trasnforming (though you MUST serialize after aggregating). Moreover, you can aggregate the results of other pipelines, like in: map:aggregate element=page map:part src=cocoon:/all-parameters.xml/ map:part src=cocoon:/form-emptylog.xml element=form-emptylog/ /map:aggregate Best regards, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html - -Original Message- From: Michael Edge [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 20, 2002 4:30 PM To: [EMAIL PROTECTED] Subject: Re: Merging Dynamic Content and Static HTML in Same Page Thanks for the help Vadim and Luca. My understanding is that aggregation creates a single XML fragment from many sources, concatenating them all together. Then it applies the transformation and serialization. However, my documents are not XML but HTML. Using aggregation and include it seems as though these documents will be converted to XML, merged into one large XML fragment before being transformed via my stylesheet. I don't want or need the stylesheet to process the HTML at all. I sort of need the aggregation to happen after the transformation rather than before. Any suggestions? Or are there other ways to accomplish this? Surely this must be quite a common requirement? Thanks for your time Michael Michael Edge wrote: Hi All Is it possible within Cocoon to produce a single page that is made up of both static and dynamic content. For example, I would like to produce reports that all contain a standard header with images and toolbars, etc., but where the dynamic part of the page is generated by an XSP using ESQL. Within Cocoon I can see ways of generating static pages using either map:read or map:generate, as in: map:match pattern=head.html map:read src=docs/head.htm mime-type=text/html/ /map:match map:match pattern=head map:generate type=html src=docs/head.htm/ map:serialize/ /map:match And there are ways of generating dynamic pages using XSP, as in: map:match pattern=reports map:generate type=serverpages src=docs/PCTeamProduct.xsp/ map:transform src=stylesheets/PCTeamProduct.xsl/ map:serialize/ /map:match Now how can I put these both together so that I get a single HTML page with head.htm at the top followed by the output of PCTeamProduct.xsp? 1. Sitemap aggregation. See samples. 2. Includes. See samples. Vadim Thanks for the help Regards Michael - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faq/index.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED