cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <D.Ski...@hzd.hessen.de>
Subject SQL Transformer ERROR
Date Tue, 30 Nov 2004 11:24:13 GMT
Hi,

I am attempting to use the sql transformer to make an insert to an oracle database.
Running with cocoon version 2.1.4

Here is my sitemap:

<map:match pattern="soapcall">
  <map:generate type="wsproxy" src="{global:proxyurl}/cocoon/EWO_Request/soapcall"/>
  <map:transform type="xslt" src="xsl/XMELD_Trefferliste.xsl"/>
  <map:transform type="sql">
       <map:parameter name="use-connection" value="oraclepool"/>
  </map:transform>
  <map:serialize type="html"/>
</map:match>


Here is my xsl:

   <xsl:template match="/">
        <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
            <sql:query isupdate="true">INSERT INTO ewo_log ( ewo_lg_persnr , ewo_lg_xml,
ewo_lg_status, EWO_LG_GKZ, EWO_LG_STRASSE, EWO_LG_GESCHLECHT, EWO_LG_FAMNAME, EWO_LG_VNAME,
EWO_LG_GEBDATUM)
                VALUES ( 'EWO-User','<xsl:copy-of select="/"/>/&gt;','0401','<xsl:value-of
                select="datenuebermittlung.antwortbenutzerdefiniert.0401/uebermittelte.person/angefragtes.suchprofil/anschrift.lokal/gemeindeschluessel/schluessel"/>',
'<xsl:value-of
                select="datenuebermittlung.antwortbenutzerdefiniert.0401/uebermittelte.person/angefragtes.suchprofil/anschrift.lokal/strassenschluessel"/>',
'<xsl:value-of
                    select="datenuebermittlung.antwortbenutzerdefiniert.0401/uebermittelte.person/angefragtes.suchprofil/geschlecht/geschlecht/schluessel"/>','<xsl:value-of
                select="datenuebermittlung.antwortbenutzerdefiniert.0401/uebermittelte.person/angefragtes.suchprofil/name/NACHNAME/nachname"/>',
'<xsl:value-of
                select="datenuebermittlung.antwortbenutzerdefiniert.0401/uebermittelte.person/angefragtes.suchprofil/name/VORNAME/vorname"/>',
'<xsl:value-of
                select="datenuebermittlung.antwortbenutzerdefiniert.0401/uebermittelte.person/angefragtes.suchprofil/geburt/tagdergeburt"/>'
) </sql:query>
        </sql:execute-query>
        <html>
        ...

When I attempt to make this transformation, the following exception is thrown from the SQL
Transformer

Failed to execute pipeline.

org.apache.cocoon.ProcessingException: Failed to execute pipeline.: java.lang.RuntimeException:
java.lang.IllegalStateException: SQLTransformer: Not expecting an end execute query element

cause: java.lang.RuntimeException: java.lang.IllegalStateException: SQLTransformer: Not expecting
an end execute query element

full exception chain stacktrace[hide] 

Original Exception: java.lang.RuntimeException: java.lang.IllegalStateException: SQLTransformer:
Not expecting an end execute query element
        at org.apache.xalan.transformer.TransformerImpl.run(TransformerImpl.java:3411)
        at org.apache.xalan.transformer.TransformerHandlerImpl.endDocument(TransformerHandlerImpl.java:427)
        at org.apache.cocoon.xml.AbstractXMLPipe.endDocument(AbstractXMLPipe.java:91)
        at org.apache.cocoon.transformation.TraxTransformer.endDocument(TraxTransformer.java:583)
        at org.apache.xerces.parsers.AbstractSAXParser.endDocument(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentScannerImpl.endEntity(Unknown Source)
        at org.apache.xerces.impl.XMLEntityManager.endEntity(Unknown Source)
        at org.apache.xerces.impl.XMLEntityScanner.load(Unknown Source)
        at org.apache.xerces.impl.XMLEntityScanner.skipSpaces(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentScannerImpl$TrailingMiscDispatcher.dispatch(Unknown
Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XML11Configuration.parse(Unknown Source)
        at org.apache.xerces.parsers.XMLParser.parse(Unknown Source)
        at org.apache.xerces.parsers.AbstractSAXParser.parse(Unknown Source)
        at org.apache.excalibur.xml.impl.JaxpParser.parse(JaxpParser.java:318)
        at org.apache.excalibur.xml.impl.JaxpParser.parse(JaxpParser.java:337)
        at org.apache.cocoon.generation.WebServiceProxyGenerator.generate(WebServiceProxyGenerator.java:158)
        at org.apache.cocoon.components.pipeline.AbstractProcessingPipeline.processXMLPipeline(AbstractProcessingPipeline.java:581)
        at org.apache.cocoon.components.pipeline.impl.AbstractCachingProcessingPipeline.processXMLPipeline



Where i my mistake.
Thanks for your help.

Gruß Dirk
 
----------------------------------------
Dirk Skirde
Hessische Zentrale für Datenverarbeitung
Mainzer Strasse 50  Raum 009
65189 Wiesbaden
Tel.:  +49 611 340 1941
Fax:   +49 611 340 5941
EMail: d.skirde@hzd.hessen.de

Mime
View raw message