On 29.Jul.2002 -- 01:23 PM, Dominic Reynolds wrote:
> 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.<init>(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?
Everything looks fine. Could you produce a complete stack trace?
Other XSPs using esql work fine, right?
>
> 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>
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
