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