Hi! Try to download a newer version. I recently updated the CVS HEAD and everythings works fine. I use Tomcat 4.1.18, Java 1.4.1_01, Red Hat Linux 8.0 and PostgreSQL.
Antonio Gallardo. aps olute dijo: > > Esql file that works in Tomcat 4.0.1 does not work in Tomcat 4.1.12? > > I have compiled the nightly download 12/20/2002 and running most of the > samples on a Tomcat 4.1.12. I added the datasources for oracle and mysql > (cocoon.xconf), the jdbc drivers (in WEB-INF/lib/ and modified web.xml), > I added a submount by symlinking it under cocoon/samples/ctwig ie > cocoon/samples/ctwig/ctwig. Basic xml files are transformed using xsl > files just like the CTWIG sample. I symlinked this directory that has > esql query with its corresponding xsl file to this directory. (btw the > base directory is located in another Tomcat > 4.0.1/webapps/cocoon/ctwig/). Launched Tomcat 4.1.12, point my browser > to > http://localhost:8080/cocoon/samples/ctwig/ctwig/esqlora2.xml and I get > errors. > Launched Tomcat 4.0.1 (now .12 and .1) up, point my browser to 4.0.1 > relateted > url, http://localhost:8069/cocoon/ctwig/esqlora2.xml it works fine, the > query is executed and the table is displayed. This is the same file with > different results Why? > > The error on 4.1.12 is: > org.apache.cocoon.ProcessingException: Exception in > ServerPagesGenerator.generate(): java.lang.RuntimeException: Error > executing statement: SELECT * FROM emp: java.sql.SQLException: > Invalid argument(s) in call: absolute (0) > at > >org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:275) > at > >org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:513) > at > >org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline(AbstractCachingProcessingPipeline.java:192) > > > this is esqlora2.xml > > <?xml version="1.0" encoding="ISO-8859-1"?> > <xsp:page > language="java" > xmlns:xsp="http://apache.org/xsp"; > xmlns:esql="http://apache.org/cocoon/SQL/v2";> > <page> > <title>A Database Driven XSP Page</title> > <content> > <esql:connection> > <esql:pool>personnel</esql:pool> > <esql:execute-query> > <esql:query>SELECT * FROM emp</esql:query> > <esql:results> > <table> > <esql:row-results> > <tr> > <td><esql:get-string column="empno"/></td> > <td><esql:get-string column="ename"/></td> > <td><esql:get-string column="job"/></td> > <td><esql:get-string column="deptno"/></td> > <td><esql:get-string column="mgr"/></td> > <td><esql:get-date column="hiredate"/></td> > <td><esql:get-string column="sal"/></td> > <td><esql:get-row-position /></td> > </tr> > </esql:row-results> > </table> > </esql:results> > <esql:no-results> > <p>Sorry, no results!</p> > </esql:no-results> > </esql:execute-query> > </esql:connection> > </content> > </page> > </xsp:page> > > > > __________________________________________________ > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now. > http://mailplus.yahoo.com > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>
