SQL Transformer ERROR

D.Skirde Tue, 30 Nov 2004 03:25:01 -0800

Title: SQL Transformer ERROR

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=""> <map:transform type="xslt" src=""> <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="/"/>/>','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: [EMAIL PROTECTED]

SQL Transformer ERROR

Reply via email to