cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fabio Duo" <fabio....@swissonline.ch>
Subject RE: No Results from database
Date Fri, 18 Jun 2004 17:08:50 GMT
If i use your xsp page, i recives the following error message:

******

An Error Occurred

The value of attribute "xmlns:xsp" associated with an element type
"xsp:page" must not contain the '<' character.

org.apache.cocoon.ProcessingException: The value of attribute "xmlns:xsp"
associated with an element type "xsp:page" must not contain the '<'
character.:
file:/C:/Programme/cocoon/cocoon-2.1.4/build/webapp/samples/DB/news.xsp:3:61
:org.xml.sax.SAXParseException: The value of attribute "xmlns:xsp"
associated with an element type "xsp:page" must not contain the '<'
character.

column: 61

line: 3

cause: org.xml.sax.SAXParseException: The value of attribute "xmlns:xsp"
associated with an element type "xsp:page" must not contain the '<'
character.

location:
file:/C:/Programme/cocoon/cocoon-2.1.4/build/webapp/samples/DB/news.xsp

******



 

-----Original Message-----
From: robby.pelssers@vodafone.com [mailto:robby.pelssers@vodafone.com] 
Sent: Freitag, 18. Juni 2004 18:25
To: users@cocoon.apache.org
Subject: RE: No Results from database

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:fabio.duo@swissonline.ch]
Sent: 18 June, 2004 17:41
To: users@cocoon.apache.org
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: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@cocoon.apache.org
For additional commands, e-mail: users-help@cocoon.apache.org


Mime
View raw message