HELP: esql in logicsheet --> Compilation failed...

[Carsten Bock]

hello all together,

I try to use esql for database access in a logicsheet. I always get a
compilation error on that!

If I integrate my code directly in my XML file then everything is fine!?!

I would be happy if anyone could give me hint/help.

Thank you very much in advance, Carsten

My Configuration:
tomcat 3.2.2
cocoon 1.8.2
MS-SQL Server 7.0

----------
Here is my XML-File:

<?xml version="1.0"?>

<!-- Author: Stefano Mazzocchi "[EMAIL PROTECTED]" -->
<!-- Version: $Id: clean-page.xml,v 1.2 2000/02/16 01:09:30 stefano Exp
$ -->

<?cocoon-process type="xslt"?>
<?xml-stylesheet href="test_xsp.xsl" type="text/xsl"?>

<page>
 <title></title>

</page>

-----------

And this is my logicsheet:

<?xml version="1.0"?>

<xsl:stylesheet version="1.0"
   xmlns:xsl="http://www.w3.org/1999/XSL/Transform";
   xmlns:xsp="http://www.apache.org/1999/XSP/Core";
>

  <xsl:template match="page">

    <xsl:processing-instruction
name="cocoon-process">type="xsp"</xsl:processing-instruction>

<!--    <xsl:processing-instruction
name="cocoon-process">type="xslt"</xsl:processing-instruction>
    <xsl:processing-instruction name="xml-stylesheet">href="page-html.xsl"
type="text/xsl"</xsl:processing-instruction>
-->
    <xsp:page language="java"
xmlns:xsp="http://www.apache.org/1999/XSP/Core";
xmlns:esql="http://apache.org/cocoon/SQL/v2";>
     <xsp:logic>
        <esql:connection>
         <esql:driver>sun.jdbc.odbc.JdbcOdbcDriver</esql:driver>
         <esql:dburl>jdbc:odbc:DB-PAK-SA-bock</esql:dburl>
         <esql:username>sa</esql:username>
         <esql:password></esql:password>
        <esql:execute-query>
        <esql:query>select * from Anlagen</esql:query>
        </esql:execute-query>
        </esql:connection>
     </xsp:logic>
    </xsp:page>
  </xsl:template>
</xsl:stylesheet>

-------------------------

Cocoon's error message:

java.lang.Exception: XSP Java Compiler: Compilation failed for
_database.java
77: Type expected.

    if (_esql_connection != null) {                             DOES THIS MEAN THAT 
THERE IS ALEADY A
CONNECTION OBJCET?

    ^

1 error

        at
org.apache.cocoon.processor.xsp.language.java.XSPJavaProcessor.compile(XSPJa
vaProcessor.java:146)
        at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:522)
        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:79
7)
        at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
        at
org.apache.tomcat.service.connector.Ajp12ConnectionHandler.processConnection
(Ajp12ConnectionHandler.java:166)
        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)


---------------------------------------------------------------------
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]>