Re: Does anyone remember cocoon 1.8?
I haven't installed 1.8 in a while - and from my memory - this looks like the kind of error I got when I didn't follow the installation instructions carefully ( i.e. jars not in the right directory, or not loaded in the appropriate sequence, ) Have you searched the archives? marty - Original Message - From: Paul Gilligan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 24, 2002 11:02 AM Subject: Does anyone remember cocoon 1.8? I have switched to an out of the box cocoon 1,8 that coomes with SuSE 8.0 and I get: java.lang.RuntimeException: Error loading logicsheet at resource://org/apache/cocoon/processor/xsp/library/java/util.xsl due to java.lang.Exception: Resource not found or retrieving error. Now I am sure that this is a std problem and someone can tell me how to sort this out without me having to dig too deep :) What I am working on is using the new Oracle 9.2 XML repository and a standard cocoon production version (1.8) and the JDK 1.3 that comes with it -hence I do not want to have todo too much work on the cocoon side. Then I will be adapting the docbook DTD to work with Oracle and then use cocoon to publish. Now here is the crunch!! I can easily do a little programming to with Oracle to make a content management frame work :) Has any one else looked at Oracle 9.2 XML? Paul - 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] - 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: Help Requested!!!!
I have seen this error when there is an error in the table name. Check the spelling of the table name in the database and make sure it matches the name in the query including upper/lower case. marty -Original Message- From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 17, 2002 12:14 PM To: [EMAIL PROTECTED] Subject: Help Requested Dear All, I am trying a simple process to execute the sql query that should give me the output in xml, but It seems to me that I am stuckup with this. Below is the detailed description of what I have done:- I have created a file named sql-test.xml under test folder within tomcat/cocoon that just consist of a single query:- ?xml version=1.0? test xmlns:sql=http://apache.org/cocoon/SQL/2.0; titleHello/title content paraThis is SQL Test/para sql:execute-query query select * from employee /query /sql:execute-query /content /test I have updated the entries for driver and db within the web.xml and cocoon.xconf file to use with MS Access database. Having done that, I have inserted the following lines within the main sitemap:- map:pipeline map:match pattern=test/* map:generate src=test/sql-test.xml/ map:transform type=sql map:parameter name=use-connection value=mydb/ /map:transform map:serialize type=xml/ /map:match /map:pipeline I am getting the following errors:- System can't find the specified resource java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]Invalid use of null pointer I will be grateful for your kind help Regards Irfan. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - 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] - 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]
Re: Esql row-results
from the mysql manual - The LIMIT clause can be used to constrain the number of rows returned by the SELECT statement. LIMIT takes one or two numeric arguments. The arguments must be integer constants. If two arguments are given, the first specifies the offset of the first row to return, the second specifies the maximum number of rows to return. The offset of the initial row is 0 (not 1): mysql select * from table LIMIT 5,10; # Retrieve rows 6-15 If one argument is given, it indicates the maximum number of rows to return: mysql select * from table LIMIT 5; # Retrieve first 5 rows In other words, LIMIT n is equivalent to LIMIT 0,n. marty - Original Message - From: Sharat Koya [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 11, 2002 10:00 PM Subject: Re: Esql row-results unfortunatly not. I am using mysql - Original Message - From: Chris Warr [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, April 12, 2002 3:02 AM Subject: RE: Esql row-results does 'select top 1 ' do what you want. It just returns one row of the query results. Not sure if all dbs support it though. Very handy though. Chris. -Original Message- From: Sharat Koya [mailto:[EMAIL PROTECTED]] Sent: Friday, 12 April 2002 11:54 To: [EMAIL PROTECTED] Subject: Esql row-results Hi, I have searched through the archives over the past hour and haven't found anything for this problem. What I want to do is execute a esql query that returns the results from a table but only selects the first row. eg.. normal esql namespace excluded... queryselect * from action where due lt; current_timestamp/query results row-results actionget-string column=action//action /row-results /results what i want to be able to do is return only one action and ideally the first one it comes across. Once it does i can then set about processing the action and then delete from the database. any ideas? thanks for any time put in Sharat Koya - 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] - 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] - 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] - 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]
Re: Why isn't Cocoon making into the commerical world?
What is its direct competition? Someone in my local java users group recently advocated Struts - another apache project - over cocoon. Anyone have any comments? - 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]
Re: Cocoon 1.8.2
I use C1.8.2 with tomcat 3.2 - i've never been able to get C1.8.2 to work with tomcat 4 - marty - Original Message - From: Matus Krisztián To: [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 10:51 AM Subject: Cocoon 1.8.2 ***Sender : Matus Krisztián [EMAIL PROTECTED] *** Hello,I'm in need of your help. My problem with Cocoon is that I can't breath itto life. I've made a build with version 1.8.2 and put the JARs undertomcat4.0.1/lib.I've copied cocoon-1.8.2/samples to tomcat4.0.1/webapps/samples. After I've copied cocoon.properties to tomcat4.0.1/webapps/samples and made modifications to tomcat4.0.1/webapps/samples/web.xml:servlet servlet-nameorg.apache.cocoon.Cocoon/servlet-name servlet-classorg.apache.cocoon.Cocoon/servlet-class init-param param-nameproperties/param-name param-value/cocoon.properties/param-value /init-param/servletservlet-mapping servlet-nameorg.apache.cocoon.Cocoon/servlet-name url-pattern*.xml/url-pattern/servlet-mappingI'm receiving the following message with URLhttp://localhost.8080/samples/index.xml Publishing Engine could not be initialized. java.lang.RuntimeException: Error loading logicsheet at resource://org/apache/cocoon/processor/xsp/library/java/util.xsl due to java.lang.Exception: Resource not found or retrieving error. at org.apache.cocoon.processor.xsp.XSPProcessor.init(XSPProcessor.java:302) at org.apache.cocoon.framework.Manager.create(Manager.java:109) at org.apache.cocoon.framework.Router.init(Router.java:80) at org.apache.cocoon.framework.Manager.create(Manager.java:109) at org.apache.cocoon.Engine.init(Engine.java:179) at org.apache.cocoon.Engine.getInstance(Engine.java:232) at org.apache.cocoon.Cocoon.init(Cocoon.java:157) at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:852) at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:615) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:201) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2344) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:170) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:462) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:564) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:163) at org.apache.catalina.core.StandardPipeline.invokeNext(StandardPipeline.java:566) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:472) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:943) at org.apache.catalina.connector.http.HttpProcessor.process(HttpProcessor.java:1011) at org.apache.catalina.connector.http.HttpProcessor.run(HttpProcessor.java:1106) at java.lang.Thread.run(Thread.java:484)<[EMAIL PROTECTED]>
RE: Cocoon2: couldn't make nested queries work for ESQL in XSP.
I've done a number of nested queries in C1.8.2 and as far as I know the approach is the same in C2. Here is an example: esql:execute-query !-- for each rid in Collection - get the centity's -- !-- SQL Server query SELECT DISTINCT Contribute.centity_id, Contribute.role FROM Contribute INNER JOIN Collection_resources ON Contribute.rid = Collection_resources.rid WHERE (Collection_resources.Collection_id = 18) -- esql:queryselect Distinct Contribute.Centity_id, Contribute.role FROM Contribute , Collection_resources where Collection_resources.Collection_id=xsp:exprcollectionID/xsp:expr and Collection_resources.rid=Contribute.rid/esql:query esql:error-results !-- error-results occur when there is a sql error -- !-- db connection errors are thrown to xsp -- !-- stacktrace is shown for errors in xsp -- errorSQL error - contact the ilumina administrator/error /esql:error-results esql:results resources esql:row-results resource centityIDesql:get-int column=1//centityID roleesql:get-string column=2//role !-- get the count -- esql:execute-query esql:queryselect count(distinct Contribute.rid) from Contribute, Collection_resources where centity_id=esql:parameter type=intesql:get-int ancestor=1 column=1 //esql:parameter and Contribute.rid=Collection_resources.rid and Collection_resources.Collection_id=xsp:exprcollectionID/xsp:expr /esql:query esql:results esql:row-results countesql:get-int column=1//count /esql:row-results /esql:results /esql:execute-query !-- get the name -- esql:execute-query esql:queryselect first_name, last_name from Centity where centity_id=esql:parameter type=intesql:get-int ancestor=1 column=1 //esql:parameter/esql:query esql:results esql:row-results nameesql:get-string column=2/, esql:get-string column=1//name /esql:row-results /esql:results /esql:execute-query /resource /esql:row-results /resources /esql:results /esql:execute-query marty -Original Message- From: Argyn Kuketayev [mailto:[EMAIL PROTECTED]] Sent: Monday, March 25, 2002 10:34 AM To: '[EMAIL PROTECTED]' Subject: Cocoon2: couldn't make nested queries work for ESQL in XSP. I've to make a report on the table M, then for each row I need to show corresponding rows from tables F and C. Something like this: rowset name=M row ID1/ID rowset name=F row f_namef1/f_name row ... /rowset rowset name=C row c_namec1/c_name row /rowset /row ... /rowset I tried this : esq l:parameter type=intesql:get-int ancestor=1 column=id//esql:parameter It didn't work with an exception: org.apache.cocoon.ProcessingException: Exception in ServerPagesGenerator.generate(): java.lang.RuntimeException: Error executing prepared statement: select ... from f where M_ID = ? : java.sql.SQLException: ORA-01722: invalid number Can somebody give me a WORKING and tested example of nested queries in Cocoon2? thanks, Argyn - 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] - 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]
thanks for sharing your expertise Vadim
Hello Vadim - I just want to express my appreciation for your participation on the Cocoon users list. I have a Cocoon 1.8.2 application that I will migrate to Cocoon 2 in a couple of months. In the meantime, I am reading the list to get a heads up on the issues and solutions with C2 ( there is very little traffic about C1.8 these days ). So I am learning from your responses to others questions. I also want to acknowledge your patience with newbies. After reading the list for some months - I find it interesting to see how many of the questions are repeats. Yet you continue to point folks in the right direction - even when answering the same questions for the hundredth time. thanks again! enjoy the day - marty - 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]
RE: Viewing XSP output with IE5.5
Generate a PI for the root element something like: xsl:template match=/ xsl:processing-instruction name=cocoon-formattype=text/xml /xsl:processing-instruction . . . /xsl:template marty -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, January 27, 2002 7:17 PM To: [EMAIL PROTECTED] Subject: Viewing XSP output with IE5.5 I am trying to display the output of the counter.xsp in IE5 In order to develop step by step, I want to check the output of my xsp file. IE5 is able to display an xml file Nice : it lets you open and close nodes. So after generating my xsp, I serialize it i xml. IE5 should display the xml. But instead, IE5 displays this : The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. The namespace prefix is not allowed to start with the reserved string xml. Line 2, Position 7 page xmlns:xml=http://www.w3.org/XML/1998/namespace; xmlns:xsp =http://apache.org/xsp; --^ With the View Source menu item I get this : ?xml version=1.0 encoding=UTF-8? page xmlns:xml=http://www.w3.org/XML/1998/namespace; xmlns:xsp =http://apache.org/xsp; pI have been requested 0 times./p /page The problem is that Cocoon adds xmlns:xml =http://www.w3.org/XML/1998/namespace; xmlns:xsp=http://apache.org/xsp; in the page tag. Why does Cocoon add those declarations here ? Is there a way of getting rid of them ? Valentin I am using Cocoon 2 on Windows 2000. The counter.xsp is this : ?xml version=1.0 encoding=ISO-8859-1? xsp:page language=java xmlns:xsp=http://apache.org/xsp; xsp:logic static private int counter = 0; private synchronized int count() { return counter++; } /xsp:logic page pI have been requested xsp:exprcount()/xsp:expr times./p /page /xsp:page === This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message - 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] - 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]
RE: Cocoon 2 with VAJ 4 and WTE
Hello Tom - If you get C2 running with VAJ4 and WTE - could you post the process back to the list? I use VAJ4 - and it would be great to have C2 integrated withit. marty -Original Message- From: Vadim Gritsenko [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 3:06 PM To: [EMAIL PROTECTED] Subject: RE: Cocoon 2 with VAJ 4 and WTE From: tom blondeau [mailto:[EMAIL PROTECTED]] snip/ but at least Cocoon seems to be running. when i request http://localhost:8080/cocoon/ the sitemap_xmap.java, sitemap_xmap.class and a 3rd classfile are created but I get an internal server error: The sitemap handler's sitemap is not available. Please check logs for the exact error. I found some discriptions of these errors in some mailing list archives, but no real solution that helped me. i'd really appreciate some help or ideas how to fix that... I do not not what's new in VAJ4 and websphere, but I recall that when I tried to run Cocoon under VAJ35, there were class loading issues. Try this: 1. Set classpath for the project to include directory were sitemap class is generated; 2. If this does not help, import sitemap class manually into VAJ, and never modify sitemap source after that - or repeat step 2 ;). Vadim - 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] - 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]
Re: Evaluating Variable XPATH
I have found the xslt list at: http://p2p.wrox.com/listindex.asp useful for help with xsl/xpath questions. In looking at your problems - I don't see a way to transform it in one step. I would have to pass it thru the transformer twice. marty - Original Message - From: Joseph Rajkumar [EMAIL PROTECTED] To: cocoon-users [EMAIL PROTECTED] Sent: Wednesday, January 16, 2002 11:52 AM Subject: Evaluating Variable XPATH Hi Folks I have the latest CVS of Cocoon+Tomcat-4.0.1 working fine and I am trying to demo this to the powers that decide. I have a minor problem and I am desperate. Part of the xml file:- MAIN DataValue=6 ViewValue=6.0/ ARC DataEnd=//MAIN/@DataValue ViewEnd=//MAIN/@ViewValue/ There are lots of ARC elements whose attributes DataEnd and ViewEnd contain XPATH to various other attributes contained in various other elements in the document. I need to get to the contents of the attribute contained in the DataEnd and ViewEnd In the following template: xsl:template match=ARC How do I print the value contained in the XPATH which is contained in the attribute @DataEnd or @ViewEnd What I need to print here is 6 and 6.0 as shown in the above example /xsl:template I have search many many places, but I could not resolve this. Thanks Joseph Rajkumar - 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] - 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]
Re: HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test
Generally - when I get this error - there is a mismatch between the configuration of the database and what has been specified when connecting with the driver. For example - I forgot to create the username/password - or the name of the database has a typo - or I forgot to create the sample database marty - Original Message - From: Ivan Manuel Andrade Muñoz [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 14, 2002 3:52 PM Subject: HELP: Error opening connection to dburl: jdbc:postgresql://localhost/test Hello to all, Happy New Year. The error is: *** -- - Cocoon 1.8.2 -- - Error found handling the request. java.lang.RuntimeException: Error opening connection to dburl: jdbc:postgresql://localhost/test at _usr._local._jakarta._build._tomcat._webapps._cocoon._samples._sql._esql.pop ulateDocument(_esql.java:162) at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97) at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527) at org.apache.cocoon.Engine.handle(Engine.java:384) at org.apache.cocoon.Cocoon.service(Cocoon.java:183) at javax.servlet.http.HttpServlet.service(HttpServlet.java:865) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:81 2) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpC onnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) at java.lang.Thread.run(Thread.java:484) -- - Warning: this page has been dynamically generated. Copyright (c) 1999-2001 The Apache XML Project. All rights reserved. -- -- I have installed: Red Hat Linux 7.2 Sun JDK 1.3.1_01 Apache 1.3.19 Tomcat 3.2.3 Cocoon 1.8.2 Postgresql 7.1.3 jdbc7.1-1.2 - Note: form postgresql 7.1.3, with the option -- with-java I have formed my archive: My file .bash_profile. # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs JAKARTA_HOME=/usr/local/jakarta ANT_HOME=$JAKARTA_HOME/jakarta-ant PATH=$PATH:$HOME/bin:/usr/java/jdk1.3.1_01/bin:$ANT_HOME/bootstrap/bin:/usr/ local/pgsql/bin BASH_ENV=$HOME/.bashrc USERNAME=root JAVA_HOME=/usr/java/jdk1.3.1_01 #JAKARTA_HOME=/usr/local/jakarta #ANT_HOME=$JAKARTA_HOME/jakarta-ant TOMCAT_HOME=$JAKARTA_HOME/build/tomcat COCOON_HOME=/usr/local/cocoon1.8.2/ PG=/usr/local/pgsql PGLIB=$PG/lib PGDATA=$PG/data MANPATH=$MANPATH:$PG/man CLASSPATH=/usr/local/jdbc7.1-1.2.jar export USERNAME BASH_ENV JAVA_HOME JAKARTA_HOME ANT_HOME TOMCAT_HOME COCOON_HOME PATH CLASSPATH -- - _ MSN Photos es la manera más sencilla de compartir e imprimir sus fotos: http://photos.latam.msn.com/Support/WorldWide.aspx - 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] - 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]
Re: Big problem with IE!
Which version of IE and what is the OS? Are you using Apache or IIS also? I am running C1.8.2 and tomcat 3.2 on my laptop. IE has been reliable for me since I did a clean install of Windows 2000. I did not install MS Office marty - Original Message - From: TJ Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 14, 2002 10:20 PM Subject: Re: Big problem with IE! Hi Adam Thanx for responding...The application works fine on Netscape 6. Also, I didn't mean '5' literally :-) It's a random-ish number - actually it's only guaranteed to fail (as it did today) during a customer demo! Unfortunately, customers know of no other browser than IE, so sadly TJ - Original Message - From: Adam A R [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, January 14, 2002 10:01 PM Subject: Re: Big problem with IE! Hi TJ, Please check the logicsheet which munges the data. If the browser(I think you will encounter the same problem if you were to use any other browser. Please check and let us know) can display it 5 times, it means that there is probably no problem with the browser. Sometimes you may keep opening connections to some resource without closing them in your pages. It will work for first 'n' number of times. And at 'n+1' th time it will fail. There was similar problem of mine. after 19-20 requests the CPU usage would become 100% without page being served and everything in a limbo. It turned out that there was a tweak inserted by another group of ours into Cocoon which %'$( the caching and hence the problem. Hope this gives some insight into your problem. cheers adam - Original Message - From: TJ Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, January 15, 2002 9:23 AM Subject: Big problem with IE! Hello all Before I get flamed - let me apologize for probably an inappropriate posting to the group -but I AM using Cocoon/Tomcat/Servlets/etc. so I'm hoping someone out there has encountered my problem (and has a FIX) and desperation has set in so Particulars: Tomcat 3.3, Cocoon 1.8.2. Cocoon used to serve html form pages for user updating, etc. When the form is sent to the server (submitted) it is sent to a servlet of mine running in Tomcat. The servlet munges the data etc. etc. The problem is with IE as the client browser. For 5 out of 6 (or thereabouts) times, accessing the servlet via URL works fine. The 6th time I get the infamous The Page cannot be displayed, Can't find server, blah blah. I've searched many news groups/microsoft support/etc. without success. Has anyone in this group encountered this #^%#^ problem? regards TJ - 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] - 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] - 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] - 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]
Re: Cocoon 1.8.2 on Tomcat w/IIS
We installed tomcat 3.2 with IIS following the instructions on the tomcat site for IIS. We installed Cocoon 1.8.2 on tomcat following the instructions on the cocoon site. marty - Original Message - From: Anthony Diodato [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, January 04, 2002 8:23 AM Subject: Cocoon 1.8.2 on Tomcat w/IIS Does anyone have good installation instructions to install Cocoon 1.8.2 on top of Tomcat using IIS as the webserver. The instructions on the http://xml.apache.org give instructions, but they are (I think) specific to Apache web server. Thanks in advance. Tony Anthony Diodato Webmaster - IT Prophet 21, Inc. 19 West College Avenue Yardley, PA 19067 1-800-776-7438, ext. 4600 Fax: 215-321-8014 [EMAIL PROTECTED] http://www.p21.com/ Prophet 21 -- Powering the Distribution Industry for the Digital Age For the latest press releases from Prophet 21 -- http://www.p21.com/press/press.html * 2/12/2001 - Trading Partner Connect Offers Enterprise-to-Enterprise (E2E) Commerce * 2/9/2001 -- Prophet 21 CommerceCenter 8.0 is Now Available * 2/9/2001 -- Prophet 21 Upgrades and Enhances Prophet 21 Acclaim For the latest articles on Prophet 21 http://www.manufacturing.net/magazine/id/archives/2001/ind010.02/techupdate. htm http://www.manufacturing.net/magazine/id/develop/techmain01.1.htm http://www.manufacturing.net/magazine/id/archives/2000/ind1201/news.htm Visit our website at http://www.p21.com/visit The information in this e-mail is confidential and may contain legally privileged information. It is intended solely for the person or entity to which it is addressed. Access to this e-mail by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution, action taken, or action omitted to be taken in reliance on it, is prohibited and may be unlawful. If you received this e-mail in error, please contact the sender and delete the material from any computer. - 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] - 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]
RE: HELP PLEASE: Error executing the example esql.xml on cocoon1.8.2
Title: Message did you install the postgres driver on tomcat? marty -Original Message-From: Ivan Manuel Andrade Muñoz [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 18, 2001 9:59 AMTo: [EMAIL PROTECTED]Subject: HELP PLEASE: Error executing the example esql.xml on cocoon1.8.2 I have installed: Red Hat 7.2 Postgresql 7.1.3. JDK1.3 JDBC: /usr/local/jdbc7.1-1.2.jar Cocoon1.8.2 Tomcat3.2.3 Now when I try to access my pages I get the following error message : When executing the example esql.xml of the cocoon 1.8.2 that is in /samples/sql/. Cocoon 1.8.2 Error found handling the request. java.lang.RuntimeException: Error loading driver: org.postgresql.Driver at _usr._local._jakarta._build._tomcat._webapps._cocoon._samples._sql._esql.populateDocument(_esql.java:141) at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97) at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:527) at org.apache.cocoon.Engine.handle(Engine.java:384) at org.apache.cocoon.Cocoon.service(Cocoon.java:183) at javax.servlet.http.HttpServlet.service(HttpServlet.java:865) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:812) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501) at java.lang.Thread.run(Thread.java:484) --- Warning: this page has been dynamically generated. --- What he/she would have to make to make work this example? To add or to modify something in tomcat.properties or cocoon.properties or pg_hba.conf? From already thank you for their help. Iván Andrade M. Punta Arenas. Chile. Con MSN Hotmail súmese al servicio de correo electrónico más grande del mundo. http://www.hotmail.com/ES- Please check that your question has not already been answered in the FAQ before posting. To unsubscribe, e-mail: <[EMAIL PROTECTED]>For additional commands, e-mail: <[EMAIL PROTECTED]>
Re: C2 MYSQL woes
Take a look at the mm.mysql jar. The jar I downloaded for mm.mysql had all the files under another directory - so until I unzipped the files and copied them into the tomcat classes folder - I got the same error you are reporting. marty - Original Message - From: Mauricio Souza Lima [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 18, 2001 8:36 AM Subject: Re: C2 MYSQL woes See the logs, they will help you with info about the problem, it still cant solve, send the part that the problem happens in the log. Sharat Koya wrote: Hi, I have been trying for the past few days to setup MySQL with C2 in order to use ESQL in my application. Unfortunately I can't get past the configuration problems. I have installed MySQL and C2 on my WinXP machine. Do I need to setup a driver for tomcat so that C2 can access MySQL on local host or can I get away with just declaring it in my ESQL code. If I don't need to setup the driver I tried the following code but C2 keeps returning the error Resource Not Found (404). Any help would be much appreciated. Thanks Sharat Koya ?xml version=1.0 encoding=ISO-8859-1? xsp:page language=java xmlns:xsp=http://apache.org/xsp; xmlns:esql=http://apache.org/cocoon/SQL/v2; page titleA Database Driven XSP Page/title content esql:connection esql:driverorg.gjt.mm.mysql.Driver/esql:driver esql:dburljdbc:mysql://localhost:3306/eclipse/esql:dburl esql:execute-query esql:queryselect * from planet_data/esql:query esql:results esql:row-results /esql:row-results /esql:results esql:no-results sectionRecord not found/section /esql:no-results esql:error-results sectionDatabase error: esql:get-message/ /section /esql:error-results /esql:execute-query /esql:connection /content /page /xsp:page - 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] -- Mauricio Souza Lima Rational Consulting [EMAIL PROTECTED] Rua Helena, 140 / cj. 82 São Paulo - SP - Brazil Fone / Direct: +55 11 3842-7138 - 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] - 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]
Re: MS SQL Server JDBC and Cocoon Connection Pool
I am using MS SQL Server with C1.8.2 - but I am not using the connection pooling feature. At the Microsoft site - I was able to download the 3 jars to support jdbc and put them in the tomcat lib. Microsoft also provided a fairly lenghty document with examples of the jdbc connection including the port used. The format Microsoft used for specifying the database name in the URL was a little different from what I was familar with - but once I followed the documentation - everything worked like a charm. marty - Original Message - From: Schroeter Christian [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 04, 2001 12:56 AM Subject: MS SQL Server JDBC and Cocoon Connection Pool Hi, i think about (..ok...i am forced to think about) to use the MS-SQL-Server. Surprisingly i didnt find any post in this mailinglist which deals with this challenge. So my questions: How do i connect to this MS-Sql-Server by using JDBC and the Cocoon Connection Pool (Cocoon 1.8.2)...ok... processor.xsp.pool.database.default.driver=??? processor.xsp.pool.database.default.url=??? processor.xsp.pool.database.adaptor.DBMSSqlServer=??? Which port is MSSqlServer using? In addition it was give this link to me: http://www.microsoft.com/sql/downloads/2000/jdbc.asp Cu, Christian - 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] - 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]
RE: Cocoon 1.8.2 + MySQL + JDBC + Win2000 + Tomcat
I had this problem when I put the mm.mysql jar in the tomcat library 6 months ago. The problem with the jar I had was in the paths for the drivers in the jar ( take a look in your jar ). I worked around the problem by unzipping the files - and copying them so the path matched. marty -Original Message- From: Schroeter Christian [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 28, 2001 11:00 AM To: [EMAIL PROTECTED] Subject: Cocoon 1.8.2 + MySQL + JDBC + Win2000 + Tomcat Hi, as i read here in the mailling-list and in the internet, there are more people who have problems to create an jdbc-connection to MySQL. At the moment i also try to establish such a connection. But it is not working, and i do not know why. Can anybody help? I am using MySQL (Version 3.23.38), Cocoon 1.8.2, Tomcat 3.2.3, Win2000 I used this jdbc-driver: mm.mysql-2.0.6.1.jar I copied them into TOMCAT_HOME/lib My cocoon.property-File has this: # These are your database settings, look in the # org.apache.turbine.util.db.pool.* package for more information. processor.xsp.pool.database.db.driver=org.gjt.mm.mysql.Driver processor.xsp.pool.database.db.url=jdbc:mysql:\\localhost\db processor.xsp.pool.database.db.username=lothar processor.xsp.pool.database.db.password=xxx processor.xsp.pool.database.db.maxConnections=3 processor.xsp.pool.database.db.expiryTime=360 I try this both xml-Files to access the DB: *** Without pool-connection: Source of the page: ... esql:connection esql:driverorg.gjt.mm.mysql.Driver/esql:driver esql:dburljdbc:mysql://localhost/db/esql:dburl esql:usernamelothar/esql:username esql:passwordxxx/esql:password I get this errormessage: java.lang.RuntimeException: Error loading driver: org.gjt.mm.mysql.Driver at _D_._Jakarta._Tomcat._jakarta_tomcat_3_2_3._webapps._cocoon._u ebung3._uebung3d_db.populateDocument(_uebung3d_db.java:183) at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97) at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProces sor.java:527) at org.apache.cocoon.Engine.handle(Engine.java:384) at org.apache.cocoon.Cocoon.service(Cocoon.java:183) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper .java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextM anager.java:812) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.http.HttpConnectionHandler.processCo nnection(HttpConnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin t.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo ol.java:501) at java.lang.Thread.run(Thread.java:484) *** With pool-connection ... esql:connection esql:pooldb/esql:pool esql:execute-query ... java.lang.RuntimeException: Error opening pooled connection: db: org.gjt.mm.mysql.Driver at _D_._Jakarta._Tomcat._jakarta_tomcat_3_2_3._webapps._cocoon._u ebung3._ue bung3c_db.populateDocument(_uebung3c_db.java:184) at org.apache.cocoon.processor.xsp.XSPPage.getDocument(XSPPage.java:97) at org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProces sor.java:5 27) at org.apache.cocoon.Engine.handle(Engine.java:384) at org.apache.cocoon.Cocoon.service(Cocoon.java:183) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper .java:405) at org.apache.tomcat.core.Handler.service(Handler.java:287) at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372) at org.apache.tomcat.core.ContextManager.internalService(ContextM anager.java:812) at org.apache.tomcat.core.ContextManager.service(ContextManager.java:758) at org.apache.tomcat.service.http.HttpConnectionHandler.processCo nnection(HttpConnectionHandler.java:213) at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoin t.java:416) at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPo ol.java:501) at java.lang.Thread.run(Thread.java:484) cu, Christian - 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] - 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
RE: XSP namespace question
I use the stylesheet below to display an xml fragment from the xsp page result. It seems to me you could do the same thing - just have type=text/html marty xsl:stylesheet xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xsl:template match=/page xsl:apply-templates/ /xsl:template xsl:template match=lom xsl:processing-instruction name=cocoon-formattype=text/xml /xsl:processing-instruction xsl:copy-of select=. / /xsl:template /xsl:stylesheet -Original Message- From: David Rosenstrauch [mailto:[EMAIL PROTECTED]] Sent: Friday, November 16, 2001 10:41 AM To: [EMAIL PROTECTED] Subject: Re: XSP namespace question Whoops! Meant to say: Would kinda suck if I ***CAN'T*** remove all the namespace declarations from my HTML. It really is making the HTML really long and ugly. DR At 09:26 AM 11/16/01 -0500, you wrote: Thanks for the tip. I thought I tried this ... but it was really late, so maybe I did something stupid. On the other hand though: I thought I saw something in my XSL book that said that 'exclude-result-prefixes' won't work when you're using xsl:copy. Anyone else hear that? Would kinda suck if I can remove all the namespace declarations from my HTML. Granted it is just cosmetic, but it's making the HTML really long and ugly. If anybody knows anything else, please let me know. Thanks, DR At 10:41 AM 11/16/01 +0100, you wrote: Hi David, in XSLT there is an attribute of xsl:stylesheet called 'exclude-result-prefixes'. I don't think that this will work already on the XSP, but at least in your XSL. Give it a try: xsl:stylesheet exclude-result-prefixes=xsp version=1.0 xmlns:xsl=.. It's a whitespace-separated list. If this doesn't work (because you only copy the node), try xsl:element name={name()} instead of xsl:copy. It gives the same result. With xsl:copy-of select=.. it's much more difficult. But the first hint should already work. Joerg - Original Message - From: David Rosenstrauch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 16, 2001 9:02 AM Subject: XSP namespace question Given an xsp page like this: xsp:page xmlns:xsp=http://apache.org/xsp; language=java page name=abc/ /xsp:page Cocoon seems to be giving me output like this: page xmlns:xsp=http://apache.org/xsp/ Is it necessary though that the namespace declaration get copied to the output? It's certainly not necessary any longer once the XSP has been run. Is there a way to turn off the copying of the namespace like this? This is causing me problems later on. My XSP page actually contains much more than this and when I apply a stylesheet (which uses xsl:copy), the namespace is getting copied to the HTML output. I'd like to avoid that if possible. Any ideas? Tnx! DR - 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] - 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] - 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] - 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]
Re: [C2] using HTML nowrap in a TD
I use nowrap=nowrap This approach has worked so far for any standalone html attributes I've encountered. So, likewise noshade=noshade marty - Original Message - From: Mark S. Kent [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 8:47 AM Subject: [C2] using HTML nowrap in a TD This is weird. I just tried putting a nowrap param to my TD tag in my XSL file like this: td nowrap to prevent the table cell in HTML from wrapping and got this error on the screen: Error creating the resource Failed to execute pipeline. and in the log: org.xml.sax.SAXParseException: Attribute name td must be followed by the '=' character. I was able to get around this by changing my tag to this: td nowrap= While obviously not valid HTML, the browser still takes it (IE anyway -- haven't tested with NetScrape) Comments? -Mark - 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] - 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]
RE: Cocoon 1.8.2 and mySQL/ ESQL - hanging?
Hello Derek - I had a similar problem once when I moved an application to Linux - and tried to run it before all the appropriate jars were in place. Then after putting the jars in the lib - the app still failed. I finally realized the problem was that tomcat had generated code for the xsp pages the first time I tried to run the app - and did not regenerate after I added the jars. The generated code is stored in the repository directory for tomcat. I deleted the generated code for the xsp page - then tried to execute it again - THEN it worked! I can't tell from your description of the problem if this could be the cause - but thought I'd pass this along just in case... marty -Original Message- From: Derek Hohls [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 2:38 AM To: [EMAIL PROTECTED] Subject: Re: Cocoon 1.8.2 and mySQL/ ESQL - hanging? Lajos Thanks for the suggestions. In response: 1. Where do I find the mysql_comp.jar you refer to (I do not have it on my Windows test machine) and a quick scan at the mysql site did not reveal anything either... all I have is the mm.mysql driver (as seen below) which is in the Java lib. 2. I cannot run the supplied esql examples as they depend on having the postgresql database installed... esql:driverorg.postgresql.Driver/esql:driver esql:dburljdbc:postgresql://localhost/test/esql:dburl esql:usernametest/esql:username esql:passwordtest/esql:password Thanks Derek [EMAIL PROTECTED] 17/10/2001 05:11:43 Derek: I assume that the MySQL jar is in the classpath? Depending on the version of Tomcat you're running, you'll want mysql_comp.jar in either $TOMCAT_HOME/lib or $TOMCAT_HOME/common/lib. Another idea is to run one of the supplied esql examples just to make sure that the taglib is working correctly. Lajos Derek Hohls wrote: I have a Cocoon system which fine on a setup under Win2000 as a localhost (Apache/Tomcat); but when I upload it to our UNIX server, also running Apache/Tomcat (which has just been setup to handle Cocoon - so we are still in 'testing' mode) - the app just hangs... The XML page is given below (altho' I do not think it is a syntax problem) - the MySQL part works OK if I logon to the server and run tests from the command line interface... Cocoon also handles normal XML pages fine, and the cocoon.properties file include the esql taglib. Any ideas as to where the 'hangup' might be or what part of the system I should look at it to try and see where it is getting to? My UNIX knowledge is very very basic (at best). All help much appreciated! Derek * ?xml version=1.0? ?cocoon-process type=xsp? ?cocoon-process type=xslt? ?xml-stylesheet type=text/xsl href=one_computer.xsl? xsp:page xmlns:xsp=http://www.apache.org/1999/XSP/Core; xmlns:esql=http://apache.org/cocoon/SQL/v2; xmlns:request=http://www.apache.org/1999/XSP/Request; page esql:connection esql:driverorg.gjt.mm.mysql.Driver/esql:driver esql:dburljdbc:mysql://myhost.com/est/esql:dburl esql:usernameest/esql:username esql:passwordest/esql:password esql:execute-query esql:querySELECT * FROM computer/esql:query esql:results esql:row-results computer systemesql:get-string column=System//system /computer /esql:row-results /esql:results /esql:execute-query /esql:connection /page /xsp:page - 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] - 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] - 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] - 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]
RE: [C2] Accessing CLOBs as Documents
I have a similar application - but the clob is an xml fragment ( meaning it doesn't have processing instruction tags ). So I can use get-xml instead of the get-ascii you use. Then I can access data in the xml fragment with the XSL stylesheet. marty -Original Message- From: Russell Castagnaro [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 12:48 PM To: [EMAIL PROTECTED] Subject: [C2] Accessing CLOBs as Documents Hello cocoon-users, I've got a problem. I have a table that has a few fields and a clob in it. I want to use the esql taglibs or SQLTransfromer to access this as a document. The column 'doc_content' is currently I'm using xml like this: ?xml version=1.0 encoding=ISO-8859-1? xsp:page language=java xmlns:xsp=http://apache.org/xsp; xmlns:esql=http://apache.org/cocoon/SQL/v2; page titleA Database XML DOC Page/title content esql:connection esql:poolfun/esql:pool esql:execute-query esql:querySelect * from XML_DOC where doc_id in (select max(doc_id) from xml_doc) /esql:query esql:results esql:row-results doc_idesql:get-string column=doc_id//doc_id doc_contentesql:get-ascii column=doc_content//doc_content esql:get-columns/ /esql:row-results /esql:results /esql:execute-query /esql:connection /content /page /xsp:page the 'doc_content' field' is returned escaped out: doc_contentlt;?xml version=1.0?gt; lt;Page name=Direct Donationgt; lt;DefaultRootgt;/templates/seattletimes/lt;/DefaultRootgt; lt;Content-Listgt; lt;Content type=include handleError=falsegt;header.jsplt;/Contentgt; lt;MainContent type=include handleError=truegt;donation2.jsplt;/MainContentgt; lt;Content type=include handleError=falsegt;footer.jsplt;/Contentgt; lt;/Content-Listgt; lt;Errorgt;error2.jsplt;/Errorgt; lt;/Pagegt;/doc_content Is there any way to have this content integrated into the document? Thanks, rrc -- Best regards, Russell mailto:[EMAIL PROTECTED] - 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] - 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]
RE: MySQL Drivers - Cocoon 1.8.2
Try making the change below to the cocoon properties file ( change DBMySQL to DBMM ). This worked for me. processor.xsp.pool.database.adaptor.DBMM=org.gjt.mm.mysql.Driver here's how I defined the connection pool: processor.xsp.pool.database.iluminaPool.driver=org.gjt.mm.mysql.Driverprocessor.xsp.pool.database.iluminaPool.url=jdbc:mysql://localhost/iluminaprocessor.xsp.pool.database.iluminaPool.username=mmartyprocessor.xsp.pool.database.iluminaPool.password=** marty -Original Message-From: Colm O'Riordan [mailto:[EMAIL PROTECTED]]Sent: Friday, October 05, 2001 7:29 PMTo: [EMAIL PROTECTED]Subject: MySQL Drivers - Cocoon 1.8.2Hi All, I am using Cocoon, running on Linux with the MySQL database and have set up my own connection pool in Cocoon.properties. I point to the MySQL Driver as follows: processor.xsp.pool.database.power.driver=org.gjt.mm.mysql.Driver processor.xsp.pool.database.power.url=jdbc:mysql:@localhost:3306?database=power This driver location I copied from Cocoon's own properties, ie ... processor.xsp.pool.database.adaptor.DBMySQL=org.gjt.mm.mysql.Driver I am relatively new to configuring Linux boxes so I may be missing something blatantly obvious here. It is throwing the following error upon trying to display an XML with database calls : Error found handling the request. java.lang.RuntimeException: Error opening pooled connection: power: Database type org.gjt.mm.mysql.Driver not implemented. I had been assuming that if Cocoon references this Driver in its own properties file under the heading : # These are the supported jdbc-drivers and their adaptors. then pointing to these drivers in my own connection pool would be enough. Is there something else I should be doing ? Any help hugely appreciated at this stage ! Thanks, ColmOR.
ide recommendations?
For the past six months I have been using notepad for writing xsp and xsl pages. This works - but I miss the debugging tools of an ide. Does anyone have experience with an ide that is useful in debugging xsp/xsl pages? marty - 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]
Re: esql nested query not working - 1.8.2
the error message is the same with and without the quotes - for string parameters or int parameters. i've tried numerous combinations. if i put in an explicit value it works - but i can get it to reference a parameter from the result set from Access. It will work if the backend is MySQL. From the reading I've done today - the MS Access ODBC driver does not support nested transactions according to the microsoft support site. So I'm thinking the problem with the nested query is specific to Access. marty - Original Message - From: Christopher Painter-Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 19, 2001 6:57 AM Subject: Re: esql nested query not working - 1.8.2 do you get a different error message when you leave out the quotes? Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: Re: esql nested query not working - 1.8.2 I've tried it both with and without the single quote and it still doesn't work. Here is another clue - the nested query works if I run it against a MySQL database, it just doesn't work against a Access database. In a couple of months - we'll be converting the access database. In the meantime, is there a solution ( that will work with the access database )? marty - Original Message - From: Christopher Painter-Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 9:41 AM Subject: Re: esql nested query not working - 1.8.2 Try removing the single quotes around esql:parameter type =stringesql:get-string ancestor=1 column=rid//esql:parameter I think by including the single quotes you are making a query that doesn't use parameters (your where clause looks like ... Main.rid = '?' , e.g., the literal string '?'). -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: esql nested query not working - 1.8.2 I would like to execute a nested query. When I try to reference a parameter from the ancestor query I get a java.lang.RuntimeException: Error setting parameter on statement : Select title from Main where Main.rid='?' I would greatly appreciate any suggestions. I have tried to emulate the example esql - but I can not get it to pick up the parameter. If I hardcode the value - the nested query works. In searching the list - I found a similar posting in January for this error - but no suggestion/solution was posted. I am running tomcat/cocoon 1.8.2 on Windows 98 and pointing to an access database. marty I am attaching the related code below: snip !-- here is the problem line - if I hardcode the rid this works -- esql:querySelect title from Main where Main.rid='esql:parameter type =stringesql:get-string ancestor=1 column =rid//esql:parameter'/esql:query snip - 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] - 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]
Re: esql nested query not working - 1.8.2
I've tried it both with and without the single quote and it still doesn't work. Here is another clue - the nested query works if I run it against a MySQL database, it just doesn't work against a Access database. In a couple of months - we'll be converting the access database. In the meantime, is there a solution ( that will work with the access database )? marty - Original Message - From: Christopher Painter-Wakefield [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 18, 2001 9:41 AM Subject: Re: esql nested query not working - 1.8.2 Try removing the single quotes around esql:parameter type =stringesql:get-string ancestor=1 column=rid//esql:parameter I think by including the single quotes you are making a query that doesn't use parameters (your where clause looks like ... Main.rid = '?' , e.g., the literal string '?'). -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: esql nested query not working - 1.8.2 I would like to execute a nested query. When I try to reference a parameter from the ancestor query I get a java.lang.RuntimeException: Error setting parameter on statement : Select title from Main where Main.rid='?' I would greatly appreciate any suggestions. I have tried to emulate the example esql - but I can not get it to pick up the parameter. If I hardcode the value - the nested query works. In searching the list - I found a similar posting in January for this error - but no suggestion/solution was posted. I am running tomcat/cocoon 1.8.2 on Windows 98 and pointing to an access database. marty I am attaching the related code below: snip !-- here is the problem line - if I hardcode the rid this works -- esql:querySelect title from Main where Main.rid='esql:parameter type =stringesql:get-string ancestor=1 column =rid//esql:parameter'/esql:query snip - 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] - 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]
RE: cocoon 2 tutorial
I have been working with 1.8.2 for about 6 months and I have considered putting the material into a tutorial. What suggestions do folks have for the format for a tutorial? Is there a suggested journal or magazine for publication? or is there a site for tutorials? marty -Original Message- From: Jesper Rasmussen [mailto:[EMAIL PROTECTED]] Sent: Monday, September 17, 2001 11:22 AM To: [EMAIL PROTECTED] Subject: cocoon 2 tutorial Does anyone know if anyone is working on making one or has done one? I'm thinking about doing one. Like one of thouse first pick up the spoon, then you ... I allways find thouse very helpfull get get some hands-on expirence before diving in to the theory. And when i started with cocoon i could not find one, so i had to do it the hard way :) HOWEVER im a newbie in cocoon, so what i probably would do is write what i believe to be the truth, and how i can make it work, and let you COCOON GURU's out there give me hell with all the mistakes :) and the vola we have a good tutorial :) cheers Jesper - May the source be with you, Linux - - 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] - 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]