You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@cocoon.apache.org by Alessandro Marcellini <am...@tiscalinet.it> on 2001/01/22 12:49:03 UTC
NullPointerException with esql
Hi,
I'm starting to use esql but I don't know how to configure it:
I'm running cocoon1.8 with apache1.14 and tomcat3.2 on java3
I added to cocoon.properies the string:
processor.xsp.logicsheet.esql.java =
resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl
And this is my esql xml taglib (I modified the esql.xml, the example):
<?xml version="1.0"?>
<?cocoon-process type="xsp"?>
<?xml-logicsheet
href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<xsp:page
language="java"
xmlns:esql="http://apache.org/cocoon/SQL/v2"
xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>
<page>
<esql:execute-query>
<esql:driver>postgresql.Driver</esql:driver>
<esql:dburl>jdbc:postgresql://gedeone/listino</esql:dburl>
<esql:username>pippo</esql:username>
<esql:password>pippo</esql:password>
<esql:query>select * from listino</esql:query>
<esql:results>
<ROWSET>
<esql:execute-query>
<esql:query>select * from employee_table where department_id =
<esql:get-string column="id" ancestor="1"/></esql:query>
<esql:results>
<ROW>
<id><esql:get-string column="lcoar"/></id>
<name><esql:get-string column="lumis"/></name>
</ROW>
</esql:results>
</esql:execute-query>
</ROWSET>
</esql:results>
<esql:no-results>
<error>no results were found</error>
</esql:no-results>
<esql:error-results>
<message><esql:get-message/></message>
<stacktrace><esql:get-stacktrace/></stacktrace>
</esql:error-results>
</esql:execute-query>
</page>
</xsp:page>
The error is:
java.lang.NullPointerException:
at
org.apache.cocoon.processor.xsp.XSPProcessor.process(XSPProcessor.java:412)
at org.apache.cocoon.Engine.handle(Engine.java:359)
at org.apache.cocoon.Cocoon.service(Cocoon.java:167)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:404)
at org.apache.tomcat.core.Handler.service(Handler.java:286)
at
org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
at
org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
at
org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
at
org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:210)
at
org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
at
org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:498)
at java.lang.Thread.run(Thread.java:475)
What I've forget?
Thank's
Alessandro