Christian Haul says:
> On 24.Apr.2002 -- 08:54 AM, [EMAIL PROTECTED] wrote:
> > Thanks, yes that makes sense.  However when I use "serverpages" I get
> > a class not found (BTW, I'm using JDK 1.3.1 and Tomcat 4.0.1).  I'd
> > sure like to have this working!  Sorry if I'm missing something
> > obvious.
> > 
> > org.apache.cocoon.components.language.LanguageException: Could not load class for 
>program 'org/apache/cocoon/www/docs/myfile_xm
l' due to a java.lang.ClassNotFoundException: org.apache.cocoon.www.docs.myfile_xml
> 
> Looks like there is a problem with your XSP or - if any - your
> logicsheets. There should be another message telling you exactly what
> went wrong. Cocoon is very verbose on errors so sometimes one doesn't
> spot the root cause.

I don't know, it it pretty simple...

<?xml version="1.0"?>
<xsp:page language="java"
  xmlns:xsp="http://www.apache.org/xsp";
  xmlns:esql="http://apache.org/cocoon/SQL/2.0";
>
<page>
<esql:connection>
  <esql:pool>my_pool</esql:pool>
  <esql:execute-query>
    <esql:query>select 123450</esql:query>
    <esql:results>
      <header>header info</header>
      <esql:row-results>
          <n><esql:get-int column="Number"/></n>
      </esql:row-results>
      <footer>footer info</footer>
    </esql:results>
  </esql:execute-query>
</esql:connection>
</page>
</xsp:page>

I also, tried it with the jdbc login in there instead of the
connection pool but the result was the same.  I think the connection
pool is working fine.  Thanks for the feedback, I'll keep looking I
guess.

By the way, the SQL transforer works well but there's some little
detail problems with that.  I really need to use esql instead (so
far).

 
> Your XSP will be transformed to a java file, here
> org/apache/cocoon/www/docs/myfile_xml.java and then compiled to
> org/apache/cocoon/www/docs/myfile_xml.class
> (paths relative to $TOMCAT/work/localhost/cocoon/....)
> 
>       Chris.
> 
> -- 
> C h r i s t i a n       H a u l
> [EMAIL PROTECTED]
>     fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08
> 
> ---------------------------------------------------------------------
> 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]>
> 



--
Jeff Sexton
ODS Health Plans
[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]>

Reply via email to