cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Christian Parpart" <tra...@gmx.de>
Subject AW: HERE: I can't execute ANY esql-queries
Date Tue, 21 Nov 2000 23:45:53 GMT
> -----Urspr√ľngliche Nachricht-----
> Von: Robin Green [mailto:greenrd@hotmail.com]
> Gesendet: Dienstag, 21. November 2000 02:45
> An: cocoon-users@xml.apache.org
> Betreff: Re: AW: HERE: I can't execute ANY esql-queries
>
>
> Which version of Cocoon are you using?

Hmm, after reading your question, I've downloaded the lates
cvs (some minutes ago). But it's the same. So I should conclude
that the problem isn't here maybe. That's why I post my hole
test file below.

current configuration:
  * xml-cocoon (cvs)
  * Apache Web Server (1.3.12Win32)
  * Apache JServ (1.1.1)
      (jserv.properties: below)
  * mm.mysql.jdbc (2.0pre5)
      (using mysql_both_uncomp.jar)
  * MySQL (3.23)
      Server=D:/Programme/mysql/bin/mysqld-nt.exe

------ test.xml --------------------------------------
<?xml version="1.0"?>

<?xml-stylesheet type="text/xsl" href="test.xsl"?>
<?xml-logicsheet href="test-lib.xsl"?>
<?xml-logicsheet
href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>

<?cocoon-process type="xsp"?>

<xsp:page
  language="java"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
  xmlns:test="http://www.erdkunde-online.itl/test"
>

  <page>
    <title>Test</title>
    <test:test/>

    <esql:execute-query>
      <esql:driver>org.gjt.mm.mysql.Driver</esql:driver>
      <esql:dburl>jdbc:mysql://www.erdkunde-online.itl/eko</esql:dburl>
      <esql:username>anuser</esql:username>
      <esql:password>anpasswd</esql:password>
      <esql:query>select * from Land</esql:query>

      <esql:results>
        <b><esql:get-string column="Name"/></b>
      </esql:results>
    </esql:execute-query>
  </page>

</xsp:page>

------ test.xsl --------------------------------------
<?xml version="1.0"?>

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/XSL/Transform/1.0"
>

  <xsl:template match="/page">
    <xsl:apply-templates/>
  </xsl:template>

  <xsl:template match="title">
    <h1><xsl:value-of select="."/></h1>
  </xsl:template>

  <xsl:template match="@*|node()" priority="-1">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>
  </xsl:template>

</xsl:stylesheet>

------ test-lib.xsl ----------------------------------
<?xml version="1.0"?>

<xsl:stylesheet
  xmlns:xsl="http://www.w3.org/XSL/Transform/1.0"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core"
  xmlns:test="http://www.erdkunde-online.itl/test"
>

  <xsl:template match="xsp:page">
    <xsp:page>
      <xsl:apply-templates select="@*"/>
      <xsl:apply-templates/>
    </xsp:page>
  </xsl:template>

  <xsl:template match="test:test">
    <h3>test:test called</h3>
  </xsl:template>

  <xsl:template match="@*|node()" priority="-1">
    <xsl:copy>
      <xsl:apply-templates select="@* | node()"/>
    </xsl:copy>
  </xsl:template>

</xsl:stylesheet>

------ jserv.properties --------------------------------
wrapper.bin=d:\jdk1.3\bin\java.exe

wrapper.classpath=D:\Programme\Apache JServ 1.1.1\ApacheJServ.jar
wrapper.classpath=D:\jsdk2.0\lib\jsdk.jar
wrapper.classpath=D:\jswdk-1.0.1\webserver.jar
wrapper.classpath=c:\Eigene Dateien\projects\xml-cocoon\lib\fop_0_13_0.jar
wrapper.classpath=c:\Eigene
Dateien\projects\xml-cocoon\lib\xalan_1_2_D02.jar
wrapper.classpath=c:\Eigene Dateien\projects\xml-cocoon\lib\xerces_1_2.jar
wrapper.classpath=c:\Eigene Dateien\projects\xml-cocoon\lib\ant_1_1.jar
wrapper.classpath=c:\Eigene Dateien\projects\xml-cocoon\lib\turbine-pool.jar
wrapper.classpath=c:\Eigene
Dateien\projects\xml-cocoon\lib\stylebook-1.0-b2.jar
wrapper.classpath=c:\Eigene Dateien\projects\xml-cocoon\lib\bsf.jar
wrapper.classpath=c:\Eigene Dateien\projects\xml-cocoon\lib\bsfengines.jar
wrapper.classpath=c:\Eigene Dateien\projects\xml-cocoon\build\cocoon.jar
wrapper.classpath=D:\jdk1.3\lib\tools.jar
wrapper.classpath=D:\Programme\mm.mysql.jdbc-2.0pre5\mysql_both_uncomp.jar

bindaddress=localhost
port=8007

zones=root
root.properties=D:\Programme\Apache JServ 1.1.1\servlets\zone.properties

pool.capacity=10
pool.controller=org.apache.java.recycle.DefaultController

security.selfservlet=true
security.maxConnections=50
#security.allowedAddresses=127.0.0.1
security.authentication=false
#security.secretKey=c:/ApacheJServ/servlets/jserv.secret.key
#security.challengeSize=5

log=true
log.file=D:\Programme\Apache JServ 1.1.1\logs\jserv.log
log.timestamp=true
log.dateFormat=[dd/MM/yyyy HH:mm:ss:SSS zz]
log.queue.maxage = 5000
log.queue.maxsize = 1000
# log.channel=false
# log.channel.info=true
log.channel.servletException=true
log.channel.jservException=true
log.channel.warning=true
log.channel.servletLog=true
log.channel.critical=true
# log.channel.debug=true
----- end of file (jserv.properties) -------------------

Regards,
Christian Parpart
mailto:cparpart@surakware.com
http://www.surakware.com (NEW http://surak.cocoonhost.com)


Mime
View raw message