cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominic Reynolds <domi...@lantnern.com>
Subject ESQL erros - cocoon2.0.3
Date Mon, 29 Jul 2002 20:23:52 GMT
I am trying to use ESQL (basic xsp page modelled on the samples).

my problem is that I get the following null pointer exception:

Original exception : java.lang.NullPointerException
        at 
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.&lt;init&gt;(EsqlQuery.java:99)


And looking at the source it seems that I'm not passing a connection to 
the constructor:
Esql.java -

 public EsqlQuery( EsqlConnection connection, String query ) {
    this.connection = connection;
    this.limitMethod = connection.getLimitMethod();   << line 99


Now looking at the generated java code for my xsp:
cocoon-files/org/apache/cocoon/www/upgrades/docs/upgrade_xsp.java
is see:

  private EsqlConnectionCocoon2 _esql_connection = null;
// .
// . some non-connection related java stuff......
// .
 _esql_query = new EsqlQuery( _esql_connection, String.valueOf(
      ""       + "SELECT guid FROM appliances WHERE guid="                +
        (request.getHeader("guid"))
      ) );


So the generated java code is incorrect. I know the datasource i'm using 
is ok as I am using it in an action and it works fine.
I must be doing something wrong here...but what?

Below is the xsp that is called:

<?xml version="1.0"?>
<xsp:page
      language="java"
      xmlns:xsp="http://apache.org/xsp"
      xmlns:esql="http://apache.org/cocoon/SQL/v2"
      xmlns:xsp-request="http://apache.org/xsp/request/2.0"
    >
    <esql:connection>
      <esql:pool>regdata</esql:pool>
      <esql:execute-query>
        <esql:query>SELECT guid FROM appliances WHERE 
guid=<xsp-request:get-header name="guid"/></esql:query>
        <esql:results>
          <table>
            <esql:row-results>
              <tr>
                 <td><esql:get-string column="product"/></td>
                 <!--
 <xsp:attribute name="value"><esql:get-string column="id"/></xsp:attribute>
                 -->
              </tr>
            </esql:row-results>
          </table>
   </esql:results>
        <esql:no-results>
           <p>Sorry No record</p>
        </esql:no-results>
      </esql:execute-query>
    </esql:connection>
</xsp:page>





---------------------------------------------------------------------
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:     <cocoon-users-unsubscribe@xml.apache.org>
For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


Mime
View raw message