You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by aps olute <ap...@yahoo.com> on 2002/12/24 02:05:20 UTC
esql in Cocoon-2.1-dev not working well?
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: esql in Cocoon-2.1-dev not working well?
Posted by Antonio Gallardo <ag...@agsoftware.dnsalias.com>.
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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>
Re: esql in Cocoon-2.1-dev not working well? Oracle specifically
Posted by aps olute <ap...@yahoo.com>.
Tried the latest download. Another 4 hours wasted, 21Meg download is too big
for a dial-up access. I cant do this download often. Far too many changes.
Same problem still, same esql code works in Tomcat 4.0.1 but not on 4.1.12.
What changes has been made ESQL much more difficult to use with Oracle in the
nightly builds? The Mysql version works fine in both versions of Tomcat.
And just quick testing of the samples, it seems XSP samples are erratic,
very few XSP samples work, most do not. I get time-outs, taking much too long
to compile the xsp? Noteable one I tried is
http://localhost:8080/cocoon/samples/xsp/cacheable where the error it spits
out is:
// start error (lines 82-82) " method generateKey() in class
org.apache.cocoon.www.samples.docs.samples.xsp.cacheable_xsp cannot override
method
generateKey() in class org.apache.cocoon.generation.AbstractServerPage with
different return type"
public long generateKey()
..plus more errors.
Futher <rant> I dont recall that the whole cocoon stalls before, if none
of the RDMBS are up and running when Tomcat is started. solution seems to have
the RDMBS up and running before starting Tomcat. <rant> The
installscratchpadwar build chokes on line 2315 missing fileset <jing
rngfiles="....>
--- aps olute <ap...@yahoo.com> wrote:
>
> 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: <co...@xml.apache.org>
> For additional commands, e-mail: <co...@xml.apache.org>
>
__________________________________________________
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>