First of all, try this ... i want to know if this isn't working ....
<?xml version="1.0" encoding="ISO-8859-1"?> <xsp:page language="java" xmlns:xsp=" http://apache.org/xsp <http://apache.org/xsp> " xmlns:esql=" http://apache.org/cocoon/SQL/v2 <http://apache.org/cocoon/SQL/v2> "> <page> <content> <esql:connection> <esql:pool>mySQLTEST</esql:pool> <esql:execute-query> <esql:query>SELECT nr, txt FROM test</esql:query> <esql:results> <table> <esql:row-results> <tr> <td><esql:get-string column="nr"/></td> <td><esql:get-string column="txt"/></td> </tr> </esql:row-results> </table> </esql:results> <esql:no-results> Sorry, no results! </esql:no-results> <esql:error-results> <xsp:attribute name="fatal-error"><xsp:get-message/></xsp:attribute> <stacktrace><esql:get-stacktrace/></stacktrace> </esql:error-results> </esql:execute-query> </esql:connection> </content> </page> </xsp:page> -----Original Message----- From: Fabio Duo [mailto:[EMAIL PROTECTED] Sent: 18 June, 2004 17:41 To: [EMAIL PROTECTED] Subject: No Results from database Hello, I want to get some results from a mySQL Database. I do this trough a esql logic sheet. But I don't receive error messages I simply don't get any results. I have no idea what this could be. Does someone has a idea? I have the relevant files in the mail(XSP-Page, Sitemap, cocoon.xconf, web.xml, Browser output). The Database exists and is filled with content. It seems to me that that esql things are just ignored, because the no-result content is also not displayed neither a error message. Please help me, I am getting crazy. Thanks a lot Fabio XSP - Page (news.xsp): <?xml version="1.0" encoding="ISO-8859-1"?> <xsp:page language="java" xmlns:xsp=" http://apache.org/xsp <http://apache.org/xsp> " xmlns:esql=" http://apache.org/cocoon/SQL/v2 <http://apache.org/cocoon/SQL/v2> "> <page> <content> <esql:connection> <esql:pool>mySQLTEST</esql:pool> <esql:execute-query> <esql:query>SELECT * FROM test</esql:query> <esql:results> <esql:row-results> <esql:get-string column="nr"/> <esql:get-string column="txt"/> </esql:row-results> </esql:results> <esql:no-results> Sorry, no results! </esql:no-results> <esql:error-results> <xsp:attribute name="fatal-error"><xsp:get-message/></xsp:attribute> <stacktrace><esql:get-stacktrace/></stacktrace> </esql:error-results> </esql:execute-query> </esql:connection> </content> </page> </xsp:page> Sitemap.xmap: <?xml version="1.0" encoding="ISO-8859-1"?> <!-- CVS $Id: sitemap.xmap,v 1.13 2003/11/18 07:12:10 tony Exp $ --> <map:sitemap xmlns:map=" http://apache.org/cocoon/sitemap/1.0 <http://apache.org/cocoon/sitemap/1.0> "> <map:components> <map:transformer name="sql" logger="sitemap.transformer.sql" src="org.apache.cocoon.transformation.SQLTransformer"/> </map:components> <!-- =========================== Pipelines ================================= --> <map:pipelines> <map:pipeline> <map:match pattern="test.xsp"> <map:generate type="serverpages" src="news.xsp"/> <map:serialize type="xml"/> </map:match> </map:pipeline> </map:pipelines> </map:sitemap> Cocoon.xconf: <jdbc name="mySQLTEST"> <pool-controller max="8" min="2"/> <dburl>jdbc:mysql://localhost/da</dburl> <user>root</user> <password>alta</password> </jdbc> Web.xml: <init-param> <param-name>load-class</param-name> <param-value>org.gjt.mm.mysql.Driver</param-value> </init-param> Browser output: <?xml version="1.0" encoding="ISO-8859-1"?> <page xmlns:xsp=" http://apache.org/xsp <http://apache.org/xsp> " xmlns:xspdoc=" http://apache.org/cocoon/XSPDoc/v1 <http://apache.org/cocoon/XSPDoc/v1> " xmlns:esql=" http://apache.org/cocoon/SQL/v2 <http://apache.org/cocoon/SQL/v2> "> <content> </content> </page> --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
