cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "davide semprini" <semprini_dav...@hotmail.com>
Subject AGAIN error null pointer ESQL
Date Wed, 22 Nov 2000 14:55:58 GMT
HI,
tanks for reply me ,
but the error persist
I have to create also the xsl stylesheet
to display the rowset? I don't think so,
my file is correct but why null pointer error?

---------- dadde.xml----------------

<?xml version="1.0"?>
<?xml-logicsheet
href="resource://org/apache/cocoon/processor/xsp/library/sql/esql.xsl"?>
<?cocoon-process type="xsp"?>
<xsp:page
  language="java"
  xmlns:esql="http://apache.org/cocoon/SQL/v2"
  xmlns:xsp="http://www.apache.org/1999/XSP/Core">
  <page>
    <esql:connection>
      <esql:driver>oracle.jdbc.oracle.OracleDriver</esql:driver>
      <esql:dburl>jdbc:oracle:thin:@sirio.cineca.it:1521:sdb</esql:dburl>
      <esql:username>semprini</esql:username>
      <esql:password>semprini</esql:password>
      <esql:execute-query>
     <esql:query>select nome from dati</esql:query>

     <esql:results>
       <esql:row-results>
       <nome><esql:get-string column="nome"/></nome>
       </esql:row-results>
       <esql:no-results>
       <blank>No results returned</blank>
       </esql:no-results>
       <esql:error-results>
       <error>There was a database error</error>
       </esql:error-results>

       </esql:results>
     </esql:execute-query>
</esql:connection>
</page>
</xsp:page>


I have to set in my cocoon.properties another setting
about esql?

tanks a lot !!!!!!!
















>From: Kevin Sonney <kevin@webslingerz.com>
>Reply-To: cocoon-users@xml.apache.org
>To: cocoon-users@xml.apache.org
>Subject: Re: error null pointer ESQL
>Date: Wed, 22 Nov 2000 09:37:55 -0500 (EST)
>
>Davide -
>
>On Wed, 22 Nov 2000, davide semprini wrote:
> > i try to work in cocoon with this file:
> >
> > dadde.xml--------------------------
><trim />
>
>Looking at the doc, The first thing I'd do is put the return data from the
>row-results into a tag, and catch the other conditions, like so :
>
><!-- result processing -->
><esql:results>
><!-- if we have data returned -->
><esql:row-results>
><nome><esql:get-string column="nome"/></nome>
></esql:row-results>
><!-- if no data is returned -->
><esql:no-results>
><blanco>No results returned</blanco>
></esql:no-results>
><!-- error in resultset -->
><esql:error-results>
><error>There was a database error</error>
></esql:error-results>
></esql:results>
><!-- end result processing -->
>
>HTH
>
>--
>+-------------------------------------------+
>| Kevin Sonney        kevin@webslingerZ.com |
>| Systems Programmer    www.webslingerZ.com |
>+-------------------------------------------+
>
>"The weakest link in any civil rights case is always the
>defendant. Imagine being a lawyer and getting a call from me. That's why I
>try to, uh, behave myself." - Hunter S. Thompson
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
>For additional commands, e-mail: cocoon-users-help@xml.apache.org
>

_____________________________________________________________________________________
Get more from the Web.  FREE MSN Explorer download : http://explorer.msn.com


Mime
View raw message