RE: sql transformer bug?

Jonathan Spaeth Fri, 27 Jun 2003 13:03:30 -0700

Title: Message

Hehe; thanks.

Needless to say it's been a long day; sometimes you just need another pair of eyes to find the obvious flaws J

Thanks for the quick response!

Jon

-----Original Message-----
From: Leo Sutic [mailto:[EMAIL PROTECTED]
Sent: Friday, June 27, 2003 2:56 PM
To: [EMAIL PROTECTED]
Subject: RE: sql transformer bug?

'<sql:substitute-value sql:name="date">',

should be

'<sql:substitute-value sql:name="date"/>',

note the / at the end.

/LS

-----Original Message-----
From: Jonathan Spaeth [mailto:[EMAIL PROTECTED]
Sent: den 27 juni 2003 21:50
To: '[EMAIL PROTECTED]'
Subject: sql transformer bug?

Can somebody please point me in the right direction:

I am attempting to use the sql transformer to update an oracle database.
I am using a jdk 1.4
Running with cocoon version 2.1m2

Here is my sitemap:
                        <map:match pattern="create.xsql">
                                <map:generate src="">
                                <map:transform type="sql">
                                        <map:parameter name="use-connection" value="{global:sql-data-source}"/>
                                        <map:parameter name="date" value="date"/>
                                        <map:parameter name="time" value="time"/>
                                        <map:parameter name="clli" value="clli"/>
                                        <map:parameter name="remarks" value="remarks"/>

                                </map:transform>
                                <map:serialize/>
                        </map:match>

Here is my xsql input file:

<?xml version="1.0"?>
<page>
        <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
                <sql:query isupdate="true">
        INSERT INTO NOC_EQUIPMENT_TROUBLES (
         trouble_id, trouble_date, trouble_time, trouble_clli, trouble_remarks
        )
        VALUES (
         NOC_EQUIPMENT_TROUBLES_SEQ.NEXTVAL,
         '<sql:substitute-value sql:name="date">',
         '<sql:substitute-value sql:name="time">',
         '<sql:substitute-value sql:name="clli">',
         '<sql:substitute-value sql:name="remarks">'
        )
                </sql:query>
        </sql:execute-query>
</page>

Here is my flow script:
function jxFormMain(form) {
        var page = null;

        while (true) {
                page = cocoon.request.getParameter("/page");
                if (page == null) {
                        form.setModel(new java.util.HashMap());
                        form.sendView("index.xform");
                }
                else if (page == "create") {
                        form.sendView("create.xform");
                        form.sendView("create.xsql");
                }
        }
}

When I attempt to view create.xsql, the following exception is thrown from the SQL Transformer:

Original Exception: java.lang.IllegalStateException: SQLTransformer: Not expecting a start substitute value element
        at org.apache.cocoon.transformation.SQLTransformer.throwIllegalStateException(SQLTransformer.java:361)
        at org.apache.cocoon.transformation.SQLTransformer.startSubstituteValueElement(SQLTransformer.java:547)
        at org.apache.cocoon.transformation.SQLTransformer.startTransformingElement(SQLTransformer.java:716)
        at org.apache.cocoon.transformation.AbstractSAXTransformer.startElement(AbstractSAXTransformer.java:330)
        at org.apache.cocoon.components.sax.XMLTeePipe.startElement(XMLTeePipe.java:118)
        at org.apache.xerces.parsers.AbstractSAXParser.startElement(Unknown Source)
        at org.apache.xerces.impl.XMLNSDocumentScannerImpl.scanStartElement(Unknown Source)
        at org.apache.xerces.impl.XMLDocumentFragmentScannerImpl$FragmentContentDispatcher.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.DTDConfiguration.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.components.source.SourceUtil.parse(SourceUtil.java:198)
        at org.apache.cocoon.generation.FileGenerator.generate(FileGenerator.java:140)
                ....

Am I formatting the input xml incorrectly or what?

Please help.
Thanks,
Jon

RE: sql transformer bug?

Reply via email to