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