cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gabriele Domenichini" <gabrid...@fastmail.fm>
Subject Re: Pleeese! retrieving xml code as out-parameter
Date Mon, 09 Dec 2002 18:58:22 GMT
I began to switch but it doesn't seem to work.
Here is my procedure how it was written for the sql transformer
<execute-query xmlns="http://apache.org/cocoon/SQL/2.0">
	<query lang="1" isstoredprocedure="true">
begin dbchem.scheda_xml('<substitute-value sql:name="lingua"/>'
                         ,?
                         ,'<substitute-value sql:name="codice"/>'
                         ,'<substitute-value sql:name="revisione"/>'
                         ,''); end;
        </query>
        <out-parameter sql:nr="1" sql:name="resultset2"
        sql:type="java.sql.Types.CHAR"/>
</execute-query>

Here is what I've written in xsp / Esql:

<esql:execute-query>
  <esql:call>
   	{call procedure.tds_xml(<esql:parameter direction="in" type="String"><xsp-request:get-parameter
name="lingua"/></esql:parameter>,
         	<esql:parameter direction="out" type="String"/>,
         	<esql:parameter direction="in" type="String"><xsp-request:get-parameter
name="codice"/></esql:parameter>,<esql:parameter direction="in" type="String"><xsp-request:get-parameter
name="revisione"/></esql:parameter>)}
       	</esql:call>
	      <esql:results>
  <output>
    <esql:call-results>
      <esql:get-string column="1" from-call="yes"/> 
    </esql:call-results>
  </output>
</esql:results>
</esql:execute-query>

And this is the error I get:
The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:

Exception in ServerPagesGenerator.generate() 

More precisely:

org.apache.cocoon.ProcessingException: Exception in
ServerPagesGenerator.generate(): java.lang.NullPointerException 

The full exception stack trace says something like:
Original exception : java.lang.NullPointerException 
at oracle.jdbc.ttc7.TTCAdapter.newTTCType(TTCAdapter.java:270) 
at
oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCColumnArray(TTCAdapter.java:256) 
at
oracle.jdbc.ttc7.TTCAdapter.createNonPlsqlTTCDataSet(TTCAdapter.java:231) 
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1363) 
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822) 
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1602) 
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1527) 
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2045) 
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:395)

at
oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:446) 
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute(EsqlQuery.java:362) 
at
org.apache.cocoon.components.language.markup.xsp.EsqlQuery.execute(EsqlQuery.java:336) 
at
org.apache.cocoon.www.scheda_tecnica.oracletestesql_risposta_xml.generate(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\oracletestesql_risposta_xml.java:414)

at
org.apache.cocoon.generation.ServerPagesGenerator.generate(ServerPagesGenerator.java:258)

at
org.apache.cocoon.components.pipeline.CachingEventPipeline.process(CachingEventPipeline.java:250)

at
org.apache.cocoon.components.pipeline.CachingStreamPipeline.process(CachingStreamPipeline.java:399)

at
org.apache.cocoon.www.scheda_tecnica.sitemap_xmap.matchN400065(C:\Program
Files\tomcat\work\Standalone\localhost\cocoon\cocoon-files\org/apache/cocoon/www/scheda_tecnica\sitemap_xmap.java:716)


Thank you







On Fri, 06 Dec 2002 12:52:37 +0200, "Gabriele Domenichini"
<gabridome@fastmail.fm> said:
> Thank you so much.
> I'll began the switching. If in the mean time a solution is found I'd
> prefere to use the sql transformer.
> 
> On Fri, 6 Dec 2002 11:38:22 +0100, "Christian Haul"
> <haul@dvs1.informatik.tu-darmstadt.de> said:
> > On 06.Dec.2002 -- 12:19 PM, Gabriele Domenichini wrote:
> > > I need to retrieve xml data from Oracle database as an out-parameter. The
> > > stored procedure works but the output is like this:
> > > &lt;rootElement&gt;
> > >    &lt;element&gt;
> > > Something written
> > >    &lt;/element&gt;
> > > &lt;/rootElement&gt;
> > > I think that SQL Transformer convert "<" and ">" signs in entities. I
> > > need desperately to have my code back. Please help me
> > 
> > No idea how to achieve this with the transformer, but with esql you
> > could use esql:get-xml for this (or enclose a get-string with
> > util:include-expr).
> > 
> > Switching to XSP would surely have a major impact but since you are
> > desparate....
> > 
> > I believe there has just been a similar thread, so have a look at the
> > archives. 
> > 
> > 	Chris.
> > -- 
> > C h r i s t i a n       H a u l
> > haul@informatik.tu-darmstadt.de
> >     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:     <cocoon-users-unsubscribe@xml.apache.org>
> > For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>
> > 
> > 
> -- 
>   Gabriele Domenichini
>   gabridome@fastmail.fm
> 
> ---------------------------------------------------------------------
> 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>
> 
> 
-- 
  Gabriele Domenichini
  gabridome@fastmail.fm

---------------------------------------------------------------------
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