How can get the xml-file which cocoon produces...
...and what must i do to: * display it in the browser (eg. MSIE) * sent it so that the browser would save it as an file * sent it as an eMail (eg as an attachment) at the moment i use cocoon 1.8.2 but i think about to change to cocoon2 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]
How can get the xml-file which cocoon produces...
...and what must i do to: * display it in the browser (eg. MSIE) * sent it so that the browser would save it as an file * sent it as an eMail (eg as an attachment) at the moment i use cocoon 1.8.2 but i think about to change to cocoon2 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]
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]
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._uebung3._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(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: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(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) *** 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._uebung3._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(XSPProcessor.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(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) 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]
Re: SQL-Statment with two (or more) where statments
Hi Christopher, now it works... ...after i restarted tomcat and apache and then my server :-] it works...i dont know why... on the same day i got the errormessage that the code cannot be compiled and since that errormessage nothing worked anymore...because of this i restarted everything...mybe there is a context between both events...??? sorry for the excitement i produced with my question... cu, christian Am Freitag, 26. Oktober 2001 16:49 schrieben Sie: Christian, I can't see anything wrong, but you've not shown us all your code. Also, we have no way of verifying that your column and table names match your database. One reason it is hard to debug ESQL is because all exceptions get trapped and turned into generic exceptions, so you don't know what actual issue the JDBC driver or database is complaining about. You should first ensure your queries work outside Cocoon (e.g., type them into a query tool and see if they blow up). You can also try building up from simple queries that work, adding to them in small increments, e.g., one WHERE condition at a time and so forth. That should help you find what bit is causing the trouble. If you want to see what JDBC is really complaining about, you'll have to hack the esql.xsl logicsheet to re-throw the JDBC exceptions instead of substituting generic exceptions. -Christopher Please respond to [EMAIL PROTECTED] To: [EMAIL PROTECTED] cc: Subject: SQL-Statment with two (or more) where statments Hi, i use cocoon1.8.2. Now i have a little problem: i want to query my db like this: esql:connect ... esql:connect ... SELECT a.name FROM a, b WHERE b.fk2 = a.pk AND b.fk1 = esql:parameter type=string esql:get-string ancestor=1 column=fk_x/ /esql:parameter ... /esql:connection /esql:connection But i get the errormessage: Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 = a.pk AND b.fk1 = ? When i only use one where statment it works, but with 2 it wount What must i change ? 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]
SQL-Statment with two (or more) where statments
Hi, i use cocoon1.8.2. Now i have a little problem: i want to query my db like this: esql:connect ... esql:connect ... SELECT a.name FROM a, b WHERE b.fk2 = a.pk AND b.fk1 = esql:parameter type=string esql:get-string ancestor=1 column=fk_x/ /esql:parameter ... /esql:connection /esql:connection But i get the errormessage: Error executed prepared statement: SELECT a.name FROM a, b WHERE b.fk2 = a.pk AND b.fk1 = ? When i only use one where statment it works, but with 2 it wount What must i change ? 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]
date-format in cocoon 1.8.2
Hi, what must i do to change the format of the date i get with esql:get-date... i am using cocoon1.8.2 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]
Cocoon 1.8.2, esql, html
Hi, my html-pages are stored in the database (postgres). Now i want to read them out by e.g. ...queryselect html from page where pageno=20/query...htmlesql:get-string column=html/... in the xsl-page i wrote xsl:value-of select=html Urtunfortunately the result is not html because the , etc. are replaced. What must i do so that the result is displayed and interpreted by the browser as it would be html? 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]
esql, cocoon 1.8.2
Hi, which esql-tag must i use to get the number of the results a sql-statment returns? 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]