You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Ch...@vodafone.nl on 2002/05/01 15:44:17 UTC
Can't get ESQL in XSP to work....
Hi - I tried the following XSP file...
<?xml version="1.0"?>
<xsp:page
xmlns:xsp="http://apache.org/xsp"
xmlns:esql="http://apache.org/cocoon/SQL/v2">
<esql:connection>
<esql:pool>venusPool</esql:pool>
<esql:execute-query>
<esql:query>select * from ref_country</esql:query>
<esql:results>
<esql:row-results>
<para><esql:get-string column="description"/></para>
<esql:get-columns/>
</esql:row-results>
</esql:results>
</esql:execute-query>
</esql:connection>
</xsp:page>
I am using Weblogic 6.0sp2, on Solaris, and Cocoon 2.0.2,
and I cannot get this XSP to work - the connection pool is defined in the
config.xml as below:
<JDBCConnectionPool CapacityIncrement="1"
DriverName="oracle.jdbc.driver.OracleDriver" InitialCapacity="0"
MaxCapacity="5" Name="venusPool"
Properties="user=theuser;password=thepass" Targets="eservices"
URL="jdbc:oracle:thin:@venus:1521:thedatabase"/>
So venusPool exists - and it's running - but when I try to run the above XSP
code, I get this rather unfriendly
and unhelpful message:
Cocoon 2 - Internal server error
type fatal
message Exception in ServerPagesGenerator.generate()
description org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.NullPointerException
sender org.apache.cocoon.servlet.CocoonServlet
source Cocoon servlet
stack-trace
org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.NullPointerException
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:272)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:251)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:399)
at
org.apache.cocoon.www.sitemap_xmap.matchN10388(/export/weblogic_6.0/config/v
odafone/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/coco
on-files/org/apache/cocoon/www/sitemap_xmap.java:4185)
at
org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf
one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f
iles/org/apache/cocoon/www/sitemap_xmap.java:3218)
at
org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf
one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f
iles/org/apache/cocoon/www/sitemap_xmap.java:3091)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:222)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at
org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154)
at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:998)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:213)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:1265)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
java.lang.NullPointerException
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.(EsqlQuery.java:9
0)
at
org.apache.cocoon.www.dealersite.helloworld_xsp.generate(/export/weblogic_6.
0/config/vodafone/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_c
ocoon/cocoon-files/org/apache/cocoon/www/dealersite/helloworld_xsp.java:296)
at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenera
tor.java:260)
at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEv
entPipeline.java:251)
at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingS
treamPipeline.java:399)
at
org.apache.cocoon.www.sitemap_xmap.matchN10388(/export/weblogic_6.0/config/v
odafone/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/coco
on-files/org/apache/cocoon/www/sitemap_xmap.java:4185)
at
org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf
one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f
iles/org/apache/cocoon/www/sitemap_xmap.java:3218)
at
org.apache.cocoon.www.sitemap_xmap.process(/export/weblogic_6.0/config/vodaf
one/applications/cocoon/WEB-INF/_tmp_war_eservices_eservices_cocoon/cocoon-f
iles/org/apache/cocoon/www/sitemap_xmap.java:3091)
at org.apache.cocoon.sitemap.Handler.process(Handler.java:222)
at org.apache.cocoon.sitemap.Manager.invoke(Manager.java:179)
at
org.apache.cocoon.sitemap.SitemapManager.process(SitemapManager.java:154)
at org.apache.cocoon.Cocoon.process(Cocoon.java:575)
at
org.apache.cocoon.servlet.CocoonServlet.service(CocoonServlet.java:998)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubImpl.java
:213)
at
weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppServletCo
ntext.java:1265)
at
weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestImpl.java
:1631)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:137)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)
request-uri
/dealersite/helloworld.xsp
path-info
dealersite/helloworld.xsp
Anyone have an idea?
TIA
Chris
---------------------------------------------------------------------
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: <co...@xml.apache.org>
For additional commands, e-mail: <co...@xml.apache.org>