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